It depends of the version of Excel you are running. Excel 2007, 2010 and 2013 have 1,048,576 rows and 16,384 columns. Excel 97, 2000, 2002 and 2003 have 65,536 rows and 256 columns. Excel 5 and 95 have 16384 rows and 256 columns.
Because of different technology and design between various versions of Excel. Older versions of Excel have less capability for many reasons, including the capability of the computers for which they were designed (e.g. Processor Speed, Amount of RAM, etc.).
It is related to powers of 2, as computers are based on binary. If you start at 1 and keep doubling you will come to 256, which is what column IV is, and also to 65536:
1
2
4
8
16
32
64
128
256*
512
1024
2048
4096
8192
16384
32768
65536*
In Excel 2007 there are 16384 columns, one of the numbers above. If you keep on doubling, you will come to the amount of rows in Excel 2007:
131072
262144
524288
1048576*
They may seem like obscure numbers, but they both have a significance. If you take the number 2 and keep doubling it, you will eventually get to 65536 and eventually to 1048756. Computers are based on binary, which uses values on a mathematcial base of 2. If you look through the list you will see other numbers that are regularly used in computers, like the amount of megabytes in RAM.
2
4
8
16
32
64
128
256
512
1024
2048
4096
8192
16384
32768
65536
131072
262144
524288
1048576
If you start at 1 and keep doubling you will get 2, 4, 8, 16, 32, 64, 128 and 256. If you continue doubling you will come to 65536. Computers are based on the binary system, which relates to 2 and powers of 2. 28 = 256. 216 = 65536. In versions of Excel since version 2007, there are 16384 columns which is 214 and 1048576 rows which is 220.
It may seem like an unusual number but there is a significance to it. It is 220 which is 2 multiplied by itself 20 times. If you start at 1 and keep doubling, you will reach it too. As you double you will pass 16,384 which is the amount of columns in Excel. Older versions of Excel have 256 columns and 65,536 rows. Those numbers are also in that set when you start doubling from 1. All of this relates to the fact that computers work based on the binary system, which is base 2, a mathematical system based on 2.
Up to Excel 2003 there were 65536 rows and 256 columns. Microsoft Office Excel 2007, 2010, 2013 and 2016 worksheets contains a maximum of 1,048,576 rows and 16,384 columns.
Because at times it has to deal with large amounts of data. Excel 2003 had 65,536 rows. Because this wasn't enough for some users, it was extended to 1,048,576 in Excel 2007.
The total number of rows and columns on a Microsoft Excel (2016) spreadsheet are: 1,048,576 rows by 16,384 columns.
There are 256 Columns and 65,536 Rows in Excel 2000.
There are 256 Columns and 65536 Rows in Excel 2003.
Microsoft Excel
Spreadsheet, such as that in MicroSoft Excel
In Excel 97 there were 256 columns and 65536 rows.
There are virtually unlimited rows and columns in Microsoft Excel.However, the finite amount of memory and the finite amount of processing power available define a natural boundary. This boundary varies from system to system, and cannot generally be expressed in numbers of rows and columns. Suffice to say that Microsoft Excel supports a very large number of rows and columns on a modern computer.
There are 1,048,576 rows and 16,384 columns in Excel 2010
In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.
The last cell in Excel 2007 is XFD 1,048,576 There are 16,384 columns and 1,048,576 rows.
Colums : 16384 Rows : 1048576
it is a spread sheet application arranged in rows and columns
65,536 rows by 256 columns gives 16,777,216 cells.