ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How Do I turn off indicators and comments? (https://www.excelbanter.com/excel-discussion-misc-queries/122784-how-do-i-turn-off-indicators-comments.html)

Kevin

How Do I turn off indicators and comments?
 
Hi,

I am using an excel spreadsheet someone else created. Almost all of the
cells have their own comments/indicators that pop up every time I click on a
new cell. This is very distracting - how do I turn them all off??

I tried
Tools Options View Comments None


however, this did not solve the problem.

Please advise,

Thanks,

Kevin

Debra Dalgleish

How Do I turn off indicators and comments?
 
They're probably data validation messages. To turn them off:

Select a cell
Choose DataValidation
On the Input Message tab, remove the check mark from 'Show input message
when cell is selected'
Click OK

Kevin wrote:
Hi,

I am using an excel spreadsheet someone else created. Almost all of the
cells have their own comments/indicators that pop up every time I click on a
new cell. This is very distracting - how do I turn them all off??

I tried

Tools Options View Comments None



however, this did not solve the problem.

Please advise,

Thanks,

Kevin



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 01:38 AM.

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