Extend the Column Numbers

X

XP User

I have a one column which have more than 77000 records !
how can I fit it in one column , becuase I need to sort it
is there any way to extend the number of excel columns
beyond 65K
Thanks
 
B

Bill Sharpe

I believe you want more rows, not columns.

Possible solutions:
Switch to Quattro Pro 11, which can handle a million rows.
Switch to a database program.
Use a second sheet in Excel. You'll have to work out the sorting details
yourself. If you're sorting alphabetically, put A-L on the first sheet, M-Z
on the second.

Bill
 

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

Autonumber field in Excel that behaves the same as Access 0
Excel does not accept text format! 0
Document extends beyond horizontal ruler! 1
MS Project Center-Autolink column fields 0
Excel --> Word 4
How can the font and size of (all) citation numbers be altered? 1
Cannot sort a table containing text 5
Calculate the median value before a specified list 0

Top