Copying Excel Table into Word with Column & Row Headings

[Ed]

I've set up an Excel 2008 spreadsheet to print Column & Row Headings.
I now want to paste this spreadsheet into a Word 2008 file with the
Column & Row Headings visible. I've tried various copying and pasting
routines, but none work.

How can accomplish this seemingly simple task?

Thanks for your help.

Ed

 

[CyberTaz]

Sorry, Ed, but I don't think you'll get that to happen. The Headings bars,
scroll bars, etc. are a part of the window structure not the data area. Thus
they din't get copied. Your only options are to use a screen capture or take
the tome & trouble to set it up for PDF output.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Ed]

Sorry, Ed, but I don't think you'll get that to happen. The Headings bars,
scroll bars, etc. are a part of the window structure not the data area. Thus
they din't get copied. Your only options are to use a screen capture or take
the tome & trouble to set it up for PDF output.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Thanks. Ed

 

[macropod]

Hi Ed,

As Bob says, you can't do that. However, if you're prepared to paste the Excel data into Word as a Word table, there is a way to
simulate what you're after:
1. Insert the table
2. Add a new 1st row to the table
3. Insert A, B, C for the column headins
4. Add a new left column to the table
5. number from the 2nd row down.

You can then shade the left column & top row to simulate the Excel row/column headings.

If you prefer, you can use SEQ fields to generate the row/column headings:
For the 1st column, code the field as: {SEQ Col \* alphabetic \* Upper}
For the 2nd row, colde the field as: {SEQ Row}
Then simply copy across/down, respectively. When you've finished, select the table and press F9.

Note: The field brace pairs (ie '{ }') for the above example are created via Cmd-F9 - you can't simply type them or copy & paste
them from this message.

 

[Carl Witthoft]

There is a different way, but it requires you to paste a Picture rather
than an editable table. I happen to be of the opinion that this is a
far better way, because it avoids getting the Excel workbook embedded
into the Word doc, but that's more or less a matter of preference (and
lack of security).

So, in Excel, use PageSetup to "print row/column headers" , then (at
least prior to 2008), hold the shift key and select Edit/CopyPicture,
click "as printed" and you're all set.

 

[CyberTaz]

Yep - the feature is still there in 2008, I just didn't think of it :-}
Thanks for recharging the memory bank!

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Ed]

There is a different way, but it requires you to paste a Picture rather
than an editable table.  I happen to be of the opinion that this is a
far better way, because it avoids getting the Excel workbook embedded
into the Word doc, but that's more or less a matter of preference (and
lack of security).

So, in Excel,  use PageSetup to "print row/column headers"  , then (at
least prior to 2008), hold  the shift key and select Edit/CopyPicture,  
click "as printed" and you're all set.

Carl,
The approach you suggest no longer works in Office 2008.
Ed