{"id":631,"date":"2022-12-05T16:25:46","date_gmt":"2022-12-05T10:55:46","guid":{"rendered":"https:\/\/sheetstips.com\/?p=631"},"modified":"2022-12-06T17:29:18","modified_gmt":"2022-12-06T11:59:18","slug":"spell-check-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/spell-check-google-sheets\/","title":{"rendered":"How to Use Spell Check in Google Sheets to Find Misspelled Words (Keyboard Shortcut Included)"},"content":{"rendered":"<p><strong>Google Sheet Spell Check:<\/strong> With the new Spell Check function in Google Sheets, you can say goodbye to spelling mistakes. Yes, you heard it correctly. When we are working with a huge dataset, we might tend to enter wrong spellings. However, with the help of the Google Sheets Spelling feature, we will be able to find the list of spellings that are entered incorrectly and correct them. So, let&#8217;s understand how to do the spell check and correct them with the help of <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheet tips<\/a><\/strong> provided on this page. Read on to find more.<\/p>\n<p>Read Also: <a href=\"https:\/\/btechgeeks.com\/java-program-to-check-if-a-given-number-is-fibonacci-number-or-not\/\" target=\"_blank\" rel=\"noopener\">Java Program to Check if a Given Number is Fibonacci Number or Not<\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#How-to-Spell-Check-in-Google-Sheets?\">How to Spell Check in Google Sheets?<\/a><\/li>\n<li><a href=\"#Understanding-Spell-Check-Options-in-Google-Sheets\">Understanding Spell Check Options in Google Sheets<\/a><\/li>\n<li><a href=\"#Spell-Check-using-Keyboard-Shortcuts-in-Google-Sheets\">Spell Check using Keyboard Shortcuts in Google Sheets<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"How-to-Spell-Check-in-Google-Sheets?\">How to Spell Check in Google Sheets?<\/h2>\n<p>Follow the steps as listed below to use the Spell check in Google Sheets:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open the Google Spreadsheet where you would like to perform the Spell Check operation.<\/li>\n<li><strong>Step 2:<\/strong> Now move to the Toolbar and click on the &#8220;<strong>Tools<\/strong>&#8220;.<\/li>\n<li><strong>Step 3:<\/strong> From the drop-down, select &#8220;<strong>Spelling<\/strong>&#8220;.<\/li>\n<li><strong>Step 4:<\/strong> Now from the Spelling drop-down menu, select &#8220;<strong>Spell Check<\/strong>&#8220;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-634\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets1.png\" alt=\"spell check in google sheets\" width=\"980\" height=\"552\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets1.png 980w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets1-300x169.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets1-768x433.png 768w\" sizes=\"(max-width: 980px) 100vw, 980px\" \/><\/p>\n<ul>\n<li><strong>Step 5:<\/strong> Spell check is now active in your Google Sheets, and you can see it as a separate dialogue box in the upper right corner.<\/li>\n<li><strong>Step 6:<\/strong> Now you will have 3 options, where you can either accept, change or add the spellings of misspelled words to the dictionary. With the help of these options, you can change the spellings.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-633 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets2.png\" alt=\"spell check in google sheets\" width=\"1263\" height=\"202\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets2.png 1263w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets2-300x48.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets2-1024x164.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets2-768x123.png 768w\" sizes=\"(max-width: 1263px) 100vw, 1263px\" \/><\/p>\n<h3 id=\"Understanding-Spell-Check-Options-in-Google-Sheets\">Understanding Spell Check Options in Google Sheets<\/h3>\n<p>The following choices are available in the Spell Check dialogue box in the Google Sheets:<\/p>\n<ul>\n<li><strong>Change:<\/strong> The highlighted misspelled words should be changed. If this term appears more than once, you can check all instances and correct them by clicking the Change All button.<\/li>\n<li><strong>Ignore:<\/strong> Don&#8217;t pay any attention to the adjustment that has been suggested. In the event that a name or item is indicated as misspelled, you have the option of ignoring that item or name. It&#8217;s possible to select to ignore all instances if there is more than one. Just click on Ignore All.<\/li>\n<li><strong>Add to Dictionary:<\/strong> To prevent future misspellings of a word, click on the &#8220;<strong>Add to Dictionary<\/strong>&#8221; button. It will add the text to the dictionary.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-632 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets3.png\" alt=\"spell check in google sheets\" width=\"408\" height=\"192\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets3.png 408w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/spell-check-in-google-sheets3-300x141.png 300w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/p>\n<p>As long as it identifies misspelled words, the spell check continues to run. The cross at the top-right corner can be used to close it.<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/drop-down-list-in-google-sheets\/\">How to Create a Drop Down List in Google Sheets: Add\/Remove\/Customize Drop Down Menu<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/google-sheets-timestamp\/\">How to Insert Timestamp in Google Sheets: 3 Easy Methods<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/convert-pdf-to-google-sheets\/\">How to Convert PDF to Google Sheets: Free Online Conversion<\/a><\/li>\n<\/ul>\n<h3 id=\"Spell-Check-using-Keyboard-Shortcuts-in-Google-Sheets\">Spell Check using Keyboard Shortcuts in Google Sheets<\/h3>\n<p>With the help of Keyboard shortcuts, we can easily enable the Spell check in Google Sheets. The steps to use the spell check using keyboard shortcuts are listed below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Firstly, we need to enable the Keyboard Shorcuts in Google Sheets. For this open the spreadsheet and click on the &#8220;<strong>Help<\/strong>&#8221; button.<\/li>\n<li><strong>Step 2:<\/strong> Now select &#8220;<strong>Keyboard Shortcuts<\/strong>&#8221; from the drop-down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-611 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets.png\" alt=\"keyboard shortcuts in google sheets\" width=\"744\" height=\"446\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets.png 744w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets-300x180.png 300w\" sizes=\"(max-width: 744px) 100vw, 744px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Keyboard Shortcuts window will open on the screen. Now check the &#8220;\u2018<strong>Enable compatible spreadsheet shortcuts&#8221; <\/strong>box.<\/li>\n<li><strong>Step 4:<\/strong> Once you have enabled this button, just click on<strong> F7<\/strong> on your computer or device.<\/li>\n<li><strong>Step 5:<\/strong> This will run the Spell Check on Google Sheets and show the suggestions. With the help of the options, you can change the spellings on the Google Sheets.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-610 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets1.png\" alt=\"keyboard shortcuts in google sheets\" width=\"1133\" height=\"627\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets1.png 1133w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets1-300x166.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets1-1024x567.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/08\/keyboardshortcuts-google-sheets1-768x425.png 768w\" sizes=\"(max-width: 1133px) 100vw, 1133px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheet Spell Check: With the new Spell Check function in Google Sheets, you can say goodbye to spelling mistakes. Yes, you heard it correctly. When we are working with a huge dataset, we might tend to enter wrong spellings. However, with the help of the Google Sheets Spelling feature, we will be able to &#8230; <a title=\"How to Use Spell Check in Google Sheets to Find Misspelled Words (Keyboard Shortcut Included)\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/spell-check-google-sheets\/\" aria-label=\"More on How to Use Spell Check in Google Sheets to Find Misspelled Words (Keyboard Shortcut Included)\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[137],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1262,"url":"https:\/\/sheetstips.com\/dark-theme-in-google-sheets\/","url_meta":{"origin":631,"position":0},"title":"How to Use Dark Theme in Google Sheets: Simple Steps to Change Google Sheets Theme","author":"Varsha","date":"May 15, 2022","format":false,"excerpt":"It is no surprise for Google Sheets to have various features and functions which make one life easier when it comes to data analysis. One of the amazing features of Google Sheets is that it enables the user to change the theme of the sheet in Dark view, light view\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Use Dark theme in Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/10\/Use-Dark-theme-in-Google-Sheets.jpeg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":137,"url":"https:\/\/sheetstips.com\/count-non-blank-cells-google-sheets\/","url_meta":{"origin":631,"position":1},"title":"How to Count Cells If Not Blank in Google Sheets","author":"Varsha","date":"May 20, 2022","format":false,"excerpt":"Google Sheets If Not Blank: It is really difficult for one to find the cells which are not blank\u00a0 in the numerous datasets mannually. To find the non blank cells in the given dataset on Google sheet, one can make use of Google Sheet count functions. The Count functions of\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Count-Cells-If-Not-Blank-in-Google-Sheets-Countif","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Count-Cells-If-Not-Blank-in-Google-Sheets-Countif-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":216,"url":"https:\/\/sheetstips.com\/drop-down-list-in-google-sheets\/","url_meta":{"origin":631,"position":2},"title":"How to Create a Drop Down List in Google Sheets: Add\/Remove\/Customize Drop Down Menu","author":"Varsha","date":"December 6, 2022","format":false,"excerpt":"Drop Down List in Google Sheets are one of the useful features which allow the user to choose the options from the set of pre-defined options. Using the drop down function on Google Sheets will ensure that the user is not making any mistakes while typing such as spellings and\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how to create a drop down list in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-create-a-drop-down-list-in-google-sheets-7.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":572,"url":"https:\/\/sheetstips.com\/iferror-function-google-sheets\/","url_meta":{"origin":631,"position":3},"title":"Using IFERROR Function in Google Sheets with Examples and Formulas","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"Though Google Sheets is a user-friendly spreadsheet software, we tend to experience Formula Parse Errors from time to time. We experience errors for various reasons. This could be a blank cell, a number, or a relevant alert message that we are unfamiliar with. However, we can use the IFERROR function\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"iferror-function-google-sheets3","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/iferror-function-google-sheets3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1657,"url":"https:\/\/sheetstips.com\/how-to-set-the-default-currency-in-google-sheets\/","url_meta":{"origin":631,"position":4},"title":"How to Set Default Currency in Google Spreadsheet &#8211; Change Currency Settings in Google Sheets","author":"Varsha","date":"May 13, 2022","format":false,"excerpt":"Google Sheets is a great tool that is also used for performing financial calculations. When performing financial calculations in Google Spreadsheets, we might need to change the currency settings as per the county we are residing in. Google Sheets comes with various currency options with the help of which we\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"how to change currency symbol in google sheets1","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/11\/how-to-change-currency-symbol-in-google-sheets1-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":363,"url":"https:\/\/sheetstips.com\/convert-text-to-numbers-google-sheets\/","url_meta":{"origin":631,"position":5},"title":"How To Convert Text to Numbers in Google Sheets: String to Text Conversion","author":"Varsha","date":"December 6, 2022","format":false,"excerpt":"Convert String to Number Formula: When you are working in Google Sheets, you can easily perform the mathematical operations when you are dealing with numbers. However, the same mathematical operations couldn't be performed when it comes to the text nature of numbers. Thus to overcome this issue, we should convert\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"convert-text-to-numbers-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Screenshot-2021-08-05-103542.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/631"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=631"}],"version-history":[{"count":2,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/631\/revisions"}],"predecessor-version":[{"id":4883,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/631\/revisions\/4883"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=631"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=631"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}