Question about number of possible cells in Excel.

S

sheana

The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536
rows. It also says Excel has 16.5 million cells. Is that correct, and if so,
how is that calculated?

Another thing...it says columns are labeled A through Z, AA through AZ, and
so on, up to IV. I typed "IV" into the name box, and couldn't visualize the
cell reference. Am I reading it correctly as the letter "I" and the letter
"V"? Thanks in advance.
 
D

Dave Peterson

Try this in an empty worksheet.

Edit|Goto (or F5 or ctrl-g)
type:
IV65536

That's the last cell on the worksheet in xl97-xl2003. xl2007 adds more columns
and more rows. xl95 had fewer rows.

Put this formula in that cell.
=row()*column()
and you'll see it evaluate to: 16,777,216

The 255 worksheets isn't correct. The number of worksheets that you can have in
a workbook is limited by your computer's memory.

And if you would have typed:
IV1
or
IV2
or
iv:iv
into the name box, your attempt would have worked ok.

You have to type something that looks like an address.
 
S

Stan Brown

Sun, 3 Feb 2008 07:09:00 -0800 from sheana
The book I'm reading says Excel has 255 worksheets, 256 columns and 65,536
rows. It also says Excel has 16.5 million cells. Is that correct, and if so,
how is that calculated?

If you had a chart with three rows and five columns, how would you
figure the number of cells in the chart?

(By the way, the limits you cite have been greatly expanded in Excel
2007.)
Another thing...it says columns are labeled A through Z, AA through AZ, and
so on, up to IV. I typed "IV" into the name box, and couldn't visualize the
cell reference. Am I reading it correctly as the letter "I" and the letter
"V"? Thanks in advance.

Yes, letter I and letter V. But you don't navigate a Excel worksheet
by typing things in the Name box. When you did that, you just
created a name "IV" to refer to the current cell. Scroll, or use F5
or Edit | Goto. In the goto box you specify a valid row and column,
such as IV1 or IV65536.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top