Locked lesson.
About this lesson
Learn how to apply built-in number styles and create your own custom styles packages.
Lesson versions
Multiple versions of this lesson are available, choose the appropriate version for you:
Exercise files
Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.
Styles.xlsx28.2 KB Styles - Completed.xlsx
25.9 KB
Quick reference
Styles
Applying built-in number styles and creating our own custom styles packages.
When to use
Styles have many benefits, but probably the biggest is the ability to easily update the look and feel over our spreadsheets with minimal effort.
Instructions
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.