How to apply a Style to a Range

Excel comes pre-loaded with over 20 distinct styles. Each style containing: Cell Alignment, Number Format, Border, Fill Color, Size and Font. 

To apply these pre-loaded styles to a range:

1. Select the Range you wish to format – see the diagram below.

How to apply a Style to a Range

 

2. Click the Home tab

3. Under the Styles group, click the ‘Cell styles’ command

4. Choose / Left-Click the Style you want to apply. In the example I have in my diagrams below – I chose the ‘Note’ Style.

How to apply a Style to a Range 2

 

5. Excel performs the command for you.

Lesson 40: How to change the Column Width

 

Submit a Comment

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