apply format to all pages in a workbook

  • Thread starter Thread starter tlatey
  • Start date Start date
T

tlatey

Clear DayI use a tracking sheet at work to track everything I do throughout
the day, so my workbooks are done monthly. When I get the initial page all
formatted, is there any way to apply this formatting to all 30 pages in the
workbook w/out going through each one and pasting from the original? I am
using excel 2000.
Thanks
 
If you select the whole of the first sheet & copy, you can then go to the
2nd sheet and use Edit|Paste Special|Format to replicate the first sheet's
formatting on the second sheet. Haven't tried it but you may find it works
just as well if you select all sheets before pasting. If not, you can then
select each of the other sheets in turn and simply press F4 to repeat the
action.

Cheers
 
With formatted sheet active, select the whole sheet by hitting CRTL + A then
Edit>Copy

Select next sheet in line then SHIFT and click on last sheet to group these
sheets together.

Select A1 and Edit>Paste Special>Formats>OK>Esc.

Re-select first sheet to ungroup all sheets.

Gord Dibben Excel MVP
 
Back
Top