PC Review


Reply
Thread Tools Rate Thread

How to display row numbers when pasting Excel data in Word?

 
 
=?Utf-8?B?SmF0aW4=?=
Guest
Posts: n/a
 
      27th Feb 2006
I am tryign to paste a table of formulas from Excel to Word. For the formulas
to make sense in Word, I would like the table pasted in Word to contain row
and column number headers. How to do this?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Q3liZXJUYXo=?=
Guest
Posts: n/a
 
      27th Feb 2006
You can't... the row numbers are a part of the progam window, not cell content.

AFAIK, you have to take a screen shot of the Excel window (SnagIt is great
for the purpose) and paste the image into your Word doc.

Regards |:>)

"Jatin" wrote:

> I am tryign to paste a table of formulas from Excel to Word. For the formulas
> to make sense in Word, I would like the table pasted in Word to contain row
> and column number headers. How to do this?

 
Reply With Quote
 
=?Utf-8?B?SmF0aW4=?=
Guest
Posts: n/a
 
      27th Feb 2006
ok, I found out how to do it.

File-->Page Setup-->go to Sheet tab --> check the "Row and Column Headings"
box in the Print area. Click OK

Now highlight the cells that need to be copied.

Then press Shift and (while pressing Shift), click on Edit --> Copy Picture.

A new box opens. Choose "As shown when printed". Click OK

Go to Word and press Ctrl-V.

Thanks to my friend KL who told me the trick.

Regards,
Jatin Bindal
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting Excel data into Word doc. mjdntn Microsoft Excel Worksheet Functions 0 26th Sep 2006 04:38 PM
Data missing from cell after pasting from Word 97 to Excel 97 Curtis Microsoft Excel Misc 2 11th Mar 2004 07:10 PM
pasting numbers into excel soma Microsoft Excel Discussion 1 12th Nov 2003 02:59 AM
Pasting Excel Data in Word chris Microsoft Word Document Management 1 12th Sep 2003 09:55 PM
Re: pasting data from excel to word Frank Isaacs Microsoft Excel Misc 0 12th Sep 2003 04:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:14 PM.