## Answer

###### Wiki User

###### 01/07/2016

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.

## Related Questions

###### Asked in Microsoft Excel

### How many cells are in an Excel 2007 sheet?

In Excel 2003 there were 256
Columns and 65536 Rows, making
it have a total of 16,777,216 cells.
In the expanded Excel 2007 there are
1048576 rows and 16384 columns(xfd) ,
so it has a total of 17,179,869,184 cells.
...

Read More

###### Asked in Microsoft Excel

### How many cells in Excel 2007?

Excel 2007 has 1,048,576 rows and 16,384 columns, so you it has
a total of 17,179,869,184 cells.
...

Read More

###### Asked in Microsoft Excel

### How many rows and columns are there in Excel?

That depends on the version you have. Up to Excel 2003, the
standard amount of columns has been 256. They are labelled by
letters. After Z you get AA, AB, AC etc. until you get to AZ. Then
it is BA, BB, BC and so on. The 256th column is IV. There have been
65,536 rows, all numbered. That makes 16,777,216 cells. That was
the case up to Excel 2003.
In Excel 2007 the maximum number of rows per worksheet increased
to...

Read More

###### Asked in Microsoft Excel

### How many cells of Microsoft Excel v2010?

There are 1,048,576 rows and 16,384 columns in a Microsoft Excel
2010 spreadsheet. So if you multiply 1,048,576 by 16,384 you get
17,179,869,184 cells.
...

Read More

###### Asked in Microsoft Excel

### How many cells are in an Excel workbook?

Since Excel 2007, there are 1,048,576 rows by 16,384 columns in
each worksheet. So the total number of cells would be 1,048,576
rows X 16,384 columns which is 17,179,869,184 cells. As there are 3
worksheets in a workbook by default, that is 51,539,607,552 cells
in the workbook.
...

Read More

###### Asked in Microsoft Excel

### What happens In Excel when you insert or delete cells from a spreadsheet?

Extra cells or rows or columns are inserted or removed, though
the total amount of each stays the same. As there are so many
columns/rows/cells, Excel can effectively push off blank cells at
the ends of the spreadsheet. Formulas can update themselves when
changes are made, so it is not necessary to change formulas.
...

Read More

###### Asked in Microsoft Excel

### Why do you need to delete and insert rows in Microsoft Excel?

There are many reasons, but generally they are as follows. Often
you will realise you need some extra values between ones you have
already put in, so you may want to insert rows or columns, which
saves you from having to move things or start over. You may want to
delete rows and columns that have values that you no longer need or
when you have blank rows and columns in your data.
...

Read More

###### Asked in Microsoft Excel

### What is the last cell in Excel 2013?

The last cell is XFD1048576. That is because there are 16384
columns and 1048576 rows in versions of Excel from 2007 onwards. So
that includes Excel 2013. Column XFD is the 16384th column.
...

Read More

###### Asked in Statistics, Microsoft Excel

### What is a chart sheet in excel?

A chart sheet just shows a chart by itself, so you don't see the
data and there are no rows and columns visible.
...

Read More

###### Asked in Hyundai Excel

### What is Excal?

Excel is a software program from Microsoft. Excel is a program
used by accountants and everyone else to collect and store data.
Data is organized into rows and columns so that it can be easily
compared.
...

Read More

###### Asked in Microsoft Excel

### How can you extend columns in Excel beyond column named IV?

If you only have a version of Excel up to 2003, then you can't.
Inserting new columns just pushes that last one off so you don't
actually gain any columns. Up to Excel 2003 you have 256 columns,
but from Excel 2007 you have 16,384 columns.
If you only have a version of Excel up to 2003, then you can't.
Inserting new columns just pushes that last one off so you don't
actually gain any columns. Up to Excel 2003 you...

Read More

###### Asked in Microsoft Excel

### Can you add rows to an existing table but not columns?

You can add columns or rows to any table. Adding a row does not
add extra columns, so yes you can do it.
...

Read More

###### Asked in Microsoft Excel

### How can I increase to more than 65536 rows in Excel 2007?

Excel 2007 has 1,048,576 rows, so it has more than 65,536 rows.
Excel 2003 had 65,536 rows and it was not possible to increase
that.
...

Read More

###### Asked in Microsoft Access

### How many cells in Microsoft Access?

Microsoft Access is a database application and it does not have
cells in the way a spreadsheet does. A datasheet in Access is not
the same as a worksheet in Excel and it does not have a fixed
amount of columns, rows and cells. So there is no answer to the
question.
...

Read More

###### Asked in Microsoft Excel

### How can be more rows inserted after 65536 rows?

If the version of Excel you are using only has 65536 rows, which
was the case up to Excel 2003, then you can't add any more rows.
From Excel 2007 onwards there are 1048576 rows, so that is what you
would need to use.
...

Read More

###### Asked in Microsoft Excel

### What direction are columns in Excel?

Columns are vertical, so they go up and down.

Read More

###### Asked in Microsoft Excel

### Does excel allows you to freeze titles in rows or columns so they remain on the screen no matter how far down or to the right you scroll?

Yes. Use the freeze screen options.

Read More

###### Asked in Microsoft Excel

### What is the transpositon feature in Excel?

Transposing changes the orientation of the cells. You can change
values in columns into rows or rows into columns. So if you have
values in cells A1, A2 and A3, you could transpose them so they are
in B1, C1 and D1. You can transpose by copying and then using the
Transpose option in the Paste Special options. You can also use the
Transpose function.
...

Read More

###### Asked in Software and Applications (non-game), Office Applications

### What grid uses columns and rows?

An example is the grid of a spreadsheet. A spreadsheet uses
vertical columns and horizontal rows. Columns are lettered A, B, C,
and so on. Rows are numbered 1, 2, 3, and so on. A1 is the address
of the first cell (top left-hand corner).
...

Read More

###### Asked in Biology, Inventions

### Do predictable charactersitics or properties usually fall into columns or rows?

The periodic table of elements lays out the elements in rows and
columns. Rows are arranged so that elements with predictable
characteristics or properties are in the same column.
...

Read More

###### Asked in Software and Applications (non-game), Computer Programming, Microsoft Excel

### How are rows and columns named in a spreadsheet?

Rows are number and columns are identified by letters. After
Column Z, the next one is AA, then AB, then AC and so on. After AZ
you have BA, BB, BC and so on.
...

Read More

###### Asked in Microsoft Excel

### How can you insert 20 rows at a time in Excel?

If you select more than one row and then insert, Excel inserts
the amount of rows selected. So the first thing to do is to select
20 rows. Then you can insert rows and it will put in 20 new rows
for you.
...

Read More

###### Asked in OpenOffice

### How many cells in open office calc?

Calc can store a maximum of
65,536 rows with 1,024
columns in each sheet
So 67,108,864 cells
From version 4, there are 1,048,576 rows and
1,024 columns, making
1,073,741,824 cells.
...

Read More

###### Asked in Microsoft Excel

### How do you delete all columns after Z from an Excel spreadsheet?

You cannot actually completely remove them so that the last
column is Z. You can delete the content of them, but if you try to
delete the columns themselves, they will still remain. Every
worksheet has a fixed amount of rows and columns, and you cannot
change that. You just use what you need.
...

Read More

###### Asked in Microsoft Excel

### Which is the last column in a spreadsheet?

In Excel 2003 and earlier, there are 256 columns, so the last
column is IV.
From Excel 2007 onwards, there are 16,384 columns, so the last
column is XFD.
...

Read More