I am regularly inputting words in French and their English translations
Column A contains my expanding list of French words
Column B contains their English translations (no more than two English words)

I do not enter either the French or English words alphabetically.

How can I display these columns alphabetically in French and in English?
That is, columns C and D would display the words alphabetically according to
the French word;
Columns E and F would do the display them alphabetically according to their
English word/s

Thank you

--
MZ

Select the appropriate pair of columns. Sort .../ sort by chosen column.
Repeat for the next pair of columns.
--
David Biddulph


MZ wrote:
I am regularly inputting words in French and their English
translations Column A contains my expanding list of French words
Column B contains their English translations (no more than two
English words)

I do not enter either the French or English words alphabetically.

How can I display these columns alphabetically in French and in
English? That is, columns C and D would display the words
alphabetically according to the French word;
Columns E and F would do the display them alphabetically according to
their English word/s

Thank you