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

G

Girish.G

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 ?
 
F

Fredrik Wahlgren

Girish.G said:
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 ?
Click to expand...

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

/Fredrik
 
D

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