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.
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.
5. Excel performs the command for you.
Lesson 40: How to change the Column Width