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!

This entry was posted in Workbook/Reference Lessons and tagged , , , , , . Bookmark the permalink.

34 Responses to Excel Video Lesson: Naming Ranges and Cells

  1. Anonymous says:

    Hi Ben, Thank you so much. It’s really useful video.

  2. Anonymous says:


  3. Anonymous says:


  4. Maham S says:

    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!

  5. Aditi s More says:


    • katieK says:

      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.

  6. gee says:

    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

  7. mario cc says:

    what excel are we using on these lesson

  8. Debasish Dash says:

    How i could download these videos?

  9. Anonymous says:

    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.
    Please make the correction.

  10. Anonymous says:

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

  11. Anonymous says:

    I can hear an ambulance car in all of your videos. Do you live next to a hospital?

  12. Mihaela Manu says:

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

  13. Alison says:

    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!

  14. Anonymous says:

    couldnt catch what you are saying on 09:14 – 09:15 ? 😉

    • 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 🙂

  15. danny says:

    Thanks again

  16. Anonymous says:

    Well done, Excel master!

  17. Ang says:

    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?

  18. Anonymous says:

    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.

  19. Calvin says:

    Great video. I can’t believe I’ve gone this long without naming!

  20. Pingback: A Complete Introduction to Excel | MBAx.me

  21. zubair says:


  22. Alejandro Rodrigues says:

    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 😉

  23. Shweta says:

    Very good for someone who is trying to learn @home .looking for some practice exercises

  24. Anonymous says:

    Really Fantastic Jobb! 🙂

  25. Anonymous says:

    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! 🙂

  26. KosherDog says:

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

  27. rhane says:

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

  28. Defrew says:

    You’re very good at teaching! And it’s easy to follow!

  29. haeso says:

    Thank you!
    I didn’t know about the Name Manager, that’ll come in handy.

Comments are closed.