Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format multiple Worksheets Simultaneously
How do I format multiple Excel worksheets simultaneously? I want to format
the first worksheet and have those format settings applied to all worksheets in the workbook. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format multiple Worksheets Simultaneously
Hold the CTRL key and select all the worksheet tabs to which you want to
apply the formatting. This groups the sheets. Apply your formatting. Then when you are done, right-click on one of the tabs and select ungroup sheets. -- Brevity is the soul of wit. "Bob" wrote: How do I format multiple Excel worksheets simultaneously? I want to format the first worksheet and have those format settings applied to all worksheets in the workbook. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format multiple Worksheets Simultaneously
Bob
Select first sheet then right-click on sheet tab and "Select all sheets" Do the formatting on active sheet and will be done to all. DO NOT FORGET to right-click and "ungroup sheets" when your formatting operation is done. Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 07:23:00 -0800, Bob wrote: How do I format multiple Excel worksheets simultaneously? I want to format the first worksheet and have those format settings applied to all worksheets in the workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a Row to Multiple Worksheets Simultaneously | Excel Worksheet Functions | |||
lookup function for multiple worksheets...and then 'some' | Excel Worksheet Functions | |||
Updating Multiple Worksheets Simultaneously | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions |