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