Go-To Special function in Excel

Go-to Special

The Go-To Special function in Excel allows you to select all cells that meet certain criteria quickly. This command is used to identify specific cells – the ones which are used more have been listed below –

Comments – select only the cells that contain a cell comment

Constants – selects all nonempty cells that don’t contain formulas

Formulas – selects cells that contain formulas

Declaring Go-to special option

  • Under the Home tab ->Click on ‘Find & Replace’.
Go-To Special function in Excel
  • A dialog box appears. Click on Go-to special option.
Go-To Special function in Excel
  • Go-to dialog box appears. The various options appear. Choose the appropriate once as per your requirement. Click on Ok
Go-To Special function in Excel