Knowledgebase: Microsoft Excel
Go To The Last Cell In Excel
Posted by - NA - on 30 March 2006 08:03 AM
Solution:
An easy way to get to the last cell in an Excel worksheet is to press Ctrl + End. However, you're in for a surprise if you press Ctrl + End in some worksheets: You may find yourself way outside of the work area sitting on a blank cell!
This happens when you use a worksheet cell and then later the data. To check this out, run Excel and type data into cell H99. Now, delete the data in cell H99 and type data into cells A1 through C5. If you press Ctrl + End, Excel will take you to cell H99 even though it's blank, rather than to cell C5, which is probably where you want to go.

(128 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako Fusion