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’.
- 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