What Is Spell Check In Google Sheets?
Spell Check in Google sheets, as the name suggests helps users correct the spelling errors or mistakes in the spreadsheet. Apart from spell check in Google sheets, we can also enable Autocorrect to correct our mistakes immediately or automatically in Google sheets.
For example, consider the below table showing a text string Apple.
We can see that the spelling of Apple is mistakenly typed as Appple.
Now, let us learn how to spell check. First, insert the data we want to check the spelling. In this example, the text string is inserted in A1. Select the cell A1. Next, click on Tools and click on Spelling. Then, select the arrow and click on Spell Check. The Change Apple to: window appears on the right end side of the screen.
Select the accurate options showing in the window. In this example, select Apple and click on Change. We can see that the spelling is corrected in the text string immediately, as shown in the below image.
Likewise, we can use spell check in Google sheets. In this article, let us learn about spell check with detailed examples.
Table of Contents
Key Takeaways
- Spell check in Google sheets helps users to check the spelling in the given data.
- It is available by default in Google sheets. To use spell check, simply insert the data and click on Tools > Spelling > Spell Check.
- Remember that Autocorrect option is not available in Google sheets but is available in Excel and Google documents.
- This feature helps us identify and correct the incorrect spellings in Google sheets.
- If the suggestion suggested in the Spell check window is incorrect, we can type the desired spelling and then click on Change in Google Sheets.
How Spell Check In Google Sheets Works?
Step 1: First, insert the data we want to check the spelling. Select the cell or the cell range.
Step 2: Next, click on Tools and click on Spelling.
Step 3: Then, select the arrow. Click on Spell Check.
Step 4: The Change Apple to: window appears on the right end side of the screen.
Select the accurate options showing in the window.
We can see the result immediately.
For example, consider the below table showing various subjects in column A.
Now, let us learn how to spell check in Google sheets.
The steps are:
Step 1: First, insert the data we want to check the spelling. In this example, the text string is inserted in the cell range A1:A4. Select the cell range.
Step 2: Next, click on Tools and click on Spelling.
Step 3: Then, select the arrow. Click on Spell Check.
Step 4: The Change Physics to: window appears on the right end side of the screen.
Select the accurate options showing in the window.
In this example, select Physics and click on Change.
We can see the result immediately, as shown in the below image.
Likewise, we can use spell check in Google sheets.
How To Perform Spell Check In Google Sheets?
For example, consider the below table showing various movies in column A.
Now, let us learn how to spell check in Google sheets.
The steps are:
Step 1: First, insert the data we want to check the spelling. In this example, the text string is inserted in the cell range A1:A4. Select the cell range.
Step 2: Next, click on Tools. Click on Spelling.
Step 3: Then, select the arrow. Click on Spell Check.
Step 4: The Change Batman to: window appears on the right end side of the screen.
Select the accurate options showing in the window.
In this example, select Batman and click on Change.
We can see the result immediately, as shown in the below image.
Likewise, we can use spell check.
The Spell Check Window In Google Sheets
Spell check window is the place where we see and change the incorrect spellings in Google sheets.
For example, consider the below table showing various subjects in column A.
Now, let us learn how to spell check in Google sheets.
The steps are:
Step 1: First, insert the data we want to check the spelling. In this example, the text string is inserted in the cell range A1:A7. Select the cell range.
Step 2: Next, click on Tools. Click on Spelling.
Step 3: Then, select the arrow and click on Spell Check.
Step 4: The Change Iiphone to: window appears on the right end side of the screen.
We can see the suggestion showing is IPhone only. In the suggestion is right, we can directly choose the suggestion and click on Change. But here, we need to enter the text iPhone in the dialog box.
Now, click on Change.
We can see the result immediately, as shown in the below image.
Likewise, we can use spell check.
Features Of The Spell Check In Google Sheets
- Find the mistakes in the given data.
- In case of using huge datasets, we don’t have to correct the spellings manually.
- We can easily change the mistakes using Spell check.
- Remember, we can find and change all the spelling errors in one go.
Important Things To Note
- Spell check in Google sheets checks the spelling in the given data.
- To use spell check, we need to click on Tools > Spelling > Spell Check.
- There is no AutoCorrect option in Google sheets. To enable Autocorrect, we can use it is Google sheets.
Frequently Asked Questions
For example, consider the below table showing a text string Orange.
We can see that the spelling of Orange is mistakenly typed as Orannge.
Now, let us learn following the below steps.
1: First, insert the data we want to check the spelling. In this example, the text string is inserted in A1. Select the cell A1.
2: Next, click on Tools and click on Spelling.
3: Then, select the arrow and click on Spell Check.
4: The Change Orange to: window appears on the right end side of the screen.
Select the accurate options showing in the window.
In this example, select Orange and click on Change.
We can see the result immediately, as shown in the below image.
Likewise, we can check our spelling.
The difference between spell check and autocorrect is that, spell check is done manually in Google sheets and Excel. Whereas, we can enable Autocorrect which helps users to correct content as and when the content is inserted in the sheet.
Spell check in Google sheets can be done by clicking on Tools > Spelling > Spell Check. But unfortunately, AutoCorrect is unavailable in Google sheets. However, it AutoCorrect option is available in Google documents that enables users to correct the spelling automatically.
Recommended Articles
Guide to What is Spell Check In Google Sheets. Here we discuss how spell check In Google Sheets works with its features and examples. You can learn more from the following articles. –
Leave a Reply