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.
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:
- Open the first worksheet.
- Click on the top left square of the worksheet.
- 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.
- Go to the Home tab > Font group > Font.
- Select a font.
Finally, you have changed the font in Excel for all sheets.
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:
- Select the entire area.
- Select all the sheets from the sheet tab.
- Right-click on the mouse > Font.
- Expand the Font drop-down.
- Select a font.
Thus, you can change the font in Excel for all sheets with the Font option from the 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:
- Go to the Page Layout tab > Themes group > Font.
- Pick a font from the available fonts.
You have the output after changing the font in Excel for all sheets.
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:
- Go to the Developer tab > Code group > Visual Basic to open Visual Basic Editor.
- Go to the Insert tab > Module.
- 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
- Click on Run.
Finally, you have changed the font in Excel for all sheets.
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
- How to Change Font Size in Excel
- How to Increase Font Size for Printing in Excel
- How to Lock Font in Excel
- [Solved!] Font Changes Automatically in Excel
- [Fixed!] Unable to Change Font Color in Excel
- How to Increase Font Size Using Keyboard in Excel
- How to Change Font in Excel to All Caps
<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!