How many rows in Excel 2003

From what i understand there is no way around it, a newer version of Excel is what you need. Someone may have come up with a hack to make it work since i last looked a few years ago but my guess is it would make Excel unstable.

I have found some VB Script on the the internet, that put all data at every 65536th entry onto a new page. but it did not look like a simple task to do.

The VB I've found was specifically aimed at pulling in large text files, not spreadsheet data (with formulas, etc).

As a thought, if you open the spreadsheet in 2003, it'll pull in the first 65536 rows, but then display a message that the file's been truncated.

If you then also pull the data into Access as I mentioned earlier, you could paste rows 65537 onwards in a new worksheet (in your already open spreadsheet) and copy the formatting and formulas from the first rows.

The intersection of a column and row is called a cell. The cell is identified by the row number and column header, for example, B3.

Tutorial Content

• Number of columns and rows in one sheet
  • Excel 2003
  • Excel 2007 and newer
• Determining the column number
• Navigating Rows and Columns
  • Moving one cell at a time
  • Moving to the first/last column/row

Number of columns and rows in one sheet

Depending on the Excel version you use, there is a different number of rows and columns.

Excel 2003

In Excel 2003 there are 65,536 rows and 256 columns (IV).

Excel 2007 and newer

Since Excel 2007 the number of rows and columns is much bigger than before. This time there are 1,048,576 rows and 16,384 columns (XFD).

Therefore the last cell is XFD1048576.

Determining the column number

To know the number of rows is easy, but it’s much more complicated with the column header. How you can quickly determine what is the header for the column 2000?

You can use the following formula.

1

=LEFT(ADDRESS(ROW(),A2,2),FIND("$",ADDRESS(ROW(),A2,2),1)-1)

Just enter it to a cell and type the number into cell A2.

The column header for the 2000th column is BXX.

If you want to know more about other ways to get column header, read an article about this subject.

Navigating Rows and Columns

Moving one cell at a time

To move one cell left, right, up or down you can use keyboard arrows.

You can also use:

Enter – move down

Tab – move right

Shift + Enter – move up

Shift + Tab – move left

Moving to the first/last column/row

To move to the last column, use Ctrl + right arrow.

To move to the last cell, use Ctrl + down arrow.

It only works if you don’t have any cell in your way, otherwise, it will stop on the last cell in this area. In this case, you have to use the keyboard shortcut one more time.

In the following example, I selected cell A2. Now I press Ctrl + right arrow and the cursor stops at C2. I press one more time and it stops at E2.

by Office Watch      15 October 2021

How many rows and columns does Excel have now and in the last 25 years of Excel for Windows and Mac?

All the talk about 64-bit versions of Office has raised the issue of maximum rows and columns in Excel. A few readers seem to believe that 64-bit Excel will have more rows or columns than the 32-bit version. While that might be theoretically possible, it’s not true.

The maximum rows/columns in Excel is limited by the version of the product, not it’s ‘bitness’.

Having larger worksheet sizes just for 64-bit Excel would cause all sorts of document compatibility issues. Microsoft rightly wants their documents accessible to all copies of that application and version – regardless of whether it is 32-bit and 64-bit.

The reader messages made it clear that it’s still commonly believed that Excel is limited to 65,536 rows when Excel 2007 (32-bit) increased that to 1,048,576 rows.

1,048,576

16,384

XFD

65,536

256

IV

The .xls trap

Excel 2007 and later get downgraded to the lower Excel 2003 limits (65,536 x 256) when opening a .xls document.  The older, less secure, Excel formats can’t cope with a higher number of rows/columns so Excel limits workbooks to the constraints of the file format.

See What happen with UK COVID tracking and Excel?

To get larger worksheets, save the document to the Excel 2007+ .xlsx format.

Worksheet / tab limit

The number of worksheets in a single document/spreadsheet is another constraint. Excel 2007/2010 can theoretically handle 255 worksheets in a single document; however the practical limit is memory. The amount of memory available to Excel depends on both the operating system and version of Excel.

Excel 64-bit can access considerably more RAM and thus can deal with more worksheets at the same time. Excel 2010 and Excel 2007 32-bit versions have an upper memory limit of 2GB though other limitations may kick-in before you reach that.

Excel 64-bit can theoretically access 8 TERAbytes of memory, a 4,000 fold increase.

In other words, if you’re working with large workbooks, it’s much better to use 64-bit Office.

See Also

• Hiding Columns and Rows in Excel
• Rearranging PivotTable Rows and columns
• Sparklines make simple graphs for Excel
• What happen with UK COVID tracking and Excel?

Join Office for Mere Mortals today

Office for Mere Mortals is where thousands pick up useful tips and tricks for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  We've never spammed or sold addresses since we started over twenty years ago.

How many rows and Columns are there in Excel 2003?

How many Columns does Excel 2003 have?

How many cells are there in Excel 2003?

What is the number of rows and Columns in Excel 2003 and 2007?