[Solved!] Font Changes Automatically in Excel

While working in Microsoft Excel, sometimes we face problems with font changes. This happens when we have a default setting applied in our Excel workbook. If you want, you can change the system settings easily. Today, in this article, I am sharing with you how to solve font changes automatically in Excel. Stay tuned!

Font Changes Automatically in Excel: 2 Simple Solutions

In the following, I have described 2 simple and easy methods to solve font changes automatically in Excel.

Suppose we have a dataset of some Employee Name, Total Attendance, Total Salary, and Employee Performance. Now, we will solve the font-changing problem in this table using some simple tricks.

1. Utilization of Format Cells Feature

You can simply use the Format Cells feature to solve font-changing problems in Excel. Sometimes while changing the column and row width, you will face the font of the cell value changing according to cell size. This happens when you have activated the “Shrink to fit” feature of Excel. Just remove the checkmark from the “Shrink to fit” option and the font will not change anymore.


  • Select the whole dataset and right-click the mouse button to get multiple options.
  • From the options choose “Column Width”.

 Utilization of Format Cells Feature

  • Next, from the new window, change the column width value and click OK to continue.

  • This time you will see the font size changes according to the shrinkage of the cells. This is the problem we often face while editing our dataset.
  • So, without moving here and there let’s go to our solution in the following.

 Utilization of Format Cells Feature


  • First, choose the whole table and press CTRL+1 to open the “Format Cells” window.

 Utilization of Format Cells Feature

  • After that, checkmark the “Wrap text” option from the “Alignment” feature.
  • Hence, click OK to continue.

 Utilization of Format Cells Feature

  • Now, if we change the size of the table you will see the values are wrapping instead of changing the font. Enjoy!

excel font changes automatically

Read More: How to Change Font in Excel to All Caps

2. Use of Excel Options to Solve Font Changes Automatically Issue

When you open a new workbook you will see a default font chosen inside the worksheet. This might irritate you while working. Well, I have come out with a simple solution for this. Using the Excel options you can solve font-changing automatic problems quickly. Follow the instructions below-


  • To start with, open your workbook and go to the “File” option from the top ribbon.

Use of Excel Options to Solve Font Changes Automatically

  • Next, click “Options” from the left pane.

  • Thereafter, from the new “Excel Options” window choose your desired “Font” and “Font size” from the “General” feature.
  • To finish, press OK.

Use of Excel Options to Solve Font Changes Automatically

  • Now, open a new workbook and you will see your default font and font size chosen for the new workbook. Thus changing the font automatically will not happen anymore. Simple isn’t it?

excel font changes automatically

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

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


In this article, I have tried to cover all the methods of solving font changing automatically in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!


Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF