• Excel Video Tutorials

Excel - Format Fonts


Formatting is one of the unique ingredients in Microsoft Excel, where you can modify the default appearance of the worksheet and highlight the text depending on the priority.

Different ways to format fonts are Font name, Font color, Font size, Font style, and Effects. For example, if doctors want to highlight patients diagnosed with hypertension, they can easily format the fonts by changing their font color, style, etc., in Microsoft Excel.

Change Font Name in Microsoft Excel

You may use the following steps to alter the Font Name.

1. First, select the cell range B2:D8 in Microsoft Excel.

How to Change the Font Name in Microsoft Excel

2. Go to the Home tab, expand the Font option, and select the "Aptos Serif" from the drop-down menu.

Aptos Serif from drop-down Menu 1

Aptos Serif from drop-down Menu 2

3. Now, select the cell range B2:D2 and in the Font group, expand the font size option and select the 14 from the drop-down list to modify the texts font size.

Expand Font Size Option From Drop-down List in Excel

Therefore, the size of the selected cell range has been changed.

Change Font Color of Text

By default, the Excel font color of the text is black. You can change the Font color by choosing the Font tab in the Format Cells dialog box or using the Font Color option under the Font group.

Multiple steps to change the Font color are written below

First, select the range of cells C3:C8 in the given worksheet.

How to Change the Font Color of the Text

After that, expand the Font Color tile and choose the Orange, Accent 2 color from the given menu.

Expand Font Color in Excel

Therefore, the Font color of the selected range of the cells has been altered.

Font color of Selected Range in Excel

Change Font Style in Microsoft Excel

The four basic Font styles named Bold, Italic, Underline, and Double Underline are inclusive in the Microsoft Excel. The different icons for these font styles are presented in the Font group.

Keyboard Shortcuts to Change the Font Style

  • Use the "CTRL+ B" keys to change the font style to Bold.
  • Use "CTRL+ I" keys to change the font style in Italics.
  • Use "CTRL+ U" keys to modify the font style in Underline.
  • Use the "CTRL+5" to apply the Strikethrough in the specific cell ranges.

Example

Lets say you wish to apply the "Double Underline" style for the highest sales production of the given dataset. Select the D3 cell and choose the "Double Underline" icon under the Font group.

How to Change the Font Style in Microsoft Excel

Change the Font Style in Microsoft Excel

You can select the range B2:D2 cells and press the "ctrl+I" keys to change the font style in the Italics.

Change The Font Style in Excel

Therefore, column heading is changed in the Italics.

Apply the Effects to a Range of Cells

Given below are the steps to apply the Effects to the selected range of the cells.

Step 1 − Select the range B3:B8 and press the "ctrl+1" keyboard keys to open the Format Cells dialog box.

Step 2 − In the Format Cells dialog box, move to the Font tab, select the "Strikethrough" option under the Effects section, and press the OK button to apply these changes.

How to Apply the Effects to a Range of the Cells

Therefore, the Strikethrough effects has been applied to the selected range of the cells.

Strikethrough Effects in Excel