More Than One Active Cell When Using Split Panes in Excel

 Last reviewed: November 30, 1994
Article ID: Q67816
The information in this article applies to:
  • Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2 versions 2.20, 2.21, 3.0
  • Microsoft Excel for the Macintosh version 2.x and 3.0

SUMMARY

When you use a Microsoft Excel spreadsheet that has split panes, the F6 function key can be used in conjunction with the SHIFT key to move the active cell between the panes. However, if the different panes include the same cells in their own views of the spreadsheet, the spreadsheet will appear to have multiple active cell markers.

MORE INFORMATION

F6 Key

The F6 function key will move the active cell to the next pane. For example, if the sheet is split into four panes and the active cell is in the upper-left pane, the F6 key will move the active cell into the upper-right pane. The upper-left pane will have a cursor in the same cell that the active cell is in, in the upper-left pane. This cursor will continue to display until the upper-right pane is scrolled to contain cells other than the cells in the upper-left pane. This cursor shows that the upper-left and upper-right panes contain the same cell. As a result, if information is entered in the active cell in the upper-right pane, it will be reflected in the same cell in the view of the upper-left pane.

F6+SHIFT

F6+SHIFT moves the active cell to the previous pane. For example, if the sheet is split into four panes and the active cell is in the upper-left pane, the F6+SHIFT key sequence moves the active cell to the lower-left pane. Again, the cursor is displayed in both the lower-left and upper-left pane, as described above.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00
3.0 4.00 4.0 upper left lower right

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.