Search for courses or lessons
Redeem a coupon
Start free trial
What is the main benefit of using Styles?
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
It is easy to apply multiple formatting components at once
What is the quickest way to apply a currency style to a set of numbers? You’d select the values and 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
Go to the Home tab and click the $ on the Numbers group
Right click the selection, choose Format Cells, select Numbers, select Currency and click OK
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), right click your Style, and choose Modify.
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.
Right click any cell that uses the style, and choose “Modify cell style”
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement