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

Get FREE Advanced Excel Exercises with Solutions!

Changing the font in Excel for all sheets means modifying the font style, size, or formatting entirely for all the worksheets in a workbook. To make the visual appearance more attractive and enhance the readability, you can change the font in Excel for all sheets.

In this Excel tutorial, you will learn 4 simple ways to change the font for all sheets. You can use the Font option from the Home tab, the Page Layout tab, the Context Menu, and a VBA code to change the font for all sheets.

Here, I have considered a workbook with 3 sheets named ‘Graph’, ‘Fill Handle’, and ‘Array Formula’. My purpose is to change the font on all the sheets.

Overview of Changing Font in Excel for All Sheets

Here are 4 simple ways to change the font in Excel for all sheets:

Using Font Option from Home Tab

To change the font in Excel for all sheets, use the Font option from the Home tab. In the Font option, there is a list of some built-in fonts. You can change the font for a certain cell, a range of cells, or the entire area for all sheets.

Here are the steps to change the font in Excel for the entire area of all sheets with the Font option from the Home tab:

  1. Open the first worksheet.
  2. Click on the top left square of the worksheet.
    Selecting the small arrow on the top-left corner of all cells
  3. Hold the Ctrl key and click on the Sheet Tabs.
    Or, you can hold the Shift key and click on the last sheet tab to select all the sheets.
    Pressing & holding Ctrl and click on the sheets
  4. Go to the Home tab > Font group > Font.
    Change the font while all worksheets are selected
  5. Select a font.
    Selecting a Font

Finally, you have changed the font in Excel for all sheets.

Output After Changing Font

Note
You can install a new font and restart Excel to have the installed font in the Font section.

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

Using Font Option from Context Menu

You can change the font in Excel for all sheets using the Font option from the Context Menu. Follow the steps:

  1. Select the entire area.
  2. Select all the sheets from the sheet tab.
  3. Right-click on the mouse > Font.
    Changing Font with the Context Menu
  4. Expand the Font drop-down.
  5. Select a font.
    Selecting Font from the Font

Thus, you can change the font in Excel for all sheets with the Font option from the Context Menu.

Output After Changing Font with Context Menu

Using Theme Fonts Option from Page Layout Tab

The Theme Font feature from the Page Layout tab changes the font of all the sheets in a workbook. There is no need not select the sheets separately.

To change the font for all sheets with the Theme Font option from the Page Layout tab:

  1. Go to the Page Layout tab > Themes group > Font.
  2. Pick a font from the available fonts.
    From Page Layout ribbon. Press the “Fonts” menu

You have the output after changing the font in Excel for all sheets.

Output of Changing all sheets with Theme Font

Note
You can not change the font of a certain cell or a range of cells with the Theme Font feature.

Read More: [Fixed!] Excel Default Font Is Not Changing

Using a VBA Code

VBA or Visual Basic for Applications is the most advanced way to change fonts in Excel for all sheets. Just apply a simple VBA code. There is no need to select cells or sheets.

Follow the steps to change the font for all sheets with VBA:

  1. Go to the Developer tab > Code group > Visual Basic to open Visual Basic Editor.
    Opening Visual Basic Editor
  2. Go to the Insert tab > Module.
    Generating a Module
  3. Copy and paste the following VBA code:
    Sub ChangeFontforAllSheets()
    For Each Worksheet In Worksheets
    Worksheet.Activate
    ActiveSheet.UsedRange.Select
    Selection.Font.Name = "Raleway"
    Next
    End Sub
  4. Click on Run.
    Executing the VBA Code

Finally, you have changed the font in Excel for all sheets.

Changing output with VBA

Note
If you don’t see the Developer tab in the ribbon, you have to enable the Developer tab from Excel Options.

Read More: How to Change Font Within Formula in Excel

Download Practice Workbook

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

Conclusion

In the article, you have learned 4 simple ways to change the font in Excel for all sheets. The methods include the use of the Font option from the Home tab, the Page Layout tab, or the Context Menu. You have also learned the use of a VBA code to change the font for all sheets. If you have any questions, concerns, or suggestions, please leave them in the comments section.

Frequently Asked Questions

What is the keyboard shortcut to change the font in Excel for all sheets?

You can press the Ctrl + Shift + F buttons to open the Format Cells dialog box and change the font from the Font section.

Is it possible to use a new font for all sheets in Excel?

Absolutely, you just need to install a new font and restart Excel to have the installed font in the Font section. Then, you can use the newly installed font to change the font for all sheets.

How to revert to the default font for all sheets in Excel?

Select all the sheets and set the font to the default font from the Font section under the Home tab.

Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo