Microsoft KB Archive/118463

= Split-Screen Function May Reset Focus in Spreadsheet, Database =

Article ID: 118463

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q118463



SUMMARY
Selecting cells or fields in the Works Spreadsheet or Database in list view to add to a formula in another pane causes the pane with the selected cells to scroll the cell with the formula into view.

For Example:

If you have a Works spreadsheet split into panes showing different parts of the spreadsheet, and you type an equal sign (=) in a cell in one pane, then select a cell in a second pane and press ENTER, the second pane scrolls to display the cell in which you typed the equal sign (=).

This behavior is by design in Works versions 3.0, 3.0a, and 3.0b. This feature was not available in Works 2.x.

For more information about using panes in Works documents, please see the "References" section at the end of this article.



Steps to Reproduce Situation

 * 1) Create a new Works spreadsheet or database in list view.
 * 2) From the Window menu, choose Split.
 * 3) Click the left mouse button in the center of the document (to split the document into four panes).
 * 4) Place the highlight in column one, row one of the top-left pane.
 * 5) Type =.
 * 6) Click the left mouse button on any cell in the bottom-right pane, then press ENTER.

Note that the bottom-right pane scrolled position to show the cell where the formula was added (row one column one).

