# Excel Video Lesson: Naming Ranges and Cells

## Named Ranges in Excel

This video tutorial explains how you can name ranges or cells for use within functions & formulas.  It is a great follow-up to the last video lesson on Absolute & Relative cell referencing.

I’ve found it incredibly useful throughout Excel.  It helps to alleviate the concern that you’re pulling information from the wrong area, and makes formulas more easy to follow.

If you found this Named Ranges video interesting, you may want to check out the Five Powerful Excel Tips video which goes over Dynamic Named Ranges (which allow for the named ranges to change as more data is added to them).  It’s the first tip in the lesson!

## 33 thoughts on “Excel Video Lesson: Naming Ranges and Cells”

1. I really appreciate your free services on Excel and i am in the process of learning it so these are coming handy. However, i think by jumping into VLookup right after introductory lessons really confused many people out here!

HOW DID U DO VLOOKUP?U KNOW PPL ARE LEARNING Y U ARE SO FAST DID YOU EVEN SHOW HOW VLOOKUP IS DONE?????

• Hi, you may want to check out the previous lesson on the guide, “Absolute and Relative Cell Referencing (i.e. the \$ sign),” in which he explains how vlookup is done on this same sheet. This video appears to be a continuation of that one.

3. Hi, i cant seem to access the videos in a library. I ve used chrome but its just said the webpage may have been moved…

can you help please ? thank you

• All the lessons are Excel 2010 unless otherwise mentioned.

– Ben

4. Hello, there is a calculation error on this sheet. The sum of student test scores in column one is 783 instead of the shown 733.

• Hi there,

You are correct! I have just updated the workbook to fix the error.

Thanks for double-checking and letting me know!

Cheers,

Ben C.

5. kudos to you.. great knowledge you got there and you share it for free…

6. I love your site. Thank you very much to share you knowledge with us .
Always grateful.
Bobo

7. I’ve it the video crash on me a few times. Maybe it was my browser. But, could you also include a YouTube link as an option?
Thank you!

• It’s not very audible because I was kind of talking to myself 🙂

I said “Actually it doesn’t seem like many people are very good”, referring to the students’ test scores. The wink leads me to believe you may have caught it 🙂

8. I love your site! I am analyzing huge amounts of data that I import weekly from a database and utilize the named data ranges in formulas to pick up information. Sometimes it will grow or shrink in the number of rows (but never in the # of columns) when I sell something new. Is it possible to name a range of data that will automatically grow with the newly imported data?

9. Very helpful video. I’ve known about named ranges for a while, but have always been afraid of not using them correctly. This finally gives me some confidence to start.

10. Thanks a million!!! This is the best video tutorial that i’ve found on the web… I’l be waiting for your next video on this subject. Thanks again 😉

11. For some of us this goes too quick, but still very helpful. It is good to know you can go online and learn these applications. The MUSIC has got to go! 🙂

12. Another fantastic lesson! Will need to watch this a couple of times, as it is so packed with useful information!

13. I agree. You’re approach is not complicated. Thank you so much for you’re efforts. I’m enjoying every lesson.