I NEED TO KNOW ASAP

R

Rita

Okay I got two different answers for rows. One said 65,536 and the other
65,526...so what is it? I really need to know for class, this is extremely
important...thank you
 
N

Nick Hodge

Rita

It is 65536 rows by 256 columns, but why not go to an empty sheet and press
Ctrl+arrow down for yourself... there's your answer!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
F

Fredrik Wahlgren

Fredrik Wahlgren said:
Right. I made a typo.

/Fredrik
Click to expand...

Excel 95 had 16384 rows. Excel 97 increased this number to 65535. It hasn't
changed. I have Excel 2003 and checked to be sure.

7Fredrik
 
R

Rita

Well that answered my ? about the rows, thank you. But I noticed that I
cannot do that to find out the number of columns....
 
N

Nick Hodge

Rita

Enter a 1 in A1, now reselect A1 and hold down the shift key and click on
IV1 the last column. Now take the menu options Edit>Fill>Series...The number
in IV1 should have incremented to 256... your answer!
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
F

Fredrik Wahlgren

Rita said:
Well that answered my ? about the rows, thank you. But I noticed that I
cannot do that to find out the number of columns....
Click to expand...

Rita,
there are only 256 columns. If you want to verify, just press the right
arrow key until you don't get any further. Then enter =COLUMN()

/Fredrik
 
G

Gord Dibben

Rita

Help>Answer Wizard>Specifications (or limits)will give you all the specs for
Excel including rows and columns.


Gord Dibben Excel MVP
 
A

Amedee Van Gasse

Rita shared this with us in microsoft.public.excel.misc:
How many rows and columns are in one spreadsheet of excel?
Click to expand...

Why do you ask this two times? You got an answer the first time.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
A

Amedee Van Gasse

Rita shared this with us in microsoft.public.excel.misc:
Okay I got two different answers for rows. One said 65,536 and the
other 65,526...so what is it? I really need to know for class, this
is extremely important...thank you
Click to expand...

Normally we won't do your homework. Read this:
http://j-walk.com/ss/excel/odd/odd13.htm

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
Top