Select Special tool lets you select multiple cells with certain contents with just one click.
Are you getting frustrated by finding all the cells with formulas for formatting? Or may be you are tired of hiding all the comments one by one. Here is a tool for you to end your troubles: Select Special.
You can access this tool by Find & Select button from home ribbon. When you click this button, a drop down menu will appear. From this menu, select “Go to Special” option and there you are.
You’ll see a list of options about possible selections. From here you may select cells containing comments, constants, formulas of different kinds, etc.
With this tool you are going to save a lot of time and energy while working on your files. You will never search for cells one by one.