How to Turn on Spell Check in Excel (3 Ways)

In this article, we will learn how to Turn on Spell Check in Excel using the Review tab, shortcut key, and VBA code.

But, let’s first learn how to turn on AutoCorrect in Excel.

Steps:

  • Click on the File menu.

Turn on spell check in Excel menu bar

  • Go to Options.

  • Click on Proofing.

Turn on spell check in Excel proofing

  • A dialogue box will pop up.
  • Select AutoCorrect Options.

  • A new dialogue box will pop up. Choose the desired correcting options and click OK.

Turn on spell check in Excel methods


For illustration, we have a sample dataset with several spelling mistakes.

Note: To apply spell check on specific cells or range, you have to select the cells or range. If not, Excel will start spell-checking from the first cell in the workbook.

Method 1 – Turn on Spell Check in Excel from Review Tab

Steps:

  • Select the cells or range you want to spell-check.

Turn on spell check in Excel methods

  • Go to the Review Tab and click Spelling.

Turn on spell check in Excel review tab

A dialogue box will pop up.

Click on Change or Change All to correct all Sirt to Shirt. After checking one cell, it will move to the right in the same row to check spelling mistakes.

You can ignore the suggestions if the spelling is correct.

Click OK.
Turn on spell check in Excel review tab

Read More: How to Turn Off Spell Check in Excel


Method 2 – Turn on Spell Check Using Shortcut

The easiest way to turn on spell check in Excel is the Function key F7.

Steps:

  • On a Desktop computer, Select the desired range and press F7.
  • On Laptops or any other device with an Fn key, press Fn+F7.

Turn on spell check in Excel F7

Read More: How to Perform a Spelling Check on the Active Worksheet in Excel


Method 3 – VBA to Turn on Spell Check

Steps:

  • Right-click on the sheet, and go to View Code.

Turn on spell check in Excel vba

  • Copy and paste the VBA code below.

VBA code:

Sub TurnonSpellCheckInExcel()

Selection.CheckSpelling

End Sub

  • Press CTRL+S or the Save button to save the code.

  • Select the first cell of the workbook or select the data range and go to Developer > Macros.

Turn on spell check macros

  • Click on Run to run the code.

Spell checker will turn on for the selected cell.

Read More: [Fixed!] Spell Check Is Not Working in Excel


Download Practice Workbook


Related Article


<< Go Back to Spell Check in Excel | Proofing in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mahbubur Rahman
Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo