Selecting All Cells With Comments or Data Validation
I previously posted this example of selecting only constants or formulas.
You can do the same with cells that contain comments or data validation.
Select the range of interest.
![SelectRange](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vl49IrMmF2v8WBAi6DIRDK05PzcNzSgNaawj5bDiqQlm87VVFrr_tnsKn8kDd12s_i4foPCTA8nznzFt7VHU0RfYg9BHIqEl9xHG05k31arqN3Ttdv1xXxR6urVKELW_TcYhI=s0-d)
From your keyboard, press
F5
to show the GoTo dialog box. Then click the Special button.
![F5_GoTo_Special](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tEuRj7fzfbJwaS_ELfWTSyCDQEgqt3nhlfXs40pSJ4T0tZIvKtoRjtEFNRpF6bpteeI56S5pUp0c4FBUIL2bzBf54dUS60fjfJ2aXF38iwxpWYmS2Nrc_i0Q94MQGc_rrzRibr7B_HeA=s0-d)
To select only cells with comments, select the Comments option in the GoTo Special dialog box, and click OK.
![GoToSpecial_Comments](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sVK0G6JAdL2OaZ5J7XgkubLFDM9pweJ_mDxXt892WJ4sxa49Y_UjHZYJcc5_Oupe77G0tvkjAAKECzq-0lROXMebCXSV4UG_0ZAQRWYzXRMjXIzXzukqXb5ri5Kc8ZxmE8c_mFfUBU4qWmO4tt=s0-d)
Here is an example of all comment-containing cells that are now selected.
![CommentsSelected](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_v-ulyJQuH0R3p2dXn4a4ZHA95vvaFnJVAN8l6GUcABBJAXSFMYj4mMmpdngM8VnWrXcTw5Y3ffNCdslkrxna658lvf_xChdZ-DB0FWnompzabu5GMXajDYAaaxtK3HBFHqPSx--TyuhV8=s0-d)
To select all cells with data validation, in the GoTo Special dialog box, select the option for Data Validation, also select the option for All, and click OK.
![GoToSpecial_DataValidation](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uNeU2SX1wbkkapTbHLjhUvKLyBXPOtFTuPR74cGwPaX7mJvRqwxO5S3AKh2AtZT6Cq8yjZjsLZCCHhUYoPuUchThiOcvYRDviJG4_IbDsLv3ft1mWW8D17w5qcMBWXTD82RvAX81NfREIAUvBcnLCyD_sJ=s0-d)
Here is an example of all cells that are now selected which contain data validation. In column C, I validated the cells for only Male or Female to be entered. In column E, I validated the cells to be a date between January 1, 1930 and December 31, 1997.
![DataValidationSelected](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sUPWmm7HGSH_X-hHLwy8Hy981q5vb6fHwu9KmMJGecgdlR0AeOhK9OT-o0hUtCWNQXbxKtpjy5wixuw9x2MBcY_9ayNvEQSzvEqX9wWNoqEEY0x9d2nmzxc_Q1Aa3XFY4k9NCw3z9RIdcv59tz1w=s0-d)
Leave a Comment