[Solved!] Font Changes Automatically in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

Steps:

  • 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

Solution:

  • 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-

Steps:

  • 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.


Conclusion

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

What is ExcelDemy?

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

Tags:

Wasim Akram
Wasim Akram

Wasim Akram, BSc, Industrial and Production Engineering, Ahsanullah University of Science & Technology, has been working with the ExcelDemy project for 10 months. Currently working as as Excel and VBA content developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He published almost 150 articles and has many more coming. He is very passionate about learning new things about Microsoft office Suite and Data analysis.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo