Excel - Display All Named Ranges In Excel At Once - Episode 1879
1,793 views · Published 24 April 2014 · 1:36 · Indexed 18 October 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: See All Named Ranges in Excel Worksheet at Once. f you change your zoom to 39% or lower, Excel 2013 will show you the name and shape of your named ranges. Thanks to Excel MVP Bob Umlas for showing me this great trick! Welcome to another episode of the MrExcel Podcast. In this episode, we will be discussing a useful tip for Excel users, thanks to the Excel MVP and author of "Excel Outside the Box," Bob Umlas. During a recent 3-day bootcamp, Bob shared with me a great tip that allows you to see all of your named ranges at once. As you may know, you can name ranges in Excel, but it can be difficult to keep track of where they are located. Sure, you can open the Name Box to see each individual range, but wouldn't it be nice to see all of them at once? Well, thanks to Bob's discovery, you can do just that by changing the Zoom to 39% or lower. To try this out, simply click on the Zoom button and lower it to 39%. Excel will then display a tool tip that shows the name and size of each range. You can even go as low as 10% to see all of your named ranges. Of course, you'll want to find the perfect balance between visibility and size, so feel free to experiment with different zoom levels. And don't forget to check out Bob's book, "Excel Outside the Box," for more great tips like this one. I want to give a big thank you to Bob for sharing this cool trick with us. And thank you for tuning in to this episode of the MrExcel Podcast. Don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Show All Named Ranges in Excel (00:25) Example of Naming a Range (00:35) Solution to Finding Named Ranges (00:51) Change Zoom to 39% or Lower (01:12) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelhacks #excelnamedrange This video answers these common search terms: how to show all named ranges in excel? display all named ranges in excel view all defined names in excel show named ranges on a worksheet in excel how to list all names in excel list all named ranges in excel how to see a list of named ranges in excel displaying named ranges in excel workbook list of defined names in excel show all named ranges on a worksheet in excel excel named range list reveal all named ranges in excel workbook Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153704/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920