Below is an overview of how to use the Go To Special function in Excel to improve your speed.
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
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.
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.
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.