Excel Fonts (All Things You Need to Know)

In this article, you will learn how to work with Excel Fonts, namely how to change the font size, style, style within a formula, size when printing, in all sheets or in an existing workbook, lock the font, and solve font-related problems.

Excel Fonts play a crucial role in the visual appeal and readability of Excel spreadsheets. They can make data stand out, convey important information, and improve overall data presentation. Here, we will provide you with the knowledge and skills you need to lock fonts and prevent unauthorized changes. It is necessary if you want to maintain the accuracy of your data.

Download Practice Workbook

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

Fonts in Excel.xlsx

How to Change Font Size in Excel

Here we will discuss three effective ways to change the font size in Excel.

1. Using the Excel Ribbon Options

Changing the font size is not difficult if you know the tricks. Here we will show an easy method where we utilize the Excel ribbon.

Select the cell containing the text you want to change.
Click on the Down Arrow, next to the size box on the Format Bar.
Now, there are a ton of different text size options in ascending order. You can choose your size accordingly.

We have chosen font size 10 and the corresponding result is given below.

2. Using Shortcut Keys

In Excel, you can change your font size by simply following the above-mentioned method.

Select your intended cell where your data resides.
Now, press the Alt+H keys together. The corresponding shortcut keys will appear on the Ribbon.

Press the F+G keys on the keyboard simultaneously to increase your font size using keyboard.
Or, press the F+K keys to decrease your font size. Here, the output is shown by decreasing the font from 12 to 11.

3. Using the Cell Styles Option

You can accomplish the same task by employing a specified Cell Style available in Excel. It is to be noted that it will increase or decrease every font in our Excel file, irrespective of selecting a specific region.

First, select Home > Cell Styles > Normal.
Right-click on Normal then select the Modify option.

Click on the Format.

Select the Font tab, then choose any of the font sizes you wish to proceed with. Press OK afterward.

The dialogue box will disappear and then press OK.

Here is our output with a font size of 14.

How to Change Font Style in Excel

We can do many computations on any dataset using Excel’s capabilities and functions. 6 interesting approaches to customizing Excel’s font style are discussed here. Therefore, you can change the font style in Excel using one of the methods.

1. Configure Font Style Through Font Group Commands

In most cases, you may find a helpful preset command to alter the font style under Excel by looking in the Font Group Commands. One of the main benefits of Font Group Commands is the time it saves you while making changes to the font’s look.

First, select the range of cells. Then, click the Home tab, followed by the Font icon.
Consequently, the Font Group Commands bar will appear, and then tap B to bold the selected values.

Eventually, it will provide the desired outcome, as seen below.

2. Use the Font Setting Icon to Change the Font Style in Excel

Using the Font Settings Icon is another fascinating method for changing the font style in Excel. Using the Font Settings icon, we will Bold and Italic the values of the Designation column.

First, select the range E5 to E10, then, go to the Home tab and click the Font Settings icon.

Consequently, the Format Cells window will pop up, choose Bold Italic, and later hit OK.

Finally, it will provide the desired result, as demonstrated below.

3. Customize Font Style with a Keyboard Shortcut

Using a Keyboard Shortcut, we may change the font style in Excel. Both Ctrl+1 and Ctrl+Shift+F lead to the Format Cells dialog box. The methods below describe how to change the Font Style in Excel using the Keyboard Shortcut.

First, choose the range from B6 to E6.
Second, press Ctrl+1 or Ctrl+Shift+F to make the Format Cells dialog box will appear.
After that, choose Californian FB and Italic. Now, click OK.

As a result, it will ultimately provide the intended effect.

4. Modify Font from the Excel Theme Settings

We can also change the font style from the Theme Setting. Please follow the steps below to change the font style using Excel Theme Settings.

Firstly, navigate to Page Layout to get Themes Groups.
Secondly, go to the Font icon and then find and click Axial.

As a consequence, it will eventually produce the desired result.

How to Change Font Color in Excel

Here, we will show how to change the font color in Excel.

First, select the range of cells, go to the Home tab, and select the Font Color option.
Then, choose your desired color as shown below.
As a result, the color of your selected cells will change, as shown below.

How to Change Font Case Using Formulas in Excel

Here, we will demonstrate three ways to change font cases using formulas in Excel.

1. Insert UPPER Function to Change Font to All Caps

In this method, we will use the UPPER function. The UPPER function changes the text fonts to uppercase in Excel documents. Let’s follow these procedures.

Firstly, write down the following formula in cell F5.

=UPPER(D5)

Here, the UPPER function converts D5 texts into upper case.
Hit enter and Autofill the other cells by dragging F5 down.
Hence, the text fonts are in all caps now.

2. Insert LOWER Function to Change Font to All Lowercase

In this method, we will use the LOWER function. The lower function changes the text fonts to lower in Excel documents. Let’s follow these procedures.

Firstly, write down the following formula in cell F5.

=LOWER(D5)

Here, the LOWER function converts D5 texts into lowercase.
Hit enter and Autofill the other cells by dragging F5 down.
Hence, the text fonts are in lowercase now.

Changing Fonts for All Sheets by Using the Themes Option of Page Layout Ribbon

Page layout ribbon is a handy tool to alter the fonts in all or multiple selected worksheets. In the following method, we will hover over the shortest method to change the font in Excel for all sheets.

Now we will go to the Page Layout ribbon and select the “Fonts” menu in the Themes section.
We have selected Arial. Here Excel Users will select their required or preferred font.

How to Lock Font in Excel

Making locked cells is a straightforward approach in Excel. We can lock font in Excel using the Format Cells and Protect Sheet features.

Select the range of cells as shown below and press Ctrl+1 to open up the Format Cells dialog box.

Uncheck Locked and Hidden and click OK.

Now, click Review > Protect Sheet.

Now, we will set a password, and then check Select locked cells and Select unlocked cells in the Protect Sheet option.

Finally, in the Confirm Password popping dialog box, we have reentered and protected the sheet.

We can see that the Font and other sections of the Ribbon are grayed out, which indicates we have locked the font options for the selected range.
Therefore, we have locked down the data from further styling changes.

Things to Remember

You can utilize cell styles to change the default font in the existing Excel workbook.
If you cannot find your preferred font, you can use Customized Fonts to create your own font style.
You can change font style through Excel VBA.
You can modify from the font group and change from the format cells dialog box when the default font is not changing in Excel.

Frequently Asked Questions

1. Is it possible to change the font color in Excel?

Yes, you can change the font color in Excel. Select the cell or range of cells you want to modify, go to the Home tab, and locate the Font Color button in the Font group. Click on the button and choose a color from the palette, or click on “More Colors” to select a custom color.

2. Can I apply a specific font to an entire Excel worksheet?

Yes, you can apply a specific font to an entire Excel worksheet. To do this, right-click on the worksheet tab at the bottom, select “Select All Sheets,” and then proceed to change the font as desired using the Font group in the Home tab.

3. How do I change the font size of a specific cell or range in Excel?

To change the font size of a specific cell or range in Excel, select the desired cell(s) and go to the Home tab. In the Font Size drop-down box in the Font group, choose the desired font size from the list, or manually type the font size in the box.

Excel Fonts: Knowledge Hub

<< Go Back to Excel Cell Format | Learn Excel

Conclusion

That’s the end of today’s session. I believe you will be able to select the most suitable fonts for different types of data, how to format text effectively for improved readability, and how to leverage advanced font formatting options to create professional-looking spreadsheets as of now. Keep learning new methods and keep growing!

Get FREE Advanced Excel Exercises with Solutions!