XL: Last Cell Detected Incorrectly After Change Row Height

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

SYMPTOMS

In Microsoft Excel, when you change the row height on your worksheet or macro sheet from the default, the last cell on the worksheet is not detected correctly.

CAUSE

This behavior occurs when you change the row height on your worksheet or macro sheet to a value other than the default value. When you delete rows that contain data or formatting and then save the sheet, the address of the last cell is not reset if you have changed the default row height for this range.

For example, if you enter data in the range A1:C10 on a new worksheet, the last cell is cell C10. If you delete the data from rows 5 through 10, and save the file, the last cell should be cell C4. However, if you have changed the row height for rows 1 through 10, the last cell is still detected as cell C10, even after you save the file.

Note that this behavior does not occur in Microsoft Excel version 4.0.

WORKAROUNDS

To work around this problem, do the following:

1. Select the affected rows on the worksheet. (Note the original height of the rows.)

2. On the Format menu, point to Row, and then click AutoFit.

3. Save the file.

   When you use the Go To Special dialog box to select the last cell on the worksheet, the correct cell is now selected.

4. Select the affected rows and apply the original row height formatting.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about the Go To Special Dialog Box, choose the Search button in Help and type:

   go to special