2 Questions
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
--
|