Difficulty Canceling Split Panes in Excel

• Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

SUMMARY

Canceling split windows in Microsoft Excel is more precise in versions 3.0 and later than it was in earlier versions.

How to Split

Microsoft Excel version 5.0 and 4.0

From the Window menu, choose Split. The window is split above and to the left of the active cell, to the left of the selected column, or above the selected row.

Microsoft Excel versions 3.0 and 4.0

From the window control box (-), choose Split to display a cursor with a four-sided arrow in the center of two gray bars. The cursor can be placed anywhere on the worksheet to split the window into four panes.

How to Cancel a Split

Microsoft Excel version 4.0 and 5.0

1. Double-click any part of the split bar, or choose Remove Split from the Window menu.

1. Select the document control menu (ALT+HYPHEN).

2. Select Split from the menu.

3. Press CTRL+HOME, and then the ENTER key.

Microsoft Excel version 3.0

To cancel the split window panes in version 3.0:

1. Select the document control menu (ALT+HYPHEN).

2. Drag (use the mouse or press the UP and LEFT ARROW keys) the split bars to the upper left of the screen.

3. Move the split bars just to the left of the column numbers and just above the column headings. The cursor must be placed EXACTLY at this location or the window will not appear as normal.

4. Click the mouse (or press ENTER).

MORE INFORMATION

In versions of Microsoft Excel earlier than 3.0, you can drag the split window bars beyond the worksheet windows and click the mouse, this effectively cancels the split windows. Performing the same mouse movements in later versions has no effect and the window remains split. However, in later versions, you can drag the split window bars to the very edge of the worksheet window to remove them, you do not have to click the mouse.

REFERENCES

"User's Guide 1," version 4.0, page 253 "Microsoft Excel User's Guide," version 3.0, page 219