Go To Special

Below is an overview of how to use the Go To Special function in Excel to improve your speed.

What is the Go To Special function in Excel?

The Go To Special function in Excel allows you to quickly select all cells that meet a certain criteria, such as containing:

  • Formulas (numbers, text, logicals, errors)
  • Constants (numbers, text, logicals, errors)
  • Blank cells
  • Objects
  • Precedents and dependents.

There are three ways to access Go To:

  • Press the F5 key
  • Press Ctrl + G
  • On the Home ribbon under “Find and Select” choose “Go To”

To see a video tutorial of Go To Special check out our free Excel Crash Course.

Why use Go To Special?

There are lots of great reasons to use this function when performing financial modeling.  Not only does it allow you to speed up your navigation but it also allows you to thoroughly audit a spreadsheet or workbook.

Here is a list of all Excel shortcuts to speed up your modeling.

One great example of the function is to select all hardcoded numbers in a spreadsheet. This allows for easy formatting of all selected cells with one click.  It also implies that all unselected cells are formulas, and therefore you can quickly make sure the model is setup up properly in terms of assumptions, calculations and outputs.

Another great reason to use the function is for organizing large amounts of data.  It can be helpful to select all blank cells and delete them at once.

Example of Go To Special in Excel

Below is an example of how to select all hardcoded (constant) numbers in a financial model.

Step 1: Press F5, click Special, then select constants and check only the numbers box

Step 2: Click OK and you will see all constants (hard coded numbers) selected

More Excel tutorials

Excel shortcuts

Excel formulas list

Index Match Match

Find and replace

IF AND functions in Excel