Printing Page Numbers

[Russell Hampton]

Hi all,

Is there an easier way to assign page numbers to a large
workbook other than to do it page by page? I was hoping
for some global method.

Thanks

 

[Dave Peterson]

How about grouping your worksheets (right click on a worksheet and click on
"select all sheets") (Or click on the first tab and ctrl-click on subsequent--if
you don't want all the sheets.)

then File|Page setup|Header/footer
and set them all at once.

when you're done, make sure you right click on one of the grouped worksheets and
select "ungroup sheets". Everything you do to one of the group, you do to all
of the group. That's nice for headers/footers, but might be dangerous when
you're deleting a row or just changing data.)