Want To Select Cells Quickly?

It is a time consuming process to select specific cells from a range of cells in order to modify or remove the conditional properties. Use ‘GO TO’ command in such situation and select the specific cells within a short time.

Click on 'Edit' menu and select 'Go To' option. (Shortcut key: Press Control ley and G key simaltenously). Now, you will need to click on ‘Special’ button to view the customized navigation selector box.

Tips: Press F5 function key to get GO TO dialogue box.

Now let us discuss how we can use this command effectively. It is a powerful navigating tool to find a particular data within worksheet. It works like an explorer to search and get specific data immediately.

Some of the options are explained below in detail. This will give you an idea about how to use this navigation tool.

TO SELECT ONLY CELLS THAT CONTAIN FORMULAS

If you have a huge data, it is difficult task to find cells that contains only formulas. In such situation first select the range of cells that contains any data. Press F5 to open ‘GO TO’ dialogue box. Now click on ‘special’ button to open 'Go To Special' dialog box.


Select ‘Formulas’ and press enter. Excel selects cells those only contain formulas in the entire selection.

TO SELECT ONLY BLANK CELLS

Use ‘Blanks’ option to select cells those are blanks in the entire selection.

TO SELECT ONLY COMMENTS

Use ‘Comments’ option to select cells those have comments in the entire selection.

TO SELECT VISIBLE CELLS

While working with AUTOFILTER Command, You may find some difficulties like changes that you make might affect data in hidden rows. Use ‘Visible cells only’ option to remove rows and columns that are hidden from the range of selection.

TO SELECT CONDITIONAL FORMAT CELLS

You need not waste your time in clicking each cell and checking any conditional format properties applied on it or not. Select the range of cells and use ‘Conditional Formats’ option to get the cells instantly.

TO SELECT DATA VALIDATION CELLS

Like conditional format, you need not waste your time in searching cells that have validation properties. Select the range of cells and use ‘Data Validation’ option to get the cells instantly.

Practice this navigation tool, which will sure save your time and make your work easier than how you do regularly.