Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Change Font in Excel for All Sheets (3 Suitable Ways)

In many cases, we require to change font size for better presentation, visualization, and explanation purposes. And our Excel data has multiple worksheets where changes need to be placed through multiple worksheets. In this article, we are going through the steps where we will learn how to select multiple sheets at once and make changes altogether in a workbook by applying actions in just one sheet. So, let’s get started and follow the procedures on how to change the font in Excel for all sheets.


Download Practice Workbook

You can download the practice workbook from the following download button.


3 Simple Methods to Change Font in Excel for All Sheets

Changing Fonts After Selecting All Worksheets and Using Cell Style Changing the Fonts, these two methods require selecting multiple worksheets manually however the remaining two methods: Changing Fonts Using Page Layout Ribbon and Using VBA Changing the Fonts these two methods do not require selecting multiple worksheets manually.


1. Select All Sheets and Change Font

In the first method, we will demonstrate a font change across all the worksheets. The main key point here is to press & hold Ctrl and select other worksheets to make them active sheets which means any change in a single sheet will propagate to other selected sheets.

📌 Steps:

  • Firstly, we will select the small arrow on the top-left corner of all cells in a worksheet and the result will look like the image below.

Selecting the small arrow on the top-left corner of all cells

  • Now press & hold Ctrl and click on the sheets where you need to place the font updates by changing fonts in a single sheet.

Pressing & holding Ctrl and click on the sheets

  • Now change the font while all worksheets are selected.

Change the font while all worksheets are selected

Eventually, this will result in a change all across the worksheets.

Read More: How to Change Default Font in Existing Excel Workbook


2. Changing Fonts for All Sheets by Using the Themes Option of Page Layout Ribbon

Page layout ribbon is a handy tool to alter the fonts in all or multiple selected worksheets. In the following method, we will hover over the shortest method to change the font in Excel for all sheets.

📌 Steps:

  • Now we will go to the Page Layout ribbon.
  • Press the “Fonts” menu in the Themes section.
  • We have selected Arial. Here Excel Users will select their required or preferred font.

From Page Layout ribbon. Press the “Fonts” menu

Note:

If your preferred font is not out there, you can use Customized Fonts… to create your own font style.

Read More: [Fixed!] Excel Default Font Is Not Changing (4 Quick Solutions)


3. Using VBA to Change Font for All Sheets

Changing fonts using VBA code is also an easy procedure to alter the fonts in Excel for all sheets. Follow the below steps and procedures to complete the task.

📌 Steps:

  • Before starting the process, notice that the font is Calibri.

Notice the font is Calibri

  • Again, for this process, press & hold Ctrl and click on the sheets where you need to place the font updates.

press & hold Ctrl and click on the sheets where you need to place the font updates

  • Enter the code here and Run the code like the below image.
Sub ChangeFontforAllSheets()
    For Each Worksheet In Worksheets
        Worksheet.Activate
        ActiveSheet.UsedRange.Select
        Selection.Font.Name = "Century"
    Next
End Sub

Enter the code here and Run

Read More: How to Change Font in Excel to All Caps (6 Simple Ways)


Conclusion

Follow these steps and stages on how to change font in Excel for all sheets. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.


Related Articles

Tags:

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo