How to apply an Auto format to a Range

To apply an Auto Format to a Range:

1.  Select the range

how to apply an auto format to a range

 

2.  Click the ‘Auto format command on the Quick Access Toolbar – If you do not have the Auto Format listed on your Quick Access Toolbar, then see the ‘Tip’ section below to know how to put the Auto Format command on the Quick Access Toolbar. 

how to apply an auto format to a range - 1a

 

 

3.  The Auto format dialog box will appear on the screen with a list of formats available – see the diagram below.

how to apply an auto format to a range 2

 

4.  Select the format you want to apply to your selected range 

5.  Click the OK button at the bottom of the dialog box

Excel would have applied the formatting for you.

how to apply an auto format to a range 3

 

Tip: How to get the Auto format command to appear on the Quick Access Toolbar

1.  Click the down arrow at the right hand side of the Quick Access Toolbar

2.  Scroll down to ‘More Commands’ and click on it – see the diagram below

how to get auto format command on the quick access toolbar

 

3.  The Excel Options Dialog Box will appear on the screen

how to get the auto format command on the quick access toolbar 2

 

 

4. Click the down arrow on the right of Popular Commands (see diagram below)

how to get auto format command on the quick access toolbar 3

 

4.  Scroll down to ‘Commands not in the ribbon’ and Click on it

How to get auto format command on quick access toolbar 3

 

5.  Scroll down to the ‘Auto Format’ command and Click on it

Click the ‘Add’ button

Click the OK button at the bottom of the Excel Options Dialog box

How to get auto format command on quick access toolbar 4

 

 

6.  Excel would have added the ‘Auto Format’ command to the Quick Access Toolbar for you (see the diagram below)

How to get auto format command on quick access toolbar 5

 

 

 

Lesson 38: How to apply Conditional Formatting to a Range

 

Submit a Comment

Your email address will not be published. Required fields are marked *