ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format all worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/149488-format-all-worksheets.html)

Daniel

Format all worksheets
 
How can I format all worksheets in an excel file? I am tired of format every
worksheet and the format go to default when I refresh data!
Daniel


challa prabhu

Format all worksheets
 
Hi,

Do the following:

1. Open the Workbook.
2. Click the first Worksheet and then press the Ctrl and click on other
sheet.
This will help you group all the worksheet.

Now if you perform any editing on the sheet, then all worksheet will be
edited simultaneously.

If youwant to ungroup all the worksheet, then press the Ctrl key and then
click each worksheet individually.

Challa Prabhu

"Daniel" wrote:

How can I format all worksheets in an excel file? I am tired of format every
worksheet and the format go to default when I refresh data!
Daniel



All times are GMT +1. The time now is 06:38 PM.

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