Does anyone know of a way of showing which cells in a worksheet have Data Validation rules applied? Thanks.
Does anyone know of a way of showing which cells in a worksheet have Data Validation rules applied? Thanks.
Last edited by marketshare; 03-27-2011 at 07:53 PM.
Select entire range
Edit>Goto Special Button
then Data Validation option button > OK
this will select data validation cells only
Thanks Sadath31. I cannot find the function to which you refer. I have hunted around but cannot find anything that looks like an 'Edit-Goto Special button'. I am using Excel 2010.
I would appreciate further clarification.
Try the short cut to get 'GO TO' dialogbox
Ctl + G
Got it. Thanks![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks