OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

View a Graphical Map of a Defined Name

When you set the Zoom box for a worksheet to a setting that is 39 percent or less, a defined name that consists of a cell range of two or more adjacent cells appears in a rectangle on the screen. When you click Zoom on the Standard toolbar and type a value of 40 percent or greater, rectangles that identify named ranges automatically disappear. .

 

 

Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.