Oops, forgot part 2


Xl2003

View
Header and Footer
Click Custom footer
Choose your section

past this

&[Page] & " of " &[Pages]

XL2007
See Insert page numbers by using the Page Setup dialog box:

http://office.microsoft.com/en-us/ex...100798581033#2




?B?UmljaGFyZA==?= wrote in
:

First, when copying and pasting from one sheet to another it will
bring the formatting but not the size of the columns and rows. Is
there a way to copy that as will without having to resize them every
time?

And, is there a way to put a page number footer on each page so that
it will number each page in sequence?

Richard




--