Microsoft KB Archive/840982

= The cell or the cell range that you modified most recently does not appear in the viewable area when you open a saved Works Spreadsheet file =

Article ID: 840982

Article Last Modified on 5/17/2004

-

APPLIES TO


 * Microsoft Works 7.0 Standard Edition
 * Microsoft Works 6.0 Standard Edition
 * Microsoft Works Suite 2004 Standard Edition
 * Microsoft Works Suite 2003 Standard Edition
 * Microsoft Works Suite 2002 Standard Edition
 * Microsoft Works Suite 2001 Standard Edition
 * Microsoft Works Suite 2000 Standard Edition

-





SYMPTOMS
When you open a saved Microsoft Works Spreadsheet file, the cell or the cell range that you modified most recently does not appear in the viewable area.



CAUSE
This issue occurs because the Microsoft Works Spreadsheet module starts the viewable area with the A1 cell, and the data or the selected cell may not be in the viewable area.



WORKAROUND
To work around this issue, use one of the following methods.

Method 1: Use keyboard shortcuts to locate your data
To locate your data in an open Works Spreadsheet file, use the following keyboard shortcuts:
 * CTRL+ END selects the cell at the intersection of the last row and the last column that contain data.
 * PAGE UP and PAGE DOWN scroll through the file.
 * CTRL+G allows you specify a cell reference to display.

Method 2: Use range names to display your data
To create a range name, follow these steps:
 * 1) Start Works.
 * 2) Use a click-and-drag operation to select the range of data that you want to name.
 * 3) On the Insert menu, click Range Name.
 * 4) In the Name box, type a name for the range, and then click OK.

To use range names to display your data, follow these steps:
 * 1) Start Works.
 * 2) Open the file that you want to work with, and then press CTRL+G.
 * 3) Under Select a range name, click the range name that you want to view, and then click Go to.

Keywords: kbprb KB840982

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.