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

  • Thread starter Thread starter Guest
  • Start date Start date
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 ?
 
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
 
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.
 
You must log in or register to reply here.

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 Help to copy information from one row at a time to another sheet 1
how to insert rows inbetween rows of data ? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
How can I open big file? 2

Back
Top