2 Questions

[Richard]

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

 

[Liliana]

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)

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

--

 

[Liliana]

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/excel/HA102690601033.aspx?pid=CH100798581033#2

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

--

 

[Shane Devenshire]

Hi,

The technique is version dependent, but for all versions this works:

If you select the entire column when you copy then the column width will be
retained when you paste.

Also, you add page numbering in the Header or Footer area by clicking the
Page # and Number of Pages buttons and then on the Sheet tab choosing down
then over or over then down to indicate the order of printing and hense
numbering. In 2003 you can reach the Page Setup box by choosing File, Page
Setup. In 2007 you reach it by choosing Page Layout, and then clicking the
quick launch button in the bottom right corner of the Page Setup group.