| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format multiple Worksheets Simultaneously | Excel Discussion (Misc queries) | |||
| Format Worksheets in a Workbook | Setting up and Configuration of Excel | |||
| Keeping the same format in linked worksheets | Excel Worksheet Functions | |||
| Format different worksheets automatically | Excel Worksheet Functions | |||
| How do I format all worksheets in a workbook at one time ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
