ExcelBanter - In Excell sheet i want to insert more than 65,536 rows how i can .

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - In Excell sheet i want to insert more than 65,536 rows how i can . (https://www.excelbanter.com/excel-worksheet-functions/20743-excell-sheet-i-want-insert-more-than-65-536-rows-how-i-can.html)

Girish.G

In Excell sheet i want to insert more than 65,536 rows how i can .

I have database in excell it allready reach 65 536 rows i want to add more
rows pls let me know how i can add more rows ?

º¼ÖÝÈË

no way

Fredrik Wahlgren

"Girish.G" wrote in message
...
I have database in excell it allready reach 65 536 rows i want to add more
rows pls let me know how i can add more rows ?

You have to use next worksheet when you have reached this number.

/Fredrik

Duke Carey

If you have that many rows of data, you need to seriously consider putting
that data in a DATABASE such as Access or MSDE (which is free). You can then
use the Get External Data option to bring subsets of your data into Excel.

"Girish.G" wrote:

I have database in excell it allready reach 65 536 rows i want to add more
rows pls let me know how i can add more rows ?

All times are GMT +1. The time now is 10:12 AM.