Microsoft KB Archive/67816

{|
 * width="100%"|

More Than One Active Cell When Using Split Panes in Excel

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 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, versions 2.x, 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.

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.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :