Subscriber only lesson.
Sign up to this course to view this lesson.
Formats vs. Styles Part 2
Formats vs. styles explained using the CRaFT methodology.
When to use
Formats vs. styles can assist in building a financial model in Excel which is easy to understand and navigate through.
- When you create a new workbook, you do not need to re-create all of the styles that you created in the previous workbook. To import styles from another workbook, follow the instructions below:
- Select Cell Styles
- Select Merge Styles
- Select the workbook you use wish to import the styles from
- Watch out when copying cells from one workbook into another as you may be bringing the styles over into the new workbook unintentionally. This may create issues if both workbooks have the same styles created. It will create duplicate styles. It can take time to delete the duplicate styles as you can only delete one style at a time. To avoid this issue, it is best to paste the formulas only, not the styles. This can be done by using the shortcut ALT + E + S and selecting Formulas, after the cells have been copied from the original workbook
Lesson notes are only available for subscribers.