Excel Basics: Named Ranges

YoDawg_zps1be26825

Yesterday we took a quick look at cell referencing in Excel, today we will go one step further with it and look at both ranges and named ranges in Excel. Again to re-iterate, we are covering some basics here so that when we start to look at formulas and where we can use them, everyone is on the same level (or at least has somewhere to go for more info).

Ranges

Screen Shot 2018-10-05 at 10.54.08

A range in Excel is a cell reference with two cells involved which are the upper left cell and lower right cell. Together they give us a range of cells within an Excel sheet. In the example below we have entered C4 as the upper left cell and E9 as the lower right cell. We can also do this by selecting C4 and dragging the mouse to E9. 

There is also the option of having multiple ranges within one selection.

Screen Shot 2018-10-05 at 10.57.46

Named Ranges

If we are going to be in the position of using the same range within a number of formulas and the range itself doesn’t change within the formulas, then rather than using absolute references within the formulas we can use a named range. This does exactly what it sounds like, it lets us name a range. To perform this:

  • Select Formulas from the data tab
  • Select Define Name
  • Type desired name, select cell range
  • Select OK

Thats the next step towards using formulas in Excel taken……getting closer and closer!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at WordPress.com.

Up ↑

%d bloggers like this: