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.

In the following, I have described 2 simple and quick methods to go to the end of the 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. Using 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 the 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 Select Cells in Excel Using Keyboard


2. Use of Excel Name Box to Go to the End of the 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 the worksheet automatically. Simple isn’t it?

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

Read More: Multiple Excel Cells Are Selected with One Click


Things to Remember

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

Download Practice Workbook

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


Conclusion

In this article, I have tried to cover all the methods to go to the end of the 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.


Related Articles


<< Go Back to Select Cells | Excel Cells | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo