Copying Excel Table into Word with Column & Row Headings
Ed
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
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
On 3/18/09 7:45 PM, in article
96d6b776-9265-440c...@e38g2000yqa.googlegroups.com, "Ed"
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
>
> On 3/18/09 7:45 PM, in article
>
> <edvolc...@nyc.rr.com> wrote:
> > 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
Thanks. Ed
macropod
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.
--
Cheers
macropod
[MVP - Microsoft Word]
"Ed" <edvo...@nyc.rr.com> wrote in message news:96d6b776-9265-440c...@e38g2000yqa.googlegroups.com...
Carl Witthoft
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.
In article <uJH3AUKq...@TK2MSFTNGP05.phx.gbl>,
"macropod" <macr...@invalid.invalid> wrote:
> 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.
--
Team EM to the rescue! http://www.team-em.com
CyberTaz
Thanks for recharging the memory bank!
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 3/19/09 5:03 PM, in article
carl-A6F010.1...@reader.motzarella.org, "Carl Witthoft"
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.
>
>
>
>
> "macropod" <macro...@invalid.invalid> wrote:
> > 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.
>
> --
> Team EM to the rescue! http://www.team-em.com
Carl,
The approach you suggest no longer works in Office 2008.
Ed