Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
The Consigliere
 
Posts: n/a
Default Displaying cell references next to embedded cells in Word 2000

Hello Group.

I've embedded some excel cells into my report written in Word 2000. Is
there a way I can display the cell references next to the embedded object
in the printout.

For example if cells B10:C15 are the embedded cells, I want those who read
the printed document to see exactly which rows and which columns the
numbers belong to. Something like this:

B C
10 Jan 10%
11 Feb 15%
12 Mar 34%
13 Apr 14%
14 May 10%
15 Jun 12%


So when I say somthing like "The formula used here is C10/SUM(C10:C15)" my
readers would be able to refer to the embedded object and do the
calculations themselves if they wished.

Is this at all possible?

I will appreciate any information on this problem.

TC
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

See if this will work;

Double-click the Excel object, go to Excel's Page Setup and click the tab
labeled Sheet. Click the option for Row & Column Headings.

HTH |:)


On 4/9/05 12:14 AM, in article ,
"The Consigliere" wrote:

Hello Group.

I've embedded some excel cells into my report written in Word 2000. Is
there a way I can display the cell references next to the embedded object
in the printout.

For example if cells B10:C15 are the embedded cells, I want those who read
the printed document to see exactly which rows and which columns the
numbers belong to. Something like this:

B C
10 Jan 10%
11 Feb 15%
12 Mar 34%
13 Apr 14%
14 May 10%
15 Jun 12%


So when I say somthing like "The formula used here is C10/SUM(C10:C15)" my
readers would be able to refer to the embedded object and do the
calculations themselves if they wished.

Is this at all possible?

I will appreciate any information on this problem.

TC


--


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ghost Blank Cell References David P Excel Worksheet Functions 1 February 4th 05 03:27 AM
Copying linked cell references. Shams Excel Worksheet Functions 0 February 3rd 05 01:53 PM
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL JOHN MORREY Excel Discussion (Misc queries) 2 December 2nd 04 02:50 AM
Transferring cell content between workbooks using cell references Kiwi Mike Excel Discussion (Misc queries) 2 November 27th 04 11:31 PM
How do you delete one cell from a range of protected cells Cgbilliar Excel Worksheet Functions 2 November 3rd 04 10:42 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"