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.