This method involves a lot of steps which are also discussed in this article. To strikethrough with this method, in the menu bar, select Format > Strikethrough. On the Google Sheets menu bar, in the formatting group where you can find Bold or Italic icons, there is also the strikethrough icon indicated by a horizontally crossed S click on it to apply strikethrough to your text. Method One: keyboard ShortcutĪlt + Shift + 5 for Windows Command ( ⌘ ) + Shift + X for Mac Alt + Shift + 5 for ChromeOS. However, there are other incredibly simple ways to complete the same task. So far, using the shortcut is one of the quickest ways to strikethrough text or cells in your Google Sheets document. To do so, select the cell or cells containing the text you want to strikethrough, then press Alt + Shift + 5 on Windows, Command (⌘) + Shift + X on Mac, and Alt + Shift + 5 on ChromeOS. The Quickest way to strikethrough in Google Sheets is to use the strikethrough keyboard shortcut. Strikethrough in Google Sheets (Quick Guide) Other Google Sheets Resources You May Find Useful.Remove Strikethrough Added via the Conditional formatting method.Remove Strikethrough Added via the Strikethrough Icon/button in the Menus.Remove Strikethrough Added via Shortcut.How To Remove Strikethrough In Google Sheets.Option 4: Using Conditional Formatting (Strikethrough Formula).Option 3: How to Strikethrough using the Format Dropdown.Option 2: Using the Strikethrough icon or button on the Menus.Option 1: Keyboard Shortcut to Create Strikethrough In Google Sheets.4 Ways to Strikethrough in Google Sheets.Strikethrough in Google Sheets (Quick Guide).This defines where the search will be started from. start-at: this is an optional parameter to define the character in the search-text.search-text: this defines the cell or cell range that the function will search to find the text in the search-for parameter.search-for: this is the text you're searching for in the search-text parameter.Here is the syntax for the formula: =FIND(search-for, search-text, start- at) This formula is case-sensitive, so ensure the text you enter the formula has the proper case. You can use this formula to find the position where the string is first detected in the text. For macOS users, the shortcut is Cmd + F. You can access this by using the Ctrl + F shortcut in Windows. You can repeatedly press the button to traverse the spreadsheet to find the keyword.Īlternatively, if you don't plan to replace any data, and you don't need any of the advanced search features, then use the Find feature instead. This will take you to the first instance of the text in the spreadsheet.

It is also one of the best basic tools in Google Sheets.įinally, click on the Find button. It provides a few advantages over using formulas to achieve the same purpose, the most prominent of which is case matching.

This feature is built into Google Sheets and looks through the spreadsheet to find the keyword you provide. Whether you're just starting out on spreadsheets or are an experienced entrepreneur, learning to search is a very important skill for Google Sheets. The ways to search in Google Sheets we’ll cover in this guide are:Įach performs slightly differently, so checking them all out will help you find the perfect way to search Google Sheets depending on your specific needs. Here are some methods you can use to search text in your spreadsheet. Google Sheets allows you to use formulas and some built-in functions to search text in your spreadsheets. We will discuss some of them extensively here. There are multiple ways that you can search text in your spreadsheet.

Google sheets on mac