Microsoft KB Archive/20279

{| = Excel: Select Last Cell Chooses Cell Beyond Active Region =
 * width="100%"|

Last reviewed: November 7, 1994

Article ID: Q20279 The information in this article applies to:
 * Microsoft Excel for the Macintosh, versions 1.x, 2.x, 3.0

SUMMARY
It is possible that Microsoft Excel will consider a cell beyond the region being used as the last cell in use.

In Excel version 2.20 and later, this behavior does not affect memory because Excel allocates memory only for cells that contain something.

In Excel versions 1.50 and earlier, this behavior does affect memory. Excel versions 1.50 and earlier allocate memory for every cell between the last active cell and A1.

In most cases, the following procedure will delete those extra rows and/or columns:


 * 1) Select the extra rows and choose Delete from the Edit menu.
 * 2) Select cell A1.
 * 3) Close the worksheet and click OK when asked "Save changes in ?".
 * 4) Reopen the worksheet, select the extra columns and choose Delete from the Edit menu.
 * 5) Repeat steps 2 and 3.
 * 6) Reopen the worksheet and check the position of the last cell.
 * }