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’.
- A dialog box appears. Click on Go-to special option.
- Go-to dialog box appears. The various options appear. Choose the appropriate once as per your requirement. Click on Ok