If you click on a Name Excel will take you to the sheet the range is on and highlight the cells for you. Once you’ve set up some Named Ranges you can click on the drop down arrow on the Name Box to see a list of Names. I’ve entered the name ‘NameBox’ in the graphic below, but yours will most likely display the active cell reference. You’ll find the Name Box just to the left of the formula bar. Naming a Range in Excel is actually quite straight forward.Ģ) Type a name in the Name Box and hit Enter. I'll list some uses for Named Ranges later in this tutorial and cover the rules, and some advanced features, but first let’s take a look at how to name a range in Excel. You instantly know what that formula is doing. For example, rather than say =SUM(D5:D600), which requires you to go hunting around to find out what D5:D600 represents, imagine how much quicker and easier it is to read =SUM(Sales). If you’ve ever endured the frustration of trying to decipher a spreadsheet someone else has created you will love how easy Named Ranges make reading and interpreting formulas. Not only is this easier than entering =SUM( and then highlighting the range and hitting enter, but it’s also more intuitive if you ever have to revisit the spreadsheet weeks or months later. ![]() If you then wanted to Sum the range you could simply enter a formula that read =SUM(Sales). Say you had a range of cells containing sales figures, you could highlight the cells and name the range ‘Sales’. Let's look at a simple example of how you might use a Named Range. Excel for Customer Service ProfessionalsĮxcel Named Ranges enable you to give one, or a group of cells a name other than the default D3 for a single cell, or E3:F50 for a range of cells.
0 Comments
Leave a Reply. |