Excel 2019/365: Formatting: The Font Group

Updated 2019-08-09

Objectives

         Set font name, size, and style

         Add/remove cell borders

         Set text color and fill (background) color

 

Note: Before doing any formatting commands, the cells must be selected (highlighted) first. Use the fat white plus sign to select cells.

 

Great tip: To copy an existing format, use the format painter button  on the Home tab.

Font formatting

To achieve this:

Do this:

Keyboard Shortcut

 

Change font name

       Click on the Home tab.

       Use the font drop-down box:

 

Change font size

       Click on the Home tab.

       Use the font size drop-down box:

 

Make text bold

       Click on the Home tab.

       Click on the bold button:

<ctrl>+B

Make text italic

       Click on the Home tab.

       Click on the italic button:

<ctrl>+I

Make text underlined

       Click on the Home tab.

       Click on the underline button:

<ctrl>+U

Add/remove cell borders

Note that the border selections have names.

Add borders

Select the cells whose borders you want to change. Then either (1):

       Click on the Home tab.

       Click on the down-arrow on the borders button.

       The menu shown to the right will appear.

       Click on the desired border.

 

Or (2) if you want more options (e.g. changing border thickness, color, or style):

       Click on More Borders (last option on the menu).

 

Note that each border selection has a name.

 

Cell and text colors

To achieve this:

Do this:

Set font color

       Click on the Home tab.

       In the Font group, click the down-arrow on the font color button:  

       Click on the desired color.

 

Set background color

       Click on the Home tab.

       In the Font group, click the down-arrow on the fill color button:

       Click on the desired color.

  

Note that each color has a name, which will appear in a yellow "tool tips" box when the mouse is held over it. The fifth color in the first row (see above) is "Blue, Accent 1".