There is, however, a little trick that will allow you to see all your named ranges at one time rather than going to each on individually. Not a lot of folks know about this but I’m going to share it with you!
Follow the steps below:
All you really have to do is change the Zoom factor for your workbook to 39% and you will then see the named ranges on screen as blocked area.
Make note, that this will only work for you when your Zoom factor is 39% or less. At 40% or greater, the named ranges are not marked and single cell ranges are not shown at all.