When it comes to Office applications, the spelling check-up is one of the best options you would find for proofreading Excel workbooks. Office 365 is one of the best selections and is undoubtedly an excellent option that provides you access to a cloud-based subscription model at the forefront. How should you go with the Excel spell check in worksheets for Office 365? We will explain the details here.
The Spell Check Feature on Office 365 – An Overview
The Office 365 suite of Office applications provide you access for checking your grammar on practically any document that you are using. You would be able to monitor almost every document, every email, every spreadsheet, and every presentation you would create with the Office 365 suite.
However, there are cases where even after you make full use of the proofreading functionalities on your office 365 suite, you may still find a few issues are affecting your useful spell check and other proofreading capabilities.
How to Turn on Office 365 Excel Spell Check in Worksheets?
Well, there is no specific Spell Check functionality on Excel in Office 365 or otherwise. However, there are a few proofing tools and settings that should help you work through efficient functionality.
Here is how you would be able to enable and configure the settings for better proofing on your Excel program on Office 365 suite –
- Launch Microsoft Office from your Office 365 suite.
- Create a blank Workbook, or you can even launch an existing workbook.
- Click on File and then look for Options
- From the Options screen, locate the section Proofing on the left side pane.
Under the Autocorrect Options tab, click on the option Autocorrect Options.
This should take you to the Autocorrect features on Excel. The steps and options available here should assist you in providing excellent functionality in working through the best spell checking and proofing features on your Office Suite.
The Dialog box should provide you access to all the auto formatting features on Excel. The steps here should be applicable to Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007, along with other editions. There may be a few variations or slighter changes.
You should find four tabs on the dialog box, each of them having their functions.
The Autocorrect feature should be extremely helpful in letting you correct the issues affecting your Excel worksheets. You can make use of the options like fixing the typos, capitalization problems, and wrong spellings.
You can also use the option for inserting the symbols and adding up other text. The Autocorrect option is one of the perfect options, and you can use it to correct the most common misspellings, symbols, and other errors. While most of the entries work best, you can even modify a few options as per your preferences.
Excel automatically configures most of the spelling errors. You can change a few settings as per your preferences. You can even choose to disable the option that displays the AutoCorrect Options. The settings here should be quite self-explanatory.
While you can configure the options for the following configurations, you may specify exceptions for them as well –
- Correct two initial capitals
- Capitalize the first letter of sentences
- Capitalize names of days
- Correcting accidental use of CAPS LOCK key
Another option that dialog box offers you would be to choose to correct the errors as you type or decide to make corrections later on completing the sheet.
Autoformat As You Type
This would refer to some of the automatic formattings that Excel would resort to when it finds that you have been using a particular format of writing. For instance, it will begin adding bullets or numbered list when it detects that you are creating a list.
You can turn on or turn off any of the formatting options if you do not like the settings that Excel applies automatically. It is as easy as clearing the checkbox for the choices you do not want.
This is the third tab you will find in the Autocorrect options on Excel in Office 365 suite. The option will help you add more actions concerning your Excel worksheets. You can turn on the choice by ticking the box for Enable additional actions in the right-click menu from within the dialog box.
One of the predefined options is the Date functionality that will help you reach your Outlook calendar for that date. There is nothing much the dialog box would help achieve the spell check features on your Excel program within Office 365.
The option lets you create a new formula right from scratch. There are a host of predefined math auto corrections. You can even turn off the functionality. Just uncheck the box for Replace text as you type.
You can add any new formula you would want to add to the dialog box. You may even remove any of the equations that Excel has already added to the list.
Any other options for enabling Spell Check on Excel on Office 365?
Well, the spell check feature on Excel is entirely different from what you would find on Word. The spell check feature is one of the essential aspects in any word processor, and Word lives up to it.
Many of the users have been asking this query. If you have been using Office 365 or even the standalone Office applications, you will find that the spell check functionality works entirely in a different manner than that does in Word. Word offers you an option to apply an autocorrect feature. This feature will help correct the words that are automatically spelled wrong. The feature in question here is the correct as you type or replace as you type feature provides by Word.
Excel does not come with this feature. Unless you have specified the autocorrect exceptions in the Autocorrect options, you will not find the effective autocorrect or spell check functionality on your Excel in Office 365 app. This is the fundamental difference between the spell check features on Word, PowerPoint, and Excel. While Word and PowerPoint do it by default, Excel expects you to add the AutoCorrect options specific to your requirements.
Here is how you can add your specific words to the auto dictionary or custom dictionary –
- Launch your Excel program on Office 365.
- Open a blank workbook or an existing workbook.
- On the ribbon, locate and open Review tab
- Click on
- The spelling feature will check your entire worksheet and come up with the spelling suggestions.
- If you do not agree with any of the spelling suggestions, click on Add to Dictionary when you come across the particular advice.
- Repeat the same procedure for all your spelling suggestions that you would consider false positive.
You can even click on the option Autocorrect available on the dialog box. This will bring up the autocorrect options that we have discussed in the previous sections.
That was all we have concerning how you will be able to turn on the spell check feature on your Excel program on Office 365 suite. Please note that the functionality will be similar to your offline Excel program on Office 2019, Office 2016, Office 2010, or even Office 2007.
The lack of default spell check feature as in the case of Word or PowerPoint may be seen as a deterrent for most of us. However, that is precisely what Excel has been built for and built as is. However, the options offered through the above tutorial should help you arrive at the right choices to access the perfect possibilities for applying the right kind of corrections.