On the main sheet, I typed the numbers 1 to 5 in cells A4:A8 When English is selected, the result is 1, and 2 for French. Here is the formula, in cell I2, which is named LangSelID: Next, I named that cell – LangSel, and selected English as the language.īack on the translation sheet, I added a formula to calculate the ID of the selected language. On the main worksheet, I created a data validation drop down list, based on the LangList range. I selected cells G2:G3, with the language names, and named that range LangList. On the same sheet, I created a table with languages, and an ID number for each language. I entered a few English and French phrases from the cereal box, and typed numbers for each row in column 1. In the sample Excel file, I set up a table with 3 columns – ID, English and French. Actually, this is how many of us learned some French – reading the back of the cereal box at the breakfast table! Set up the Translation Table The data in my client’s file is confidential, so I’ll show you how this works using some text from a Honey Nut Cheerios box. The steps below show how to set things up, so you can switch languages in Excel. Our two official languages in Canada are English and French, and I’m currently working on an Excel project in which you can choose either language.

How to change language in excel