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 certain criteria, such as cells containing:
- Formulas (numbers, text, logicals, errors)
- Constants (numbers, text, logicals, errors)
- Blank cells
- 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.
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 (hardcoded numbers) selected
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 – 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 set 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 all at once.
Free Excel Crash Course
Learn Go To Special (F5) with CFI’s Free Excel Crash Course. This course gives you the most important spreadsheet formulas, Excel keyboard shortcuts (Mac and PC), and functions, all in one concise tutorial.
Thank you for reading CFI’s guide to Go To Special. To keep learning and developing your Excel skills, check out these additional CFI resources: