Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

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


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.

Use Arrow Keys to Go to the End of Excel Sheet

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

Use Arrow Keys to Go to the End of Excel Sheet

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

Use Arrow Keys to Go to the End of Excel Sheet

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

Use Arrow Keys to Go to the End of Excel Sheet

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.

Use Arrow Keys to Go to the End of Excel Sheet

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

Use Arrow Keys to Go to the End of Excel Sheet

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.

Use Arrow Keys to Go to the End of Excel Sheet

Read More: How to Go to Last Non Empty Cell in Column in Excel


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”.

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

  • 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?

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

Read More: How to Select Column to End of Data in Excel (3 Easy Methods)


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.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo