Mar 30 2022 07:42 AM
Hi,
Can someone please advise how to remove the highlighted 'info box' in the image below? I cannot seem to figure out how to remove it. It appears whenever I click on a number in the excel sheet!
Thank you,
zimzi86
Mar 30 2022 08:05 AM
This is a message from the data validation dialogue and has been placed by the author of the spreadsheet. You shouldn't remove it without consulting with him/her first.
Mar 30 2022 08:18 AM
Mar 30 2022 08:36 AM
If you are the author of the spreadsheet then you should know what is in it. Even when copy from another spreadsheet.
Mar 30 2022 09:14 AM
Mar 30 2022 09:28 AM
Mar 30 2022 12:44 PM
SolutionPlease be polite!
Select the cell or cells where this happens.
Click 'Data Validation' on the Data tab of the ribbon.
Click 'Clear All'.
Mar 30 2022 01:42 PM
Thanks for your response. Unfortunately, I cannot share the spreadsheet as it has got customer data and company sales financials on it. :(
Mar 30 2022 01:45 PM
Mar 30 2022 12:44 PM
SolutionPlease be polite!
Select the cell or cells where this happens.
Click 'Data Validation' on the Data tab of the ribbon.
Click 'Clear All'.