Search

Maximum rows and columns in Excel Worksheet

 

Each column in Excel Worksheet is identified using letters from A to XFD. From A to XFD, there are 16384 total columns available.

Each Row in Excel Worksheet is identified using numbers from 1 to 1048576. From 1 to 1048576, there are 1048576 total rows available.

An Excel Worksheet's Column Letter starts with Column Letter "A". After the Column Letter "Z", next Column Letters are AA, AB, AC etc. After the Column Letter "ZZ", next Column Letters are AAA, AAB, AAC etc. Last Column Letter used in Excel 2019 is XFD.

An Excel 2019 worksheet has 1,048,576 rows and 16,384 columns.

Last cell excel worksheet

Total 1048576 rows and 16384 columns provide 17179869184 available Cells in an Excel 2019 Worksheet.

Please note that if the Excel Workbook's file format is xls file format, the number of available rows and columns are considerably less.

Related Tutorials
• Important Excel Worksheet Navigation keys
• Excel Cursor and Mouse Pointer Shapes
• Row, Column and Cell in Excel worksheet
• How to change the Row height in Excel worksheet
• Excel AutoFit Row Height
• How to change the Column width in Excel worksheet
• Excel AutoFit Column Width
• How to hide or unhide Rows in Excel worksheet
• How to hide or unhide Columns in Excel worksheet
• What is Active Cell in Excel and How to identify Active Cell
• What is Range in Excel Worksheet and How to form a Range Address
• Examples of Range Addresses in Excel worksheet
• Types of Ranges in Excel Worksheet
• How to select Range in Excel worksheet
• How to select Multiple Range in Excel worksheet
• What is Group mode in Excel, How to exit Group edit mode
• How to select all worksheets to Excel group
• How to select Ranges from different worksheets using Excel Group edit mode
• How to hide or show Excel Worksheet Row and Column headings (Column Letter and Row Number)
• How to hide or show Excel Worksheet Gridlines
• How to change the color of Excel worksheet Tabs
• How to change the color of Excel Gridlines
• How to change the default font and size in Excel
• How to Move or Copy entire worksheet within an Excel workbook
• How to Move or Copy entire worksheet to another Excel workbook