ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Show comments, but not the indicators (https://www.excelbanter.com/excel-discussion-misc-queries/177925-show-comments-but-not-indicators.html)

[email protected]

Show comments, but not the indicators
 
I have created an excel spreadsheet where all cells in a column of
data contain comments.
The comments provide additional information about a location. For
example, the cell value is 'Pizza Hut', and the cell comment contains
store #, address, city.

This creates a very busy looking spreadsheet, with cell comment
indicators everywhere. Is there a way to hide the indicators, but
the cell comments still popup on mouseover?

Thank you

John

RagDyeR

Show comments, but not the indicators
 
If you hide the indicators, you hide the comment also.

You might try <Data <Validation - <Input Message tab,
*BUT* it *doesn't* display with a "mouseover", just with a selection.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
I have created an excel spreadsheet where all cells in a column of
data contain comments.
The comments provide additional information about a location. For
example, the cell value is 'Pizza Hut', and the cell comment contains
store #, address, city.

This creates a very busy looking spreadsheet, with cell comment
indicators everywhere. Is there a way to hide the indicators, but
the cell comments still popup on mouseover?

Thank you

John




Bill Sharpe

Show comments, but not the indicators
 
wrote:
I have created an excel spreadsheet where all cells in a column of
data contain comments.
The comments provide additional information about a location. For
example, the cell value is 'Pizza Hut', and the cell comment contains
store #, address, city.

This creates a very busy looking spreadsheet, with cell comment
indicators everywhere. Is there a way to hide the indicators, but
the cell comments still popup on mouseover?

Thank you

John

Not really a solution, but at least in Excel 2007 if you zoom out your
cells and text get much larger yet the comment indicators don't change
size, so they are less noticeable. However, this affects how much
information you can display on one screen.

Another approach would be to use hyperlinks rather than comments for
your location information. That would require a mouse click rather than
a hover to display the result.

Bill


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com