Page Numbers

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I'm totally new to Excel but having to use it for some coursework, I have
all the info in the one file, 6 sheets numbered 1-6 but when I print them
thay all say Page1, how can i merge them into one document so that when I
print them they are numbered 1 to 6...

Cheers
Steve.
 
Hi Steve,
Group the worksheets, then print. Be sure to ungroup the
worksheets afterwards as any change made to the visible
worksheet will be made to the others (severe damage may occur).

To Group the worksheets, select worksheet, hold ctrl and select
another. You can use the shift key for range. To group all sheets
right click on worksheet tab and choose group all sheets.

To Ungroup sheets so you don't destroy your file, select a
single sheet, or more reliable for those not familiar with this
by right click on worksheet tab and choose ungroup sheets.
 
Back
Top