Copy styles from another Excel workbook

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.

How can I copy Styles from an existing workbook?

Copy styles from another Excel workbook

If you have the styles you want to use in a different Excel workbook, then there is no need to create them again. Open both workbooks and select the one you want to copy the styles to from the Window menu. Choose Style from the Format menu and press merge. Select the workbook which you want to copy styles from and press OK. All styles from the source workbook will be copied into the destination workbook.

Please note: Please use carefully - any style which shares the same name as one from the source workbook will be overwritten.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Ray Lokar