Excel - Copy and Paste Footer Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to copy and paste data in a Word document and also from cells
within an Excel spreadsheet. However, the ability to copy and paste header
and footer data requires a different command, which does not readily come to
mind and doesn't seem to be available in the Help section for Excel. It is
not your standard "C" and "P".
 
I'm guessing here so forgive me if I go astray. Normally when I copy and
paste I use Ctrl-C and Ctrl-V respectively. I just tried this by copying
something in an Excel spreadsheet and then going to Header (in page setup and
then custom header) and saw that it did not work. I then went through an
extra step of first copying to a different Office Application (Word in this
instance.) And then, I copied it from Word (again using Ctrl-C) and went
into the Excel header, custom header, and this time, my Ctrl-V worked. A
pain I know, but for some reason, this seems to be Excel's behaviour in
certain situations (like trying to copy something from an Excel cell into a
Find/Replace box; at least in the Excel version I am using, 2000.)

HTH.
 
I'm guessing here so forgive me if I go astray. Normally when I copy and
paste I use Ctrl-C and Ctrl-V respectively. I just tried this by copying
something in an Excel spreadsheet and then going to Header (in page setup and
then custom header) and saw that it did not work. I then went through an
extra step of first copying to a different Office Application (Word in this
instance.) And then, I copied it from Word (again using Ctrl-C) and went
into the Excel header, custom header, and this time, my Ctrl-V worked. A
pain I know, but for some reason, this seems to be Excel's behaviour in
certain situations (like trying to copy something from an Excel cell into a
Find/Replace box; at least in the Excel version I am using, 2000.)

HTH.
 
Don't copy the cell.

Copy the text from the formula bar and you can paste it into a header or footer
using CTRL C and V

Note also.

If you want all worksheets to have same header or footer, right-click on one
sheet tab and "select all sheets"

Do your setup on the one sheet and will be done to all sheets.

DO NOT FORGET to ungroup the sheets when done.

Select any sheet but the active sheet to ungroup.


Gord Dibben MS Excel MVP
 
Don't copy the cell.

Copy the text from the formula bar and you can paste it into a header or footer
using CTRL C and V

Note also.

If you want all worksheets to have same header or footer, right-click on one
sheet tab and "select all sheets"

Do your setup on the one sheet and will be done to all sheets.

DO NOT FORGET to ungroup the sheets when done.

Select any sheet but the active sheet to ungroup.


Gord Dibben MS Excel MVP
 
That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
 
That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
 
Happy to assist.

Thanks for the feedback.


Gord

That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
Click to expand...

Gord Dibben MS Excel MVP
 
Happy to assist.

Thanks for the feedback.


Gord

That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
Click to expand...

Gord Dibben MS Excel MVP
 
Yes, I found my notes at home and the CTRL C and then the CTRL V worked.
will have to commit this to memory.

Thanks.
 
Yes, I found my notes at home and the CTRL C and then the CTRL V worked.
will have to commit this to memory.

Thanks.
 
Thanks a lot. I found my notes at home and they were the same and worked
well. Also thanks for the additional tip.
 
Thanks a lot. I found my notes at home and they were the same and worked
well. Also thanks for the additional tip.
 
Back
Top