Formatting Workbook

[exdter]

I have a workbook containing 80 worksheets. All of the data i
consistent in all the worksheets. For example column D in all 8
worksheets is a monetary value. I want to format all the column D's i
all the worksheets as currency with 0 decimal places. Is there a wa
to do this without having to go through all the worksheets one at
time?
Thanks

 

[Frank Kabel]

Hi
select the cells in one sheet. After this hold down the SHIFT key and
select all other sheets (group them). Now apply your format

 

[DDM]

Exdter, in Excel 2000 (and I suspect other versions as well), right-click
any worksheet tab and select Select All Sheets. (Look for the word [Group]
on the Title Bar at the top of the screen.) Then format Column D on the
current worksheet. Whatever you do on this sheet will affect all the others
as well. When you're done, right-click the worksheet tab and select Ungroup
Sheets.

 

[Mike Q.]

Click on the first worksheet then while holding down the
shift key click on worksheet 80. This will select all your
worksheets. Now select column D and format as desired.
When done click on any worksheet between 1 & 80 to unselect
all sheets.

 

[exdter]

Thanks to all who replied!!! You guys saved me hours of work!!!
Thanks again