Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I format all worksheets in a workbook at one time ?
I want to create a workbook that has all worksheets formatted in the same
manner. Is there anyway to do so without formatting each worksheet separately ? |
#2
|
|||
|
|||
yes,
Right click on any sheet tab, Select "Select All Sheets" from the pop-up menu. Have fun formatting the active sheet. When done take a look at any sheet and the formatting is done on ALL the selected sheets. Dan Knight "EBrock" wrote: I want to create a workbook that has all worksheets formatted in the same manner. Is there anyway to do so without formatting each worksheet separately ? |
#3
|
|||
|
|||
Dan, left out the most important part. (i.e. WARNING: sever tire damage)
When you have formatted all of the sheet, you must *ungroup* the sheets as any change you make to one you see, you make to all in the group. Right-click any worksheet tab and "Ungroup sheets". With practice you will learn to can also ungroup by clicking outside a smaller grouping of sheets. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dan Knight" wrote in message ... yes, Right click on any sheet tab, Select "Select All Sheets" from the pop-up menu. Have fun formatting the active sheet. When done take a look at any sheet and the formatting is done on ALL the selected sheets. Dan Knight "EBrock" wrote: I want to create a workbook that has all worksheets formatted in the same manner. Is there anyway to do so without formatting each worksheet separately ? |
#4
|
|||
|
|||
Another option too is format one sheet just the way you like it without any
data in it. Then once you know for sure, or have been given approval by whomever you're working with, just right click the tab and say Copy. Then you'll have Sheet1(2), Sheet1(3), etc. Of course, if you're working on formatting after the fact of data entry, the other suggestion is good too. "EBrock" wrote: I want to create a workbook that has all worksheets formatted in the same manner. Is there anyway to do so without formatting each worksheet separately ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time format help needed | Excel Worksheet Functions | |||
I cannot get time format to display in a drop-down list | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Time Format Auto Entry AM and PM | Excel Discussion (Misc queries) | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) |