Applying built-in number styles and creating our own custom styles packages.
Where/when to use the technique
Styles have many benefits, but probably the biggest is the ability to easily update the look and feel over our spreadsheets with minimal effort.
Applying built-in styles
- Select D4:D20, go to the Home tab
- Apply the Currency style by clicking the $ sign on the Number group
- Select A3:D3, got to the Home tab --> Cell Styles --> Heading 2
- These styles will be the same through the entire workbook
Creating custom styles
- Go to the Home tab --> Cell Styles and click New Cell Style
- Enter “DE_Values” for the Style Name
- Uncheck Alignment, Font and Border, as we don’t want to control those (but we do the rest)
- Click Format
- Set the Number to Accounting with no symbols
- Set the Fill tab to a light green background
- On the Protection tab, uncheck the “Locked” checkbox and click OK
- Select D4:D20, go to the Home tab --> Cell Styles --> DE_Values
- Notice that your cells turn green. You can now educate your users to only enter data in the green cells
Updating built-in styles
- Assume head office asks you to turn the green to orange
- Go to the Home tab --> Cell Styles --> right click DE_Values and choose Modify
- Click Format, change the fill and click OK to return to the worksheet
- Every single cell in the workbook that has this style applied will update immediately to reflect the changes.
Lesson notes are only available for subscribers.