In the realm of spreadsheets, Google Sheets stands as a powerful tool for organizing and analyzing data. Often, you might need to emphasize certain information by striking through it, indicating that it’s outdated, incorrect, or simply needs to be highlighted. Understanding how to achieve this formatting can significantly enhance the clarity and professionalism of your spreadsheets.
How to Strikethrough Text in Google Sheets
Fortunately, Google Sheets provides a straightforward method for applying strikethrough formatting to your text. Let’s explore the different ways you can achieve this.
Using the Strikethrough Shortcut
One of the quickest ways to strikethrough text is by using a keyboard shortcut. Simply select the text you want to strikethrough and press the following key combination:
- Ctrl + Shift + ~ (Windows/Chrome OS)
- Cmd + Shift + ~ (Mac)
Using the Format Menu
Alternatively, you can access the strikethrough option through the Format menu. Follow these steps:
- Select the text you want to strikethrough.
- Click on “Format” in the menu bar.
- Choose “Text formatting” from the dropdown menu.
- Check the box next to “Strikethrough” to apply the formatting.
How To Do Strikethrough On Google Sheets
Strikethrough text is a great way to indicate that information is no longer valid or has been crossed out. Google Sheets doesn’t have a dedicated strikethrough formatting option, but you can easily achieve this effect using a simple keyboard shortcut or a formula.
Using the Keyboard Shortcut
The quickest way to strikethrough text in Google Sheets is by using the following keyboard shortcut: (See Also: How To Insert Text In Google Sheets)
- Select the cell or range of cells containing the text you want to strikethrough.
- Press the `~~` key combination.
This will instantly apply strikethrough formatting to your selected text.
Using a Formula
If you need to dynamically strikethrough text based on a condition, you can use a formula. This method is particularly useful when you want to strikethrough text based on the value in another cell or a calculation.
The TEXT function
You can use the `TEXT` function in combination with the `~~` characters to achieve this. Here’s how:
- In the cell where you want the strikethrough text to appear, enter the following formula, replacing `A1` with the cell containing the text you want to strikethrough:
- `=TEXT(A1,”~~”&A1&”~~”)`
This formula will display the text from cell `A1` with strikethrough formatting. (See Also: How To Make Text Uppercase In Google Sheets)
Recap
This article covered two methods for applying strikethrough formatting in Google Sheets: a keyboard shortcut and a formula. The keyboard shortcut provides a quick and easy way to strikethrough static text, while the formula offers more flexibility for dynamically applying strikethrough based on conditions.
Frequently Asked Questions: Strikethrough in Google Sheets
How do I create a strikethrough in Google Sheets?
You can create a strikethrough in Google Sheets using the “strikethrough” formatting option. Select the cell or cells you want to strikethrough, then click on the “Format” menu and choose “Text formatting”. In the text formatting options, you’ll see a checkbox for “Strikethrough”. Check the box to apply the strikethrough formatting.
Is there a keyboard shortcut for strikethrough in Google Sheets?
Unfortunately, there isn’t a dedicated keyboard shortcut for strikethrough in Google Sheets. You’ll need to use the “Format” menu as described above.
Can I apply strikethrough to multiple cells at once?
Yes, you can apply strikethrough to multiple cells at once. Simply select the range of cells you want to format, then follow the same steps as above to apply the strikethrough formatting.
Will strikethrough formatting carry over when I copy and paste cells?
Yes, strikethrough formatting will be preserved when you copy and paste cells in Google Sheets.
Can I remove strikethrough formatting?
Absolutely! To remove strikethrough formatting, select the cell or cells with the strikethrough and repeat the steps from the first FAQ, unchecking the “Strikethrough” box in the text formatting options.