How Many Rows and Columns There Are in Excel (And How to Jump to the Last Row or Column)

Today we’re going to talk about how to find out the number of rows and columns in a spreadsheet. And not only that. We’ll also have a look at how we can jump to the last row or column in a split second.

Ready to start?

How to Check the Exact Number of Rows And Columns In an Excel Spreadsheet

We can check the exact number of rows and columns in an Excel spreadsheet by clicking into the upper left-hand corner of the sheet. We hold the mouse button and here, in this field above, we see the exact number of rows and columns.

So, in Excel we can use up to one million, forty-eight thousand, five hundred and seventy-six rows and sixteen thousand, three hundred and eighty-four columns. Quite a lot, right?

To jump to the last row, just press the Control key along with the ‘arrow down’ key and there we are!

How to Jump to The Last Row and Get Back Up

To get back up, press the Control key again, but now hit the upward arrow key. And you’ll find yourself in the first row again!

How to Jump to The Last Column and Get Back Up

The same way we can move across columns. Press the Control key and the ‘right arrow’ key. Excel will set the cell cursor in the last column marked as ‘XFD’.

To get back, press Control and the ‘left arrow’ key. And here we go! We’re back in column A.

Would you like to know more interesting facts about Excel? Type ‘Yes’ in the comments section below and we’ll be happy to prepare more short tutorials from the series ‘Interesting Facts About Excel’.

Don’t miss out a great opportunity to learn:

• Shortcut Key to Insert Rows in Excel (Excel Shortcuts)
• Shortcut Key to Delete Rows in Excel (Excel Shortcuts)
• How to Number Rows in Excel (The Simplest Way)

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!