Word List Spreadsheet

Merovee.b -  
Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   -
Hello everyone,
I use Excel to record lists of words. The number of columns I've chosen is 10, but that number doesn't matter.
The length of my list of words is variable, as I add words from time to time. Therefore, the number of rows increases.
But I don't use the notion of rows and columns: my spreadsheet is just a series of words.

My request:
When I add a word to my list, at the end of my list, I would like to be able to rearrange that word in alphabetical order, without having to do it manually (by shifting all the following words one by one, which is really tedious).

Can anyone help me?

Thanks a lot in advance.

2 answers

  1. telliak Posted messages 3652 Registration date   Status Member Last intervention   885
     
    Hi,
    >Data >Sort, right?
    1
  2. Raymond PENTIER Posted messages 58210 Registration date   Status Contributor Last intervention   17 480
     
    Hello.

    Your words are all in the first column, and the other columns are just comments?
    Because if your words are scattered across several rows and several columns, it is impossible to sort them.

    --
    Retirement is nice! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0