![]() ![]() Select the cells or range of cells where you want to remove the strikethrough formatting.If there is any cell (or multiple cells) in the worksheet that has the formatting applied to it, this will remove the strikethrough formatting from all the cells. Click the strikethrough option in the toolbar (or use the keyboard shortcut or format menu).This will select all the cells in the worksheet Click on the gray empty rectangle at the top-left part of the Google Sheets document.In case you have multiple cells that have the strikethrough format applied and you want to remove it from all the cells in the worksheet, use the below steps: Just select the cells that have the strikethrough formatting and use any of the above methods for applying strikethrough. Remove Strikethrough Formatting in Google SheetsĪs I mentioned, the same options for how to put a line through text in google sheets in the first place can also be used to remove the formatting. You can then easily copy the conditional formatting. Under Formatting style, select the strikethrough format.In the example above, we used =$A2=TRUE, which means it will apply the formatting if the checkboxes in column A are checked. Enter the conditional rule in the space below.In the conditional formatting pane, change Format cell if… to Custom formula is.Navigate to Format > Conditional formatting.Highlight the range you want place the conditional formatting in.To add a similar type of conditional formatting in your sheet, follow these steps: Here’s an example of how to cross out text in Google Sheets conditionally: You can use conditional formatting to do so. Let’s say you’re making a to-do list in Google Sheets and want to add strikethrough formatting once you’ve checked off an item. Related Reading: Change Case in Google Sheets Add Strikethrough Format with Conditional Formatting One thing to note is that you can also strikethrough only a part of selected text in cell bu tnot an entire cell. But I have still covered it here to show you all the methods that can be used. Personally, I never use this option as I find the icon in the toolbar to be more convenient (and it only takes one click as compared to two clicks with the Format option method). In the options that appear, go to Text > Strikethrough.Here’s how to strikethrough on Google Sheets with the options menu: Using the Menu OptionsĪnd finally, there is also an option in the menu options in Google Sheets. So if you select the cells where the formatting has already been applied and click on the strikethrough icon again, the formatting will be removed. It will apply the strikethrough formatting to the selected cells. Click on the Strikethrough icon in the toolbar. ![]() If you’re not a keyboard person, there is an equally easy way by using the mouse – and it only takes a click.īelow are the steps to Apply strikethrough using the mouse: In case you only want to apply it to a part of the text, you need to double-click on the cell (or press F2 to get into the edit mode), select the text that you want to strike-through, and then use the above google sheets strikethrough shortcut. Note that in this example, I have applied the strikethrough format to the entire cell content. If you use it again on the cells that already have the strikethrough format applied to it, this will remove the formatting. With the cells selected, use the keyboard shortcut ALT + SHIFT + 5 (hold the ALT and the SHIFT key and press the 5 key).Select the cells or range of cells where you want to apply the strikethrough formatting.Using a Keyboard Shortcutīelow is the keyboard shortcut for Google Sheets to apply the strikethrough formatting to the selected cells (or even multiple ranges of cells) Let’s have a look at how to strikethrough in google sheets with each of these methods. ![]() There are three easy ways you can use to get the strikethrough in Google Sheets: One use-case where it may be needed is when you have a list of tasks and you want to show some tasks with the strikethrough formatting to indicate that these have been completed.Īpply Strikethrough Formatting in Google Sheets While it’s mostly used with text data in tools such as Google Docs or MS Words, you can also use the strikethrough format in Google Sheets. Strikethrough formatting is when you see the text (or number) with a line in the middle. In the options that appear, click on the Strikethrough option.Select the cells or range of cells where you want to apply the strikethrough formatting.What Is the Shortcut for Strikethrough in Google Sheets?. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |