Excel 2013 & 2016: Formatting: The Font Group

Updated 2013.08.05


        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


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


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


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


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.



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.



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.


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