Template comes with "comments" that I can't remove

p45cal · #1 06-20-2018, 02:08 PM

Select a cell with the unwanted message.
Ribbon: Data tab, Data Tools section, Data Validation dropdown, choose Data Validation…
In the Input Message tab of the dialogue box, either untick the Show input message when cell is selected tickbox, or delete the text in the Input Message: field.
Click OK
That way, you won't delete other aspects of any data validation.

DBlomgren · #2 06-20-2018, 02:12 PM

Quote:

Originally Posted by p45cal

Select a cell with the unwanted message.
Ribbon: Data tab, Data Tools section, Data Validation dropdown, choose Data Validation…
In the Input Message tab of the dialogue box, either untick the Show input message when cell is selected tickbox, or delete the text in the Input Message: field.
Click OK
That way, you won't delete other aspects of any data validation.

Thanks, P45Cal!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
Why have all of my authors been replaced with the generic "author" in comments?	CanvasShoes	Word	1	02-01-2013 01:32 PM
How to remove "Table of Figures" as we do to remove the "Table of Contents"?	Jamal NUMAN	Word	1	07-08-2011 05:40 PM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Template "File In Use" when opening 2 documents based on the same template	wendt	Word	5	12-15-2009 12:37 AM