An Overview of Go to Special Feature in Excel

Sometimes we feel the need to find and select all the cells with errors, cells with blank cells, cells with formulas, or even cells with constant values. This work can be easy with Microsoft Excel’s Go to Special command. Go to Special feature enables you to swiftly choose cells based on specific criteria. This article will give an overview of the Go to Special command in Excel that will help you to understand the Go to Special.

Why Use Go To Special Feature in Excel?

With Go To Special, you may instantly pick all cells that contain a particular type of data in Excel. Especially when you are working with a large worksheet, Go To Special can be quite handy for you.

Here are reasons that will convince you to use the Go To Special feature in Excel.

  • You can find the cells with certain formulas.
  • If you want to select the errors.
  • Selecting blank cells.
  • Detecting comments in the data table.
  • Selecting array etc.

Go to Special Usage Guide

There are three techniques to get access to Go To Special:

Method #1: From Ribbon

Step_1: Select the Home tab.

Step_2: Under the Editing group, click on the Find & Select drop-down list.

Step_3: From the drop-down menu, hit the Go To Special command.

find Go To Special feature in excel

This way the Go To Special dialog box will show up on the screen.

Go To Special dialog box in Excel

Method #2: Keyboard Shortcut

Press CTRL + G to open Go To Special.

Method #3: Alternative Keyboard Shortcut

Press F5 or Fn + F5 to open Go To Special.

🔗 65 Shortcut Keys in Excel [Free PDF Download]

Features of Go To Special Command in Excel

1. Go To Special: Comments

This command will select all the cells from the datasheet that have comments inside them. After that, you can remove the comments or do something else if needed.

Go To Special: Comments selection in Excel

2. Go To Special: Constants

The Go To Special‘s Constants selection gives the opportunity to choose all cells in the range that has a constant value. This covers text, numbers, and mistakes but just not formulas.

Go To Special: Constants in Excel

3. Go To Special: Formulas

This feature is just the opposite of the Constants selection. The Formulas selection allows you to find all the cells that have formulas in them.

Go To Special: Formulas in Excel

4. Go To Special: Blanks

The blank cells in a worksheet with a lot of data may need to be located so that the blank cells can be deleted or filled with data. And for that, use the Blanks selection option from Go To Special feature.

Go To Special: Blanks selection

5. Go To Special: Current Region

The Current region chooses all cells with the same format connected to one another.

Go To Special: Current Region selection

Note: Another way to select the region is to click on any random cell in the data table and press CTRL + A.

6. Go To Special: Current Array in Excel

The function of the Current array is to select all cells in the current array.

7. Go To Special: Objects

The Objects selection selects all objects on the worksheet, for instance, charts, figures, and shapes, graphs, etc.

8. Go To Special: Row Differences in Excel

The Row Deferences find the row with exceptional values in the data table. For instance, in this table, all the cells contain the value 200, despite one cell (A2) containing the value 180. The Row Deferences will select the row with the exceptional value.

Go To Special: Row Differences in Excel

9. Go To Special: Column Differences in Excel

With Column Deferences, you can find the columns with different values from the selected cells.

Go To Special: Column Differences in Excel

10. Go To Special: Precedents and Dependents in Excel

Suppose, you have a range of cells with formulas. Now if you apply the Precedents in the data table, it will select those cells which you have used to create the formulas.

The Dependents is the reverse of Precedents. It will select the cells that are dependent upon other cells of the table.

Conclusion

There are many other features of the Go To Special feature. You should explore the features and apply them to your worksheet next time. And, please visit our Blog page for more helpful articles related to Excel. Thank you.

(Visited 64 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *