Finding the End of the Worksheet

by Allen Wyatt
(last updated June 11, 2016)

When you press Ctrl+End, Excel takes you to the bottom cell of your worksheet. This is defined as the intersection of the right-most column and the bottom row. If you delete some rows or columns in the worksheet, you would expect that Ctrl+End would still take you to the bottom cell. It does not, however. What it does is take you to the original bottom cell.

For instance, if you load a worksheet for which the bottom cell is H20, and then delete three rows and one column, you would expect Ctrl+End to take you to G17. Instead, it still takes you to H20.

The only way around this is to save the file. You don't have to close it, simply save the file. Doing so causes Excel to recalculate the bottom cell.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1923) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Running Macros on Hidden Worksheets

Excel allows you to hide worksheets so that they aren't visible to those using your workbook. Hiding worksheets has a ...

Discover More

Resizing Your Table

Need to make your table a different size? It's easy to do, using the same general technique you use when resizing a graphic. ...

Discover More

Creating a Normal Index

Adding an index to a document is an easy task. There are a couple of ways you can do it, as described in this tip.

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

MORE EXCELTIPS (MENU)

Selecting a Row

Need to select an entire row? Here are two really easy ways to make the selection.

Discover More

Jumping to a Specific Worksheet

Want to make fast work of moving from one worksheet to another? Here's how to do the task when you have a lot of worksheets ...

Discover More

Jumping to the Real Last Cell

Jumping to the last cell in a worksheet should be easy, but you may not always get the results that you expect. This tip ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share