Back to lesson
1. 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.
2. 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, 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.
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’.
3. Which of the following statements is not true regarding Excel’s Cell Styles?
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.
You may only have a maximum of 255 Cell Styles in a workbook
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement