max rows on an Excel worksheet

  • Thread starter Thread starter vbjenny
  • Start date Start date
V

vbjenny

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
 

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

Similar Threads

What is the Excel 2007 rows limit for Excel 2003 macros? 0
increase total rows 2
Excel 2007 with no increase in rows and columns 2
Number of rows in Excel 2007 worksheets 3
Row Limitation 4
Increase rows in worksheet beyond 65,536 row limit 2
how to increase the max number of rows in Excel spreadshee above 6 2
Adding more than 65,536 rows in Excel 2007 5

Back
Top