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.
--
Kevin Vaughn


"GMc" wrote:

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".

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

On Mon, 11 Sep 2006 12:39:01 -0700, GMc wrote:

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".

That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
--
Kevin Vaughn


"Gord Dibben" wrote:

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

On Mon, 11 Sep 2006 12:39:01 -0700, GMc wrote:

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".

Happy to assist.

Thanks for the feedback.


Gord

On Mon, 11 Sep 2006 14:50:02 -0700, Kevin Vaughn
wrote:

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

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.

"Kevin Vaughn" wrote:

That helps with the problem I was also having (where I could not paste into
the Find/replace boxes. Thanks.
--
Kevin Vaughn


"Gord Dibben" wrote:

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

On Mon, 11 Sep 2006 12:39:01 -0700, GMc wrote:

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".

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

"Gord Dibben" wrote:

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

On Mon, 11 Sep 2006 12:39:01 -0700, GMc wrote:

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".