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
Beginner
How do you modify a built-in Excel Cell Style?
Right-click on the Cell Style and click ‘Modify…’
You cannot change the properties of a built-in Excel Cell Style.
Create a new style that has the properties you require. Then, click on ‘Merge Styles…’ from the ‘Cell Styles’ dropdown menu on the ‘Home’ tab and select the Cell Style you wish to change.
Don’t know
2
Beginner
How do you import Cell Styles from another workbook?
Ensuring the old workbook that has the Cell Styles you require is open, in the new workbook click on ‘Merge Styles…’ from the ‘Cell Styles’ dropdown menu on the ‘Home’ tab and select the old workbook.
In the old workbook, highlight all of the Cell Styles you wish to copy from the ‘Cell Styles’ dropdown on the ‘Home’ tab, right-click and select ‘Copy’ and then in the new workbook, select the same menu, right-click and select ‘Paste Styles’.
In the old workbook, use the Format Painter to copy the format you require and then paste it into the new workbook. This will bring across that Cell Style.
Don’t know
3
Beginner
Which of the following statements is not true regarding Excel’s Cell Styles?
You may only have a maximum of 255 Cell Styles in a workbook
When a new Cell Style is first created, the cell(s) selected at the time will not change accordingly.
Cell Styles may be copied using the Format Painter.
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement