How to Use Go To Special in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 29, 2022

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:

For more on how to use the Go To feature, see Jump to Cell and Go To Cell, Row, or Column.

AI Formula Generator

Try for Free

See all How-To Articles