How to Manage Named Ranges in Excel ?
Managing Named Ranges doesn’t have to be confusing!
In this video, I walk you through the full “control room” of your named ranges — where to find them, how they work, how to edit them, and how to clean up unused ones.
00:00 - Introduction to Managing Named Ranges
00:17 - How to Find the Name Manager
00:40 - Understanding Named Range "Scope"
01:08 - Information Available in the Name Manager
01:34 - How to Edit a Named Range
02:07 - Creating and Deleting Ranges from the Manager
02:24 - Using the Filter Button
03:00 - Exploring the Filter Options
✨ How to open the Name Manager
✨ What workbook scope really means
✨ What details Excel shows for each named range
✨ How to fix mistakes, rename, or update the reference
✨ How to create or delete named ranges
✨ How to use the Filter button to quickly sort through long lists
✨ How to check for errors and keep your workbook clean
Perfect for anyone who wants more control and clarity when managing named ranges in their spreadsheets.