If you have been working with excel for a long time, you probably worked with sheets with thousands of lines. In such tables, it is essential to move quickly between cells, especially, moving to the first cell and the last cell of the table. If you don’t know how to do so, today, we are going to learn that.
It is actually very simple to move the cursor to the first cell of the dataset. On a Mac, you can hold the command button and then press the up arrow. Now, you can guess the way to go down which is by holding the Command button and press the down arrow key.
The trick is applicable to going right and left. If you want to go to the rightmost cell of your data table, you can hold the Command key and then press the right arrow. Likewise, you can hold the command key and then press the left arrow key to go to the left most cell of the data table.
Please remember that the cursor will only move the marginal cells of the data table. That means the cursor only moves to the non-empty cells.
So, that’s how you move the cursor around the data table. If you wan to move the cursor to the first cell of the sheet, simply go to the address box and type A1.
I hope you enjoy this Excel tip. Please have a look at our new add-in: excel autocomplete. It helps you enter data in excel workbook faster and much more accurate.