See paste special options

XL2003

Copy cell/s
Select target
Edit, Paste Special

XL 2007

Copy cell/s.
On the Home tab, in the Clipboard group, click Copy
Select target.
On the Home tab, in the Clipboard group, click the arrow below Paste,
and then click Paste Special.
Under Paste, select you paste special option.


(Hint: you can paste special one option then paste special another)



?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




--