Arrow left
Back to product guides
Google Sheets Tips

How to Spell-check in Google Sheets

In this article, you will learn how to use the spell-checking function in Google Sheets

How to turn on spell-check in Google Sheets

  1. Select a range you want to spell-check.
  2. Press “F7” (If you are a Mac user, press “Fn” + “F7”) as a shortcut key* or go to “Tools” ➝ ”Spelling” ➝ ”Spell check”.
  3. Choose the action you need to take for identified spelling errors out of “Change”, “Ignore”, and “Add to dictionary” in a pop-up window.
  4. Once the check is done, you can close the pop-up window or keep checking in “Rest of the sheet” or “All sheets”.

*You need to turn on “Enable compatible spreadsheet shortcuts” in Google Sheets. Check this page to learn how to turn on the  function.

How to run the spell-checking function from the menu bar

Why is Google Sheets not spell-checking?

Google Sheets doesn’t automatically spell-check. You need to run spell-checking by yourself. Check the guidance above for the easy procedures. Also, make sure that you select the appropriate range to spell-check.

What are the other tips or formulas on text in Google Sheets?

Check the following articles if you are interested in formatting text in cells.
How to Make Text Bold, Italic, and Strikethrough in Google Sheets
How to Align Text in Google Sheets
How to Wrap Text in Cell in Google Sheets
How to Rotate Text in Google Sheets
How to Change Default Font in Google Sheets
How to Indent Texts in Google Sheets: Explained
How to Capitalize the First Letter in Google Sheets
How to Capitalize All Letters in Google Sheets
How to Make All Letters Lowercase in Google Sheets
TEXT Function in Google Sheets: Explained

Do you want to learn how to combine or split text in Google Sheets?
How to Combine Texts in Google Sheets
CONCAT Function in Google Sheets: Explained
How to Use the CONCATENATE function in Google Sheets
How to Split Texts into Columns in Google Sheets
How to Use SPLIT Function in Google Sheets
CHAR Function in Google Sheets: Explained

Do you want to know where a specify character or word is in a text string?
LEFT Function in Google Sheets: Explained
How to Use RIGHT Function in Google Sheets
SEARCH Function in Google Sheets: Explained
FIND Function in Google Sheets: Explained

Do you need to replace a part of text with another characters or words?
How to Use REPLACE Function in Google Sheets
SUBSTITUTE Function in Google Sheets: Explained

Do you like to show a formulae in a cell?
How to Use FORMULATEXT Function in Google Sheets

This function is useful when you need to count the number of characters in a text string.
LEN Function in Google Sheets: Explained

Why don’t you double-check the spelling of your texts or cleaning up extra spaces before printing or closing Google Sheets?
How to Trim Whitespaces in Google Sheets

You can repeat the same text string with this formula.
REPT Function in Google Sheets: Explained

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Do you want to tell a story about your performance using your reports rather than just showing numbers? 

You can learn how to do it here and remember to spell-check those narratives:

 


Analyze your live financial data in a snap

Are you learning this tip to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711