Excel Named Ranges Explained
Excel 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. Let's look at a simple example of how you might use a Named Range. Say you had a range of cells containing sales figures, …