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. .