max rows on an Excel worksheet
 

I thought the maximum number of rows available on an Excel
spreadsheet was 65,536. But recently I was told the
number of rows could be increased by decreasing the number
of columns. Is that true? If so, how is it done. Sorry
if this question has been asked before, I tried searching
the site for others who might have asked this question,
but the search feature is off.

vbJenny

Hi
Sorry, your informant is incorrect.
65,536 is all you get.
One option if you need more is to spread your data over a number of sheets
and create a summary sheet to bring totals an other information back together.

HTH
Michael

"vbjenny" wrote:

I thought the maximum number of rows available on an Excel
spreadsheet was 65,536. But recently I was told the
number of rows could be increased by decreasing the number
of columns. Is that true? If so, how is it done. Sorry
if this question has been asked before, I tried searching
the site for others who might have asked this question,
but the search feature is off.

vbJenny

"Michael" wrote in message
...

One option if you need more is to ...

use a database