Creating Names For Ranges Of A Table

In an upcoming post we are going to use named ranges of data to perform various functions.  But first we need to know how to easily name those ranges to use in our functions.  Let’s start again with a simple table:

We want to name the sales in column C as Jan, D as Feb, C as Mar and so on, in addition to naming Row 4 as Tom, 5 as Betty, etc.  All we need to do is highlight the table including the column and row names, then click on “Create from Selection” from the Defined Name group of the Formulas tab.  A pop-up box will appear.  Make sure the Top row and Left column boxes are checked and hit OK:

A shortcut you can use instead of clicking on “Create from Selection” from the Defined Name group of the Formulas tab is Ctrl Shift F3.  Now, if you highlight just the data in any row or column of the table you will see the defined name in the name box:

This is great!  Check out any of the rows or columns and the verify that the names have been created.  You can also click on the down arrow in the name box to see all the named ranges  you have:

You’ll see how useful this will be in our next post.  Isn’t the anticipation unbearable?!?!?

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply