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_vaWrOYXFUpC-eWbcvdnsXqpBu4FL-u9JlYr-LL6sd32M1L4KRxJsJLw0BZ_N5m3Qg5Nh_tW0iHbw-OwMwz_PmLXXRhDi6BZpUGHBRFIr7yAy_IUIAuEMHpTUMm8qt5SFIOBEU=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_shytiAteNAodkCrdeXAWFGpnpzwo52nEvyFfpV0rAZiYg0Q_tQOnVbBJ2xbRuUmGDFANv_1HBiJyP5S1R1Xnd97fPOx0DHPvG1rcTOZRMelR_7xV6n0k4pXj-meo94rV89NeZqECEEzA=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_uaDSI06mMEr2S2UPsDt-5ZPeCjPOw7Y8NFBcmI1F2Bs8PwAcw70gB8Dxq41qtD-lpnVTZd9UEbMcWrM9ewt7ECzoiBSJgWnATzEPoJipKMNBybS1WNZrTBPVy6MklQkirWJ5qkmzDFl9uhZj7Y=s0-d)
Here is an example of all comment-containing cells that are now selected.
![CommentsSelected](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tcVnXqA_eqSz3B39N9OyhEwbCWkw0BtLfPi_5Ni2I3gf2Jd5pVkcZapWa2utULm__3rTzV3PAhv5HeW8Ze6wn8ChzSPRAXYlNHhpIjpD_TbHKBV5yZFhyCRKeov-QkpnG4YmF8kjdnWVM=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_sTNU8u5MwY5St0zfJZP8UU1tpzzlQyuPB_dkahptHvejxloSdn2238_u3nDLa2h1mGHx-I1D5GsOmtlTtLw7Hus2Odv2sSQKKFo0H0t42nc7HTbkZyElMKOIIJMd5X92yTYcyjX3tAEAnAxVub9KNgkwVW=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_uJ1D3dlXF7Cxr-5DwJb-hz8RoYEG5qR24mlswPNlF_Glqfc91H0KpzbFbhz6nCrxK6UVKFnZIYFnD2htRdQRHD7aWoi5c8_Dz5HYCQm7xnsqusLVLlBJqcz7w6LjAQRuwIkjQEjjUA3mR4GB-bKQ=s0-d)
No comments:
Post a Comment