W
Wendus
I have to make a list of names and associated information. The names (i
'surname, initial' order) are being entered in column A, with the othe
information across the row, in columnss B to G. Every so often,
click on cell A1 and get the list sorted alphabetically. All ver
easy!
However, I've just realised that I'll be entering in the region o
3,500 names! My question is, simply, can I make a list that long? It'
something I've never done in Excel before, and I don't know if there'
a limit to the number of names I can put in one column on Sheet 1.
Don't think I can split the work between 3 sheets, as the whole lis
will need to be put into alphabetical order, so it'd need to be on
great long list.
Many thanks
'surname, initial' order) are being entered in column A, with the othe
information across the row, in columnss B to G. Every so often,
click on cell A1 and get the list sorted alphabetically. All ver
easy!
However, I've just realised that I'll be entering in the region o
3,500 names! My question is, simply, can I make a list that long? It'
something I've never done in Excel before, and I don't know if there'
a limit to the number of names I can put in one column on Sheet 1.
Don't think I can split the work between 3 sheets, as the whole lis
will need to be put into alphabetical order, so it'd need to be on
great long list.
Many thanks