Add more than 65536 rows?

[Roby36]

Hello, I need to add more than 65536 in a excel worksheet, Do you know
it it is possible?

Many Thanks
Ricy

 

[Duke Carey]

No, no possible. You'll have to use a second sheet, and a third if necessary.

Alternatively, use Microsoft Access.

 

[Roby36]

Thank you for your answer, I read that it is possible to use pivot
table, to select only the row you need, is it true? And How Can I do?

Bye

 

[Gord Dibben]

Roby

For instructions on Pivot Tables see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

Scroll down to the "P" section.


Gord Dibben Excel MVP