How Many Rows And Columns Does Excel Have?
Assign a 'primary' menu

How Many Rows And Columns Does Excel Have?

How Many Rows & Columns Does Excel Have?

My young daughter asks some interesting questions.

Such as:

‘Is God bigger than a house?’

But up there amongst the big questions for Excel newbies is

  • ’Just how big is Excel?
  • ‘How many rows and columns does an Excel worksheet have?’
  • ‘How many rows and columns does an Excel workbook have?’

Quick Answer: A Lot!

More than you’ll ever use.

How columns and rows work

All the columns are lettered and all the rows are numbered.

Fig 01: Columns are lettered and rows are numbered

Fig 01: Columns are lettered and rows are numbered

If you were to scroll across the page you reach column Z, then the letters start doubling up with AA, AB and so on. It’s fair to say that if you started scrolling across or down the page now, you would still be scrolling this time tomorrow!

Fig 02: Column Z moves to column AA

Fig 02: Column Z moves to column AA

Just how many rows and columns are there in Excel?

Try this.

  1. Open a blank spreadsheet.
  2. Hold down CTRL and press the right arrow key (cursor key) on the keyboard. You are taken to the right-most column. In the modern versions of Excel this is column XFD, which is 16,384 columns. In older versions of Excel (2003 and prior) the last column was IV which is 256 columns. That's still plenty!
  3. Fig 03: The last column is labelled XFD

    Fig 03: The last column is labelled XFD

  4. Hold down CTRL and press the down arrow key (cursor key) on the keyboard. You are taken to the bottom row. In the modern versions of Excel there are 1,048,576 rows. In older versions of Excel (2003 and prior) there were 65,536 rows
  5. Fig 04: Last column in Excel is 1, 048, 576

    Fig 04: Last column in Excel is 1, 048, 576

  6. To return to cell A1, press CTRL and HOME together. This shortcut works in most programs. For example, in Microsoft Word, pressing CTRL HOME will take you to the top of page 1. In Microsoft PowerPoint, pressing CTRL HOME will return you to slide 1.

So as you can see there are more than enough columns and rows.

Several years ago, I met somebody who did run out of rows! Okay, his situation was unusual.

He ran an energy company. Live energy price data was fed into his system every couple of seconds and filtered through to his spreadsheets. His software used this data to buy low and sell high on autopilot. But every couple of weeks he ran out of rows.

But I'm sure you'll be fine!​

Did this clear something up for you? If so, please share on your socials and/or post a brief comment below.

Likewise, if something didn't make sense or you have a question, pop it into the comments below. I'll be waiting ...

Cheers. Here's to your learning and success. Enjoy the rest of your day.

Jason Morrell blog signature
Jason Morrell blog signature
30 Excel Power Tips

30 EXCEL POWER TIPS

Discover the shortcuts and tricks used by the pros

Office Mastery is the digital arm and official blog of Two Rivers Software Training
Copyright © 2018 Two Rivers Software Training. All Rights Reserved Privacy Terms Contact
Like us on facebook Follow us on Twitter Watch us on YouTube Connect with Jason on LinkedIn
>