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

ID: Q84021

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.

REFERENCES

"User's Guide," version 3.0 for the Macintosh, pages 209-210

Additional query words: 2.20 3.0 4.00

Keywords :
Version :
Platform :
Issue type :