![]() |
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 |
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