Focus video player for keyboard shortcuts
Auto
- HD
- 720p
- 540p
- 360p
1.00x
cc
- 0.50x
- 0.75x
- 1.00x
- 1.25x
- 1.50x
- 1.75x
- 2.00x
We hope you enjoyed this lesson.
Cool lesson, huh? Share it with your friends
About this lesson
Learn how to apply built-in number styles and create your own custom styles packages.
Exercise files
Download this lesson’s related exercise files.
Styles28.9 KB Styles - Completed
29.2 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 across 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, go to the Home tab > Cell Styles > Heading 2
- These styles will be the same throughout 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.