How to Turn off Survey123 Connect Excel Spreadsheet Comments

1055
3
Jump to solution
11-26-2016 11:39 AM
JoeFlannery
Regular Contributor II

Is there a way to hide or turn off the Survey123 Connect Excel spreadsheet Comments (see below)? Comment drop-downs interfere with me seeing the underlying cells and is frustrating.

Excel Comment

This process does not work:
Click the File tab, click Options, click Advanced in the left panel, go to the Display section, in the group "For cells with comments, show:", check the "No comments or indicators" option, click the OK button.

Thank you

0 Kudos
1 Solution

Accepted Solutions
IsmaelChivite
Esri Frequent Contributor

Hi. The yellow screentips are part of the cell's data validation. You can take them out of the way when they pop by hitting the Esc key. Alternatively, you can disable them in your Excel file by selecting the cell, and then going into the Data menu, then Data Validation/Data Validation and disabling the input message.  You could also disable data validation entirely in the worksheet, although that may be a bit too drastic.

View solution in original post

3 Replies
IsmaelChivite
Esri Frequent Contributor

Hi. The yellow screentips are part of the cell's data validation. You can take them out of the way when they pop by hitting the Esc key. Alternatively, you can disable them in your Excel file by selecting the cell, and then going into the Data menu, then Data Validation/Data Validation and disabling the input message.  You could also disable data validation entirely in the worksheet, although that may be a bit too drastic.

View solution in original post

YorladyVela2
New Contributor III

Muchas Gracias Ismael, me sirvió mucho.

0 Kudos
JoeFlannery
Regular Contributor II

Thank you, Ismael.

0 Kudos