How many rows and columns are in one Excel sheet?

Depends on which version of Excel you are using.

If you are working on Excel 2003 - there are 65536 rows and 256 columns.

If you are working on Excel 2007 or any of the latest versions - there are 1048576 rows and 16384 columns. Last column in this case is XFD. And last row is 1048576. So last cell in an excel sheet will be XFD1048576.

see the screenshot of last row and column for clarity.


A2A.

Excel is spreadsheet application used to create, edit, and manipulate data. Each new workbook has 3 sheets by default (it is not the same in 2016 version. This version has only 1 sheet), and it is limited by available memory.

Each sheet has:

  1. 16,384 columns.
  2. 1,048,576 rows.

You can't have more than rows and columns as mentioned above. However, you can create no. of sheets. (limited by available memory).

16384th column is XFD.

You can see in below images.


1,048,576 rows and 16,384 columns
That's a composition of one Microsoft Excel sheet.

There is no maximum number limit for work-sheets in Excel. It's totally dependant on the memory (to say, CPU memory) available.

So, multiply the same with the number of work-sheet(s) you use and there you stand at the answer.

Being the first cell (A1) to the last cell (XFD1048576), that's the journey of one excel sheet for it's life.


Also, to add on -

  • You have a character limit in each cell and it is 32,767 characters.
  • Characters in a header or footer limits to 255.
  • Maximum number of line feeds per cell limits to 253.

That's a short demographics of MS-Excel.

Pinni™️

Originally answered: Govardhan Sai Pinni's answer to How many rows and columns are in one Excel sheet?

PS: Adding snapshots from MS-Excel


Versions of Excel up to 7.0 had a limitation in the size of their data sets of 16K (214 = 16384) rows.
Versions 8.0 through 11.0 could handle 64K (216 = 65536) rows and 256 columns (28 as label 'IV').
Version 12.0 can handle 1M (220 = 1048576) rows, and 16384 (214 as label 'XFD') columns.

Source: Google

Hey Jyoti,

I could easily give you the answer, but I would rather give you the art of fishing than the fish....

So, if you have any such questions about facts in your mind please do a google search. It is the fastest and the best way to learn.

Fyi - Version 12.0 or 2007+ can handle 1048576 rows, and 16384 (as label 'XFD') columns.


There are [math]2^{20} = 1,048,576[/math] rows, and [math]2^{14} = 16,384[/math] columns in an an Excel worksheet, at least since Excel 2007.

To find out how many rows, you can open an empty worksheet, and press CTRL-Down-Arrow key combination on your keyboard. The cursor will move all the way to the bottom row of the sheet. Look for the row number on the left.

To find out how many columns, you can press CTRL-Right-Arrow key combination in an empty worksheet, and you will find yourself at column XFD. So how many columns is that?

There are [math]26[/math] columns labeled A through Z, and then there are [math]26^2 = 676[/math] columns labeled AA through AZ. Then start the columns with 3-letter names. Treat AAA like 000 in base 26 arithmetic. Treat A as the 0 digit, and Z as the 25 digit in base 26 numerals. So X is the 23 digit, F is the 5 digit, and D is the 3 digit, and XFD is the base-26 for [math]23 \times 26^2 + 5 \times 26 + 3 \times 1 = 15, 681[/math]. So the three-letter column names run from 0 to 15,681, so there are 15,682 of them.

So altogether there are 26 + 676 + 15,682 = 16,384 columns.

Excel 2003 only had 65,536 (what power of 2 is that?) rows, and 256 columns.


Which tech company came first, IBM, Google, Microsoft, Amazon, or others?

IBM goes all the way back to 1911, as the Computing-Tabulating-Recording Company. (It was renamed

Will Apple survive without new innovation?

Not just innovation but also diversification !!Innovation is definitely needed to stay on the top else they will not sustain for long .Innovation is not a choice but must do for survival .Currently majority ( three fourth ) of the revenues /earnings are contributed just by 2 products iphone and ipad .Tomorrow if any new products

Where could Ethereum go? Any real potential?

Here are some factors that make Ethereum an excting prospect:Ethereum is already being tested by 40 banks via Microsoft and have produced a return of more than 10,000% for investors since launching in 30 July 2015 and the party hasn't even started yetIt is