ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Copying Format Across... (https://www.excelbanter.com/setting-up-configuration-excel/41436-copying-format-across.html)

Excel Dummy

Copying Format Across...
 
Is there a way to copy changes made to one worksheet to all the others
without having to do each page? My workbook has 31 pages and they are
identical.

Anne Troy

You can group the worksheets first, or you can use the format painter
(http://www.officearticles.com/misc/f...oft_office.htm)
************
Anne Troy
www.OfficeArticles.com


"Excel Dummy" wrote in message
...
Is there a way to copy changes made to one worksheet to all the others
without having to do each page? My workbook has 31 pages and they are
identical.





All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com