This means the named range can be accessed by any worksheet in your Excel file. Make sure you hit the ENTER key after you have finished typing the name to confirm the creation of the Named Range.Īs a side note, any Named Range created with the Name Box has a Workbook scope. ![]() You name cannot have any spaces in it, so if you need to separate words you can either capitalize the beginning of each new word or use an underscore (). Here are a list of common names I use on a regular basis: ReportDate Year Month FcstID TaxRate RawData Creating Unique Names On The Fly It is super easy to create a Named Range.Īll you have to do is highlight the cell(s) you want to reference and give it a name in the Name Box. I use named ranges to organize my variables that either are changed infrequently (ie Month or Year) or something that will be static for a good amount of time (ie inflation rate). ![]() How Do I Use Named Ranges As a financial analyst, I play around with a bunch of rates.Įxamples could be anything from a tax rate to an estimated inflation rate.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |