Formatting Workbook

  • Thread starter Thread starter exdter
  • Start date Start date
E

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
 
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
 
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.
 
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.
 
Back
Top