more than 65,536 rows

H

Harald Bock

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
 
C

Chip Pearson

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 [email protected]


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.
 
M

Michael Hopwood

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.
 
T

Ture Magnusson

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.
 
Top