software

Here is what I am trying to achieve:

I have a large table whose cells either include much information or nothing
at all. Naturally, I don't want to display all the information in the table
because it gets too large. I want to mark all the cells having information
in them with an quot;Rquot;. As I click on any cell with an quot;Rquot;, the full content of
the cell is displayed in a large area on the top right on my spreadsheet. I
want every active quot;Rquot; cell, to display its content in the same top right area.

How do I set this up?

Hi Louis,

Debra Dalgleish has a downloadable spreadsheet which demonstrates a method
of using a spreadsheet cell area to display comment text. See the 'Display
Comment Text' section at:

www.contextures.com/excelfiles.html#Comments---
Regards,
Norman
quot;Louis Charlandquot; lt;Louis gt; wrote in message
...
gt; Here is what I am trying to achieve:
gt;
gt; I have a large table whose cells either include much information or
gt; nothing
gt; at all. Naturally, I don't want to display all the information in the
gt; table
gt; because it gets too large. I want to mark all the cells having
gt; information
gt; in them with an quot;Rquot;. As I click on any cell with an quot;Rquot;, the full content
gt; of
gt; the cell is displayed in a large area on the top right on my spreadsheet.
gt; I
gt; want every active quot;Rquot; cell, to display its content in the same top right
gt; area.
gt;
gt; How do I set this up?
Hi Louis,

I should add that if you are not familiar with macros, you may wish to visit
David McRitchie's 'Getting Started With Macros And User Defined Functions'
at:

www.mvps.org/dmcritchie/excel/getstarted.htm---
Regards,
Norman
Thank you Norman,

What if I do not want to use codes. Instead, I want every quot;Rquot; cell to
display a different content, i.e. an independant comment for each. Is that
possible?

Thanks

quot;Norman Jonesquot; wrote:

gt; Hi Louis,
gt;
gt; I should add that if you are not familiar with macros, you may wish to visit
gt; David McRitchie's 'Getting Started With Macros And User Defined Functions'
gt; at:
gt;
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;

Hi Louis,

gt; What if I do not want to use codes. Instead, I want every quot;Rquot; cell to
gt; display a different content, i.e. an independant comment for each. Is that
gt; possible?

The codes are intended to provide a means to link a cell to its comment,
which is held on a separate worksheet. Without the code, how will the
appropriate comment be displayed. It would be feasible to use the cell's
address as the key, but, clearly, this would fail if rows or columns were
inserted in the main sheet.

Therefore, rather than using a simple 'R', try using R1, R2...Rn to
designate your comment cells. If you wish your users only to see the 'R',
why not set the font colour of the appended numeric to match the colour of
the cell background?---
Regards,
Norman