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.
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:-
Move the cell in data
If you want to move to first cell of data and last cell of data, follow below given steps:-
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.