Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Advanced
What is the main benefit of using Styles?
The formatting elements you use with Styles can be shared across other Office apps
It is easy to update all similarly formatted cells at once if it is needed
The color choices are better with styles than with standard formatting alone
2
Advanced
The quickest way to apply a currency style to a set of numbers is to select the values, then:
Go to the Home tab, click Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), then choose Currency
Right click the selection, choose Format Cells, select Numbers, select Currency and click OK
Go to the Home tab and click the $ on the Numbers group
3
Advanced
How do you modify a custom style to force the changes through your workbook?
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery). Delete the old style, then click New Style and name it the same as the old style.
Go to the Home tab, click the Cell Styles menu (or the indicator in the bottom right corner of the Styles gallery), right-click your Style, and choose Modify.
Right-click any cell that uses the style, and choose “Modify cell style”.
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement