The Font Changes Automatically in Excel – 2 Solutions

This is the sample dataset.

Solution 1 – Using the Format Cells Feature

Steps:

• Select the whole dataset and right-click.
• Choose “Column Width”.

• Change the column width and click OK.

The font size changes.

Solution:

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

• Check “Wrap text” in “Alignment”.
• Click OK.

• If you change the size of the table, the font won’t change.

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

Solution 2 – Using the Excel Options

Steps:

• Open your workbook and go to “File”.

• Click “Options”.

• In “Excel Options”, choose “Font” and “Font size” in “General”.
• Click OK.

• A new workbook will open and you will see your chosen font and font size.

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

Download Practice Workbook

Download the practice workbook.

Related Articles

• How to Change Font Style in Excel
• How to Increase Font Size for Printing in Excel
• How to Change Font Size in Excel
• Increase Font Size Using Keyboard in Excel
• [Fixed!] Unable to Change Font Color in Excel
• How to Change Font in Excel for All Sheets
• How to Change Font Within Formula in Excel

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