Microsoft Office Tutorials and References
In Depth Information
Resetting the Used Area of a Worksheet
Resetting the Used Area of a Worksheet
When you press Ctrl+End, Excel activates the lower right cell in the used area of the worksheet.
In some cases, you find that the lower right cell in the worksheet is an empty cell — not the real
last cell. In other words, Excel sometimes loses track of the used area of your worksheet. For
example, you may find that a workbook’s file size seems much too large. It’s possible that Excel
has misidentified the used area and is storing a large number of empty cells.
First, try saving the workbook. After the workbook is saved, Excel may correctly identify the last
cell. If Excel still doesn’t identify the last cell, it’s probably because you deleted data but left the
formatting in the cells. To force Excel to identify the real used area, you need to delete the
columns to the right of your data and then delete the rows below your data.
For example, assume that the real last cell in your workbook is G25, but pressing Ctrl+End takes
you to some other cell — M50, for example.
To delete those formatted cells, follow these steps:
1. Select all columns to the right of column G.
To do this, activate any cell in column H; press Ctrl+spacebar, followed by Shift+End, and
then press Shift while you press the right-arrow key.
2. Choose Home
Cells
Delete
Delete Sheet Columns (or, right-click any column header
and choose Delete).
3. Select all rows below row 25.
To do this, activate any cell in row 26. Press Shift+spacebar, followed by Shift+End, and
then press Shift while you press the down-arrow key.
4. Choose Home
Cells
Delete
Delete Sheet Rows (or, right-click any row header and
choose Delete).
5. Save your workbook, and Excel resets the last cell.
After performing these steps, pressing Ctrl+End takes you to the real last cell.
By the way, if you can’t remember Ctrl+End, you can use the Go To Special dialog box. Choose
Home
Find & Select
Go To Special. Choose the Last Cell option and click OK.
 
Search JabSto ::




Custom Search