Skip to main content

Default count of Rows, Columns, Sheets in Ms-Excel

Default count of Rows, Columns, Sheets depends on the software, data and the memory been used or utilized. As of now I've shared two different screen shots of different software.

1. WPS Spreadsheet 2016.

2. MS-Excel 2019.

Ms-Excel 2019 - Online on one drive
Ms-Excel 2019 - Online on one drive


WPS Spread sheets 2016
WPS Spread sheets 2016
Some of the default rows, columns count are shared as per the software.

VersionRowsColumnsCellsSheets
Excel 201910,48,57616,384 XFD17,17,98,69,184*
Excel 201610,48,57616,384 XFD17,17,98,69,184*
Excel 201310,48,57616,384 XFD17,17,98,69,184*
Excel 200710,48,57616,384 XFD17,17,98,69,184*
Excel 2003 and earlier65,5362561,67,77,216*
Google Sheets2564,00,000200
OpenOffice Calc 310,48,57616,38417,17,98,69,184256
OpenOffice Calc 265,5362561,67,77,216256
Gnumeric65,5362561,67,77,216*
KSpread32,76732,7671,07,36,76,289*
Lotus 1-2-365,5362561,67,77,216256
LibreOffice Calc10,48,5761,0241,07,37,41,82410,000
The shortcuts to be known in excel to find default row & column counts :

1. Ctrl + down arrow -- row count

2. Ctrl + right arrow -- column count


By default, there are three sheets in a new workbook in all versions of Excel, though users can create as many as their computer memory allows. These three worksheets are named Sheet1, Sheet2, and Sheet3.


The total number of characters a cell can contain is 32,767.

If this software is needed do please click here to buy.

Comments