How many rows and columns are there in Excel 2016?

Microsoft 365, Microsoft Excel, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Office 2019, Office 2021 / Office LTSC, Office 365, Office for Mac, Of

How many rows and columns are there in Excel 2016?

Microsoft 365, Microsoft Excel, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Office 2019, Office 2021 / Office LTSC, Office 365, Office for Mac, Office Watch, Office XP /

Excel the full history of rows and columns

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, its not true.

The maximum rows/columns in Excel is limited by the version of the product, not its 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 its still commonly believed that Excel is limited to 65,536 rows when Excel 2007 (32-bit) increased that to 1,048,576 rows.Excel versionMaximum
RowsMaximum
ColumnsMax. Column
by letterExcel for Windows
Excel 365
Excel 2021/LTSC
Excel 2019
Excel 2016
Excel 2013
Excel 2010
Excel 2007

1,048,576

16,384

XFDExcel for Mac
Excel 365
Excel 2021/LTSC
Excel 2019
Excel 2016
Excel 20111,048,57616,364XFDEarlier versions
Excel 2003
Excel 2002 (XP)
Excel 2000
Excel 97

65,536

256

IVExcel 95
Excel 516,384256IV

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 cant 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 2GBthough 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 youre working with large workbooks, its 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 Mortalstoday

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.Invalid email addressThanks for subscribing!

Video liên quan