See all How-To Articles

How to Use Go To Special in Excel

This tutorial demonstrates how to use the Go To Special feature in Excel.

 

go to special excel

 

Go To Special

In Excel, you can simultaneously select all cells with certain conditions using Go To Special.

Say you have the following data set including Product Name in Column B, Price in Column C, Items Sold in Column D, and Total in Column E. Column E’s values are calculated with a formula (multiplication of Columns C and D).

 

go to special initial data

 

Go To Formulas

You can use the Go To Special option to select all cells containing formulas.

  1. In the Ribbon, go to Home > Find & Select > Go To Special… (or use the CTRL + G shortcut).

 

go to special 1

 

  1. In the Go To Special window, select Formulas, and click OK.

 

go to special 2

 

As a result, the range E2:E8 is selected, as these cells contain formulas.

 

go to special final data

 

Other Criteria

As you can see in the Go To Special window, there are different conditions to select by, including: