ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   format 10 sheets on same file to look like first one (https://www.excelbanter.com/new-users-excel/89668-format-10-sheets-same-file-look-like-first-one.html)

Michael Abraham

format 10 sheets on same file to look like first one
 
Is it possible to group worksheets where the format is all exactly the same.
Then ungroup to make a change on worksheet without affecting the other
worksheets.

Ardus Petus

format 10 sheets on same file to look like first one
 
To group worksheets: keep Ctrl pressed while you click on the sheet tabs
If you have many:
Click on first tab, keep Shift pressed, click on last tab

HTH
--
AP

"Michael Abraham" a écrit dans le
message de news: ...
Is it possible to group worksheets where the format is all exactly the
same.
Then ungroup to make a change on worksheet without affecting the other
worksheets.





All times are GMT +1. The time now is 11:21 PM.

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