View Single Post
  #10   Report Post  
Nick Hodge
 
Posts: n/a
Default

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 EditFillSeries...The number
in IV1 should have incremented to 256... your answer!
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Rita" wrote in message
...
Well that answered my ? about the rows, thank you. But I noticed that I
cannot do that to find out the number of columns....

"Nick Hodge" wrote:

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
HIS

"Rita" wrote in message
...
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

"Fredrik Wahlgren" wrote:


"Rita" wrote in message
...
How many rows and columns are in one spreadsheet of excel?

There are 256 columns and 65526 rows.

/Fredrik