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 (840982)



The information in this article applies to:

  • Microsoft Works 7.0
  • Microsoft Works 6
  • Microsoft Works Suite 2004
  • Microsoft Works Suite 2003
  • Microsoft Works Suite 2002
  • Microsoft Works Suite 2001
  • Microsoft Works Suite 2000

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.

Modification Type:MajorLast Reviewed:5/17/2004
Keywords:kbprb KB840982 kbAudEndUser