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

M

mateuszgli

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

Excel Invoice help 6
Working outlook via vba code with xlsx - error 0
Excel --> Word 4
Need Help with a VBA subroutine 0
Range headings 0
How to open a large excel file? 1
Dumb question alert! What program to use? 0
How do I draw chemical structures in Excel spreed sheet? 1

Top