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

G

Guest

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
 
G

Guest

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

How can I add additional rows beyond the 65,536 in excel 2003 6
Button on Form to Add more rows 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
how to insert rows inbetween rows of data ? 1
How can I open big file? 2
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS 3
Function in Excel to count and list number of entries of text valuesin a row. 2

Top