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

by  About
       

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

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.

Using of Ctrl and up arrow key or ctrl and down arrow key,

The below mentioned example will help to navigate the range in Microsoft Excel 2010/2013 and make our work easier.

Suppose we have some student score data in excel range as below, the range starts from A2 till A1500 and this range is sort 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

 

1

 

Now if we use the shortcut then we can follow the tips below:

ü  Down the range

  • Place your mouse within the range
  • Press ctrl key and down arrow key

 

ü  Top of the range

  • Place your mouse within the range
  • Press ctrl key and UP arrow key

 

2

 

 

 

3

 

 

Note: – This feature would work on one range only. For the entire range we would use the steps below to navigate to end of the range or top of the range

  • Ctrl + Home to go to the top of the entire range
  • Ctrl + End to go to the bottom of the entire range

 

4

 

 

 

5

 

 



5 thoughts on “Moving to the Last (or First) Cell in a Range

  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?

Leave a Reply

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


9 × three =

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>