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 modelingWhat is Financial ModelingFinancial modeling is performed in Excel to forecast a company's financial performance. Overview of what is financial modeling, how & why to build a model.. 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 shortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts 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)Excel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts, and functions, all in one concise tutorial.
More Excel tutorials
Thank you for reading this CFI guide to Go To Speical (F5) in Excel! To keep learning and developing your Excel skills, check out these additional CFI resources:
Excel shortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts
Excel formulas listExcel Formulas Cheat SheetCFI's Excel formulas cheat sheet will give you all the most important formulas to perform financial analysis and modeling in Excel spreadsheets. If you want to become a master of Excel financial analysis and an expert on building financial models then you've come to the right place.
Index Match MatchIndex Match FormulaCombining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH in this Excel tutorial. Index returns the value of a cell in a table based on the column and row number and Match returns the position of a cell in a row or column. Learn how to them in this guide
Find and replaceFind and Replace in ExcelLearn how to search in Excel - this step by step tutorial will teach how to Find and Replace in Excel spreadsheets using Ctrl + F shortcut. Excel find and replace allows you to quickly search all cells and formulas in a spreadsheet for all instances that match your search criteria. This guide will cover how to
IF AND functions in ExcelIF Statement Between Two NumbersDownload this free template for an IF statement between two numbers in Excel. In this tutorial, we show you step-by-step how to calculate IF with AND statement. Learn how to build an IF statement that will test if a cell contains a value between two numbers and then output the result you want if that condition is met
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.
