Copying with Row & Column Headings

S

Susan

I need to be able to copy or insert (excel 97)
spreadsheets into Powerpoint and Word documents and have
the row and column headings visible.

I have checkmarked Row & Column Headings in Page Setup but
this only works for printing, not for inserting/copying.

I'd appreciate some help.

Thanks,
Susan
 
J

Jim Cone

Susan,

As long as the data fits within the Excel window...
Do an Alt | Print screen in Excel.
Paste into a blank Excel worksheet in cell "B2".
Use the "Picture" toolbar to crop the picture (the button is the double XX's).
Copy the cropped picture and paste into Word or PPT.

You may find different / better results by pasting directly into Word and doing
the picture cropping there.
Also, after pasting into word, right-click the picture, select "Format Picture"
and on the "Wrapping" tab choose "None".

Regards,
Jim Cone
San Francisco, CA
 
S

Susan

Jim,

Thanks for answering. This is exactly what I have been
doing up to this point but what I'm really looking for is
a way to keep the spreadsheet active. I know that it can
be done because I saw it in a word document that was given
to me. When I questioned the person who did it, however,
she couldn't remember how she did it, only that she
figured it must have been a setting that she changed.

Thanks again,
Susan
-----Original Message-----
Susan,

As long as the data fits within the Excel window...
Do an Alt | Print screen in Excel.
Paste into a blank Excel worksheet in cell "B2".
Use the "Picture" toolbar to crop the picture (the button is the double XX's).
Copy the cropped picture and paste into Word or PPT.

You may find different / better results by pasting directly into Word and doing
the picture cropping there.
Also, after pasting into word, right-click the picture, select "Format Picture"
and on the "Wrapping" tab choose "None".

Regards,
Jim Cone
San Francisco, CA

"Susan" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
D

Debra Dalgleish

To include the row and column headings,

choose File>Page Setup
On the Sheet tab, add a check mark to Row and Column headings
Click OK

Select the cells that you want to insert in the Word document
Choose Edit>Copy
Hold the Shift key, and choose Edit>Paste Picture
Choose Edit>Cut
Switch to Word, and choose Edit>Paste
 
Top