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 certain criteria, such as cells 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.

 

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

Go To Special in Excel

 

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

Go To Special selection of data

 

Free Excel Tutorial

To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis. 

Browse all of CFI’s Excel courses to take your career to the next level!

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.

 

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.

 

Excel Tutorial

 

More Excel tutorials

Thank you for reading this guide to Go To Speical (F5) in Excel!  To keep learning and developing your Excel skills, check out these additional resources: