AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Step 1: Press F5, click Special, then select constants and check only the numbers box To see a video tutorial of Go To Special, check out our free Excel Crash Course.īelow is an example of how to select all hardcoded (constant) numbers in a financial model. On the Home ribbon under “Find and Select” choose “Go To”.Constants (numbers, text, logicals, errors).Formulas (numbers, text, logicals, errors).The Go To Special function in Excel allows you to quickly select all cells that meet certain criteria, such as cells containing: What is the Go To Special function in Excel?
0 Comments
Read More
Leave a Reply. |