Back to lesson
1. How do you modify a built-in Excel Cell Style?
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.
Right-click on the Cell Style and click ‘Modify…’
2. How do you import Cell Styles from another 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.
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.
3. 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
Cell Styles may be copied using the Format Painter.
When a new Cell Style is first created, the cell(s) selected at the time will not change accordingly.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement