In Google Sheets, formatting text effectively is crucial for creating clear, organized, and visually appealing spreadsheets. One common formatting technique is using strikethroughs to indicate deleted or crossed-out text, which can be helpful for tracking changes, highlighting outdated information, or simply emphasizing certain cells.
How to Do a Strikethrough in Google Sheets
There are two primary methods to apply strikethrough formatting in Google Sheets:
1. Using the Strikethrough Button
The most straightforward way is to utilize the built-in strikethrough button located in the toolbar above the spreadsheet.
2. Using the Format Menu
Alternatively, you can achieve the same result by accessing the “Format” menu and selecting “Text formatting” followed by “Strikethrough.”
How to Do a Strikethrough in Google Sheets
Strikethrough text is a great way to indicate that something has been crossed out or is no longer valid. Fortunately, Google Sheets makes it easy to add strikethrough formatting to your cells. (See Also: How To Make Dropdowns In Google Sheets)
Using the Format Menu
Here’s how to strikethrough text using the Format menu:
- Select the cell or cells containing the text you want to strikethrough.
- Click on the “Format” menu at the top of the screen.
- Hover over “Text formatting” and select “Strikethrough”.
Your selected text will now appear with a strikethrough.
Using Keyboard Shortcuts
You can also quickly apply strikethrough formatting using keyboard shortcuts:
- Select the cell or cells containing the text you want to strikethrough.
- Press Ctrl + 2 (Windows) or Command + 2 (Mac).
- A dialog box will appear. Check the “Strikethrough” box and click “OK”.
Removing Strikethrough
To remove strikethrough formatting, simply follow the same steps as above, but uncheck the “Strikethrough” box in the Format menu or keyboard shortcut dialog box.
Key Points to Remember
- Strikethrough formatting is a visual way to indicate that something has been crossed out or is no longer valid.
- You can apply strikethrough formatting using the Format menu or keyboard shortcuts.
- To remove strikethrough formatting, simply uncheck the “Strikethrough” box.
Recap
This article demonstrated how to easily add and remove strikethrough formatting in Google Sheets. Whether you’re marking outdated information or simply want to emphasize a point, strikethrough is a useful tool to have in your Google Sheets arsenal. (See Also: How To Get Google Sheets In Dark Mode)
Frequently Asked Questions: Strikethrough in Google Sheets
How do I create a strikethrough in Google Sheets?
You can create a strikethrough in Google Sheets by using the “strikethrough” formatting option. Select the cell or range of cells you want to strikethrough, then click on the “Format” menu and choose “Strikethrough”.
Is there a keyboard shortcut for strikethrough?
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 strikethrough text in a formula?
No, you cannot directly strikethrough text within a formula. Formulas are treated as text, but the strikethrough formatting won’t apply.
What happens if I strikethrough a cell that contains a formula?
If you strikethrough a cell that contains a formula, the strikethrough will only apply to the displayed result of the formula, not the formula itself. The formula will still function as intended.
Can I remove strikethrough formatting?
Yes, you can easily remove strikethrough formatting. Select the cell or range of cells with the strikethrough, then click on the “Format” menu and choose “No Strikethrough”.