How to Use English Dictionary in Excel (3 Handy Applications)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to use an English dictionary in Excel? Then, this is the right place for you. You can use an English dictionary to check spelling, find meaning or synonyms and different forms of a word in Excel. To do that, you can follow different ways. Here, you will find 3 ways to use an English dictionary in Excel.


Download Practice Workbook

You can download the workbook to practice yourself.


3 Handy Applications of English Dictionary in Excel

Here, we have a dataset containing the Subject name and Marks of a student. Now, using this dataset we will show you how to use an English dictionary in Excel.

English dictionary in Excel


1. Use Spelling Feature to Check Spelling in Excel

In the first method, we will show you how you can check spelling of words in your dataset using the Spelling feature in Excel.

Here are the steps.

Steps:

  • Firstly, select cell range B5:B8.
  • Secondly, go to the Review tab >> click on Spelling.

Use Spelling Feature to Check Spelling in Excel

  • Then, a Spelling box will open.
  • After that, you will see some suggestions for Cell B7. Here, we will select Chemistry.
  • Next, click on the Change button.

  • Then, you will see that the spelling has been changed.
  • Afterward, you will see some suggestions for Cell B8. Here, we will select Biology.
  • Again, click on the Change button.

  • Finally, a message box like the image shown below will open.
  • Thus, you can check spelling in Excel.

Read More: How to Create Data Dictionary in Excel (with Easy Steps)


2. Press ALT Key to Find Meaning Using English Dictionary in Excel

You can use the ALT key to use an English dictionary and find the meaning of a word in Excel. To do that, follow the steps given below.

Steps:

  • In the beginning, select the cell which contains the word you want to translate. Here, we will select Cell B5.
  • Then, press the ALT key and again click on that cell.

Press ALT Key to Find Meaning Using English Dictionary in Excel

  • Thus, a Research toolbox will open where you can find the meaning of that word.

English dictionary in Excel

Read More: How to Use VBA Dictionary in Excel (6 Practical Examples)


3. Apply Thesaurus Feature to Find Meaning and Different Forms Using English Dictionary

In the final method, we will show you how you can find the meaning or synonyms of a word in Excel by applying the Thesaurus feature. Using this feature, you will also be able to find different forms of a word. Suppose your given word is a verb, it will show you other forms such as noun or adjective form of that word (if it has any).

Here are the necessary steps.

Steps:

  • Firstly, select the cell which contains the word you want to find the meaning or synonyms of. Here, we will select Cell B5.
  • After that, go to the Review tab >> click on Thesaurus.

Apply Thesaurus Feature to Find Meaning and Different Forms Using English Dictionary

  • Now, the Thesaurus toolbox will open which will provide you with the meaning or synonyms and other forms of that word.
  • That’s it. Thus, you can use an English dictionary in Excel.


Practice Section

In the article, you will find an Excel workbook like the image given below to practice on your own.

Practice Section


Conclusion

So, in this article, we have shown you 3 ways to use an English dictionary in Excel. I hope you found this article interesting and helpful. If something seems difficult to understand, please leave a comment. Additionally, please let us know if there are any more alternatives that we may have missed. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin Islam

Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo