Split-Screen Function May Reset Focus in Spreadsheet, Database (118463)


The information in this article applies to:

  • Microsoft Works 3.0
  • 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.

MORE INFORMATION

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).

REFERENCES

"Microsoft Works for Windows User's Guide," version 3.0, pages 47-48, "Viewing several parts of a document at a time"
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:KB118463
©2003 Microsoft Corporation. All rights reserved.