How to Go to the End of Excel Sheet (2 Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel we often use shortcuts to finish tasks in time. Although at the time of working on a worksheet we need to move to the end of the excel sheet to organize or rearrange data. Sometimes this task becomes difficult to do manually. Thus today in this article, I am going to share with you how to go to the end of excel sheet.

Table of Contents hide

Download Practice Workbook

2 Easy Methods to Go to the End of Excel Sheet

1. Use Arrow Keys to Go to the End of Excel Sheet

2. Utilize Name Box to Go to the End of Excel Sheet

Things to Remember

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Go to End of Sheet.xlsx

2 Easy Methods to Go to the End of Excel Sheet

In the following, I have described 2 simple and quick methods to go to the end of excel sheet.

Suppose we have some Employee Name and their Total Sales in our worksheet. Now we will go to the end of the excel sheet using some simple tricks. Stay tuned!

1. Use Arrow Keys to Go to the End of Excel Sheet

The simplest way to move to the end of an excel sheet is using the keyboard shortcut. Follow the steps below-

Step 1:

While in the worksheet select any cell. Here I have selected cell (B5).
Now press Ctrl+→→ to move to the last row of the worksheet or the end of the worksheet.

From the screenshot, you will see we have moved to the end of worksheet within seconds.

Step 2:

This time we will show you how to go to the end of the sheet column-wise. To do so select a cell (C12) and press the down arrow key (↓) while holding the Ctrl

Finally, the selected cell has moved to the end of the worksheet.

You can also move to the end cell of the worksheet with a keyboard shortcut. Below I have explained the steps. Please follow-

Step 3:

Choose any cell in the worksheet. Here I have selected cell (C12).
Hence, holding the Ctrl key press the down and right arrow (↓→) once.

In conclusion, we reached the end of the worksheet in a glimpse.

In the following steps, I have also shared some more steps which might be helpful to you.

Step 4:

In order to move to the first cell of your worksheet press the Ctrl+Home button.

Thus you will reach the first cell of the worksheet.

If you want you can also go to the last cell of your dataset in the blink of your eye. To do that-

While in a cell (B4) press Ctrl+End.

Within a second, you will move to the end cell of your data table.

Similar Readings

2. Utilize Name Box to Go to the End of Excel Sheet

Using the name box you can move to any cell any time you want. Follow the steps accordingly-

Steps:

First, at the top of your worksheet select the “Name Box”.

Second, double click to edit and put this cell number “XFD1048576” and press Enter.

In conclusion, you will go to the end of worksheet automatically. Simple isn’t it?

Things to Remember

If you are using Mac then you can press the “Fn+^+→” keys to go to the end of your excel sheet.

Conclusion

In this article, I have tried to cover all the methods to go to the end of excel sheet. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.