Training Index l How errors happen l Vital Tips

Auditing Toolbar Links Find/Replace GO TO Special Functions and Features

Go To Special:
An underutilised tool in Excel is the GO TO feature and particularly the button marked SPECIAL. By clicking EDIT, then GO TO, then SPECIAL, the following will appear.

By clicking on the desired option and clicking OK, Excel will highlight all the cells on the sheet (or the selection) that meet the specified criteria. Below is a description of each function: Comments- will highlight all cells containing comments (useful to delete unwanted comments) Constants- will highlight all cells containing constants of the kind required (number, text, logical, error) Formulas- will highlight all cells containing formulae of the kind required (number, text, logical, error). Blanks- will highlight all blank cells Current region- will highlight all cells in the current region Current Array- will highlight all cells in the current array. Objects- highlights all objects on the sheet (e.g. buttons, pictures etc) Row/ Column Differences- will highlight which cells in a selection contain different formulae. Precedents/ Dependants- will highlight the precedence or dependents of a cell, either to one level or all levels. Last cell- will identify the last cell in a sheet (useful to find stray cells). Visible cells only- highlight only cells that are not hidden (useful to make changes to what you can see without affecting hidden cells) Conditional formats- highlights cells that have conditional formatting on them (either any conditional format or the same format of the current cell). Data Validation- highlights cells that have data validation on them (either any validation or the same validation as the current cell).