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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel --> Word 4
Need Help with a VBA subroutine 0
How can I print rows that go outside of the page without shrinking the text? 0
Many sheets, one DB? 1
How can the font and size of (all) citation numbers be altered? 1
Function in Excel to count and list number of entries of text valuesin a row. 2
How To Lookup a full row if it contain a text in a spec coloumn from diffrent sheet? 1
Button on Form to Add more rows 1

Top