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

Get FREE Advanced Excel Exercises with Solutions!

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.

Table of Contents hide

Download Practice Workbook

3 Simple Methods to Change Font in Excel for All Sheets

1. Select All Sheets and Change Font

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

3. Using VBA to Change Font for All Sheets

Conclusion

Download Practice Workbook

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

Change Font for All Sheets.xlsm

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.

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

Now change the font while all worksheets are selected.

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

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.

Note:

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

Similar Readings

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.

Again, for this process, 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

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.