how can i spreed the range of excel sheet form 65000 of row

G

Guest

how can i spreed the range of excel sheet form 65000 of row to for example
123 000 rows
 
P

Pete_UK

You cannot exceed the limit of rows of 65536. However, you could split
your data into two or more sheets, each with 65536 row capability.
Alternatively, you could use Access, or if you must have a spreadsheet
now then Quattro Pro (part of Word Perfect Office - see the Corel
website) can handle sheets up to 1 million rows.

Hope this helps.

Pete
 

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

Formula for adding figure from many spreed sheet to one 1
How to open a large excel file? 1
How do I draw chemical structures in Excel spreed sheet? 1
Access How can i delete record from 7000 to 65000 in MS Access Table? 0
How can I read over than 65,536 rows from excel spreed sheet 2
Combine multiple worksheets in one Workbook into one big worksheet 6
Word Wrap? 2
2007 Data Export Limit 2

Top