Excel: Using GET.WINDOW() to See if Window Is Split or Zoomed

SUMMARY

Microsoft Excel version 2.20 has four additional undocumented arguments for the GET.WINDOW() function that deal with split windows and whether the window is maximized (zoomed). The second and third arguments below also apply to Excel version 1.50.

These four arguments are not mentioned on page 239 in the "Microsoft Excel Functions and Macros" version 2.2 manual nor are the ones that apply to Excel version 1.50 mentioned on pages 240-241 in the "Microsoft Excel Arrays, Functions, and Macros" version 1.5 manual.

The four omitted arguments are as follows:

1. GET.WINDOW(17) returns the quadrant of the active cell. If the window is not split, this returns a "1". If the window is split in half vertically, the left quadrant is 1, the right is 2. If the window is split horizontally, the top quadrant is 1, the bottom is 3. If the cell is split horizontally and vertically, the quadrants are numbered clockwise starting with the upper-left corner.

2. GET.WINDOW(18) returns TRUE if the window is split vertically, or FALSE if it is not split vertically. (Also works in Excel 1.50.)

3. GET.WINDOW(19) returns TRUE if the window is split horizontally, or FALSE if it is not split horizontally. (Also works in Excel 1.50.)

4. GET.WINDOW(20) returns TRUE if the window is maximized (zoomed), or FALSE if it is not maximized.