Microsoft KB Archive/84021

{|
 * width="100%"|

Excel: Macro to View Excel in Split Window on a Macintosh

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

-

SUMMARY
If you are using any version of Microsoft Excel for the Macintosh listed at the beginning of this article, if you want to use key commands to split a window, you must create a macro similar to the following:

  =SPLIT? =RETURN

This macro allows you to create and control horizontal and/or vertical splits.

MORE INFORMATION
When you execute this macro sequence, vertical and horizontal split indicators are displayed across the active document. You can use the arrow keys can to position either split where you want it. To fix the split in the active window, press RETURN or ENTER.

NOTE: In Microsoft Excel version 4.0, the Window Split command can be accessed with the designated menu key followed by W and S. The default sequence for this command is \WS.

This macro and keyboard sequence can also be used to remove a split by using the arrow keys to position a vertical split at the top (or the horizontal split against the left) of the active window. Pressing RETURN or ENTER will then cause the split to be removed.