How to Set the Default Font and Font Size for New Workbooks in Excel

Last Updated: Feb 14, 2024 by

When creating a new workbook in Excel, you may find yourself constantly changing the font and font size to fit your preferences. This can be time-consuming and tedious, especially if you use the same font and size for all your workbooks. Luckily, there is a way to set the default font and font size for all new workbooks in Excel. In this article, we will guide you through the steps to do so.

Step 1: Open Excel

The first step is to open Excel on your computer. Once it is open, click on the “File” tab in the top left corner of the screen.

Step 2: Click on “Options”

In the “File” tab, click on “Options” in the left-hand menu. This will open a new window with various Excel options.

Step 3: Go to “General” tab

In the “Excel Options” window, click on the “General” tab on the left-hand side. This will bring up a list of general settings for Excel.

Step 4: Find “When creating new workbooks” section

Scroll down until you find the “When creating new workbooks” section. This is where you can set the default font and font size for all new workbooks.

Step 5: Select font and font size

In the “When creating new workbooks” section, you will see a drop-down menu for “Use this as the default font” and a drop-down menu for “Font size”. Click on each drop-down menu and select the font and font size you want to use as the default for new workbooks.

Step 6: Click “OK”

Once you have selected your desired font and font size, click on the “OK” button at the bottom of the window. This will save your changes and close the “Excel Options” window.

Step 7: Create a new workbook

To test if your changes have been applied, create a new workbook by clicking on the “File” tab and then selecting “New” from the left-hand menu. Your new workbook should now have the default font and font size that you selected in the previous steps.

Additional Tips

  • If you want to change the default font and font size for an existing workbook, you can do so by selecting all the cells in the workbook (by clicking on the triangle in the top left corner) and then changing the font and font size in the “Home” tab.
  • You can also change the default font and font size for specific types of workbooks, such as templates or macros, by selecting the appropriate option in the “Excel Options” window.

By following these simple steps, you can save time and effort by setting the default font and font size for all new workbooks in Excel. This can also help maintain consistency in your workbooks and make them more visually appealing.

Have you tried this method? Do you have any other tips for customizing Excel? Let us know in the comments.

Gulrukh Ch

About the Author: Gulrukh Ch

Gulrukh Chaudhary, an accomplished digital marketer and technology writer with a passion for exploring the frontiers of innovation. Armed with a Master's degree in Information Technology, Gulrukh seamlessly blends her technical prowess with her creative flair, resulting in captivating insights into the world of emerging technologies. Discover more about her on her LinkedIn profile.