Excel 2013 & 2016: Formatting: The Font Group

Updated 2013.08.05

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 https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image001.jpg on the Home tab.

Font formatting

To achieve this:

Do this:

Keyboard Shortcut

  https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image009.jpg

Change font name

       Click on the Home tab.

       Use the font drop-down box: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image010.jpg

 

Change font size

       Click on the Home tab.

       Use the font size drop-down box: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image011.jpg

 

Make text bold

       Click on the Home tab.

       Click on the bold button: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image012.jpg

<ctrl>+B

Make text italic

       Click on the Home tab.

       Click on the italic button: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image013.jpg

<ctrl>+I

Make text underlined

       Click on the Home tab.

       Click on the underline button: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image014.jpg

<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. https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image030.jpg

       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.

 

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image031.jpg

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: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image015.jpg 

       Click on the desired color.

https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image016.jpg

 

Set background color

       Click on the Home tab.

       In the Font group, click the down-arrow on the fill color button: https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image017.jpg

       Click on the desired color.

 https://p3plcpnl0895.prod.phx3.secureserver.net:2078/public_html/Excel/2013/003-Formatting_files/image018.jpg 

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