G
Guest
How many rows and columns are in one spreadsheet of excel?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fredrik Wahlgren
Rita said:How many rows and columns are in one spreadsheet of excel?
There are 256 columns and 65526 rows.
/Fredrik
G
Guest
256 columns
65536 rows
65536 rows
F
Fredrik Wahlgren
G
Guest
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
65,526...so what is it? I really need to know for class, this is extremely
important...thank you
G
Guest
Are we talking Excel 2003 Professional
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
(e-mail address removed)
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
(e-mail address removed)
F
Fredrik Wahlgren
Fredrik Wahlgren said:Right. I made a typo.
/Fredrik
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
G
Guest
Well that answered my ? about the rows, thank you. But I noticed that I
cannot do that to find out the number of columns....
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
(e-mail address removed)
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
(e-mail address removed)
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....
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
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:
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
How many rows and columns are in one spreadsheet of excel?
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:
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
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
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
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.