How many rows and columns are there in Excel

Excel2003 (. xls) file: The maximum 256 (iv,2 8) column, the maximum 65536 (2 16) row, that is 256 cells horizontally, vertical 65,536 cells.

Excel2007 (. xlsx) file: The maximum 16384 (xfd,2 14) column, the maximum 1048576 (2 20) row, that is 16,384 cells horizontally, vertical 1,048,576 cells.

If you want to test yourself, the method is also very simple. Open the version of Excel you installed on your computer, and then click a cell, press ctrl+↓ down to the last line, and hold ctrl+→ to the last column. Excel2007 compared to Microsoft Office Excel 2003, it provides a 1,500 increase in available rows and a 6,300 increase in available columns.

Three, then the current excel2010 is how many rows and columns? Actually, it's the same as excel2007. You can also press and hold down the ctrl+↓ to the last line, holding down ctrl+→ to the last column.

Classification:

• Excel Tutorials