more than 65,536 rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Is it possible to have more than 65,653 rows on a worksheet? The data I have does not fit on a normal sheet

Harald
 
Harald,

Unfortunately, the maximum number of rows on a worksheet is 65,536 rows and
cannot be increased.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)


Harald Bock said:
Hi,

Is it possible to have more than 65,653 rows on a worksheet? The data I
Click to expand...
have does not fit on a normal sheet.
 
No.

--
Michael Hopwood (Phobos)


Harald Bock said:
Hi,

Is it possible to have more than 65,653 rows on a worksheet? The data I
Click to expand...
have does not fit on a normal sheet.
 
Harald,

Sorry, you have reached one of Excel's limits. There
is no way to make Excel's worksheets longer.

Long lists like this are usually handled more efficeintly
by database programs such as Microsoft Access and
Microsoft SQL Server.

You can still use Excel to analyze large lists of data that
resides in a databse, by using Excel's PivotTable feature.

Ture Magnusson
Karlstad, Sweden

Harald Bock said:
Hi,

Is it possible to have more than 65,653 rows on a worksheet? The data I
Click to expand...
have does not fit on a normal sheet.
 
Back
Top