ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add more than 65536 rows? (https://www.excelbanter.com/excel-worksheet-functions/42849-add-more-than-65536-rows.html)

Roby36

Add more than 65536 rows?
 
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" wrote:

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

Many Thanks
Ricy



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

On 29 Aug 2005 14:35:23 -0700, "Roby36" wrote:

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




All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com