Moving to the Last (or First) Cell in a Range in Microsoft Excel

In this article, we will learn how we can move the last cell in a range in Microsoft Excel 2010 and 2013.

We always use up arrow key or down arrow key or mouse scroll for navigating to the end or start in the Microsoft Excel 2010/2013 range of the sheet. It is helpful when excel has a small range which might be a range of A1: A10. It is easy to use up arrow key or down arrow key.

Let’s take an example to understand how we can move to the last (or first) cell in a range.

We have some student score data in excel range. The range starts from A2: A1500 and this range is sorted based on the rank column. In the data range, it is very difficult to navigate through the last end of the range or come to top on the range.
 
img1
 
Move the cell in a column

To move to last (or First) cell in a range through shortcut method, we can follow below given steps:- 

  • Place your mouse within the range.

 
img2
 

  • Press Ctrl+Down Arrow key to go down to the last cell of selected range.
  • To go up to first cell of selected column, press Ctrl+Up arrow key on your keyboard.

 
img3

 
img4
 

Move the cell in data

If you want to move to first cell of data and last cell of data, follow below given steps:-

  • Place your mouse within the range.
  • Press Ctrl+Homekey to go first cell of the data.
  • Press Ctrl+End key on your keyboard to go the end cell of the data.

 
img5

 
img6

 

Users are saying about us...

  1. hmmm… 2 ways to do it: 1. the raw way: sub GotoLast() while len(activesheet.cells(i,nCol).value)>0 i=i+1 wend activesheet.cells(i,col).activate end sub 2. Using the selection object: If you have a selection, then Selection.end(xlUp) will activate the last cell… Frankly, I tend to use the first one :-| GL BAW

  2. I have a file that appears to be huge…but when I do the CTRL End move, it takes to me a seemingly blank cell. I have deleted the row, the column, and cleared contents. The actual data (that I can see) ends in cell H26, but CTRL END takes me to IS591. Any suggestions on how to delete the excess?

  3. coolcustomessay.com

    Thank you very much for this guide! It’s really helpful for me! I was searching for someting like that in order to make an online essay with way out from such problem

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube