Copy header, footer and body for pasting into Word

[scotthannaford1973]

Hi all

I have a worksheet with a header and a footer and a body with some data; I'd like to be able to copy all of that and embed it into Word - but not as an icon, as a visible worksheet in Word.

Can someone please remind me how to copy the header, footer and body of an Excel worksheet!?

thanks in advance

 

[Micron]

Just select the range, ctrl+c to copy, paste into new Word document? Seems to work for me. Default was no table borders, but it's easy to modify that.

 

[scotthannaford1973]

Just select the range, ctrl+c to copy, paste into new Word document? Seems to work for me. Default was no table borders, but it's easy to modify that.

Hi... that doesn't copy the header and footer, though... just the range/body.

 

[Micron]

Then I don't know what you're copying. Top is a table, bottom is just a range - pasted into Word.
I didn't bother with creating footers but I don't see how that would matter. I'd say both have header row(s).

 

[scotthannaford1973]

Then I don't know what you're copying. Top is a table, bottom is just a range - pasted into Word.
I didn't bother with creating footers but I don't see how that would matter. I'd say both have header row(s).
View attachment 86067

Hi

It's a range on an Excel sheet but I also want to include the page header and page footer... I.e. which aren't within the main body.

 

[Micron]

OK, I think I get what you're saying. The h & f is what you set up in page design. In that case, the only thing I can think of is to set the h & f in Word and paste the sheet range in between.