How to Strikethrough on Google Sheets
Introduction
Google Sheets is a powerful tool for creating and managing spreadsheets, and one of its most useful features is the ability to strikethrough text. In this article, we will show you how to strikethrough text on Google Sheets, including how to do it in real-time, how to apply strikethrough to specific cells, and how to use strikethrough in formulas.
How to Strikethrough on Google Sheets
To strikethrough text on Google Sheets, you can use the following methods:
- Using the Keyboard Shortcut
You can strikethrough text on Google Sheets by using the keyboard shortcut Ctrl + Shift + 9 (Windows) or Command + Shift + 9 (Mac). This will apply strikethrough to the selected cell.
- Using the Menu
You can also strikethrough text on Google Sheets by using the menu. To do this, select the cell where you want to strikethrough text, then go to Format > Strikethrough.
- Using the Formula
You can also strikethrough text on Google Sheets by using a formula. To do this, select the cell where you want to strikethrough text, then enter the following formula: =STRIKETHROUGH(A1) (replace A1 with the cell where you want to strikethrough text).
How to Apply Strikethrough to Specific Cells
To apply strikethrough to specific cells, you can use the following methods:
- Using the Keyboard Shortcut
You can apply strikethrough to specific cells by using the keyboard shortcut Ctrl + Shift + 9 (Windows) or Command + Shift + 9 (Mac). This will apply strikethrough to the selected cell.
- Using the Menu
You can also apply strikethrough to specific cells by using the menu. To do this, select the cell where you want to apply strikethrough text, then go to Format > Strikethrough.
- Using the Formula
You can also apply strikethrough to specific cells by using a formula. To do this, select the cell where you want to apply strikethrough text, then enter the following formula: =STRIKETHROUGH(A1:A10) (replace A1:A10 with the range of cells where you want to apply strikethrough).
How to Use Strikethrough in Formulas
To use strikethrough in formulas, you can use the following methods:
- Using the STIRCHROUGH Function
The STIRCHROUGH function is a built-in function in Google Sheets that allows you to strikethrough text. To use this function, enter the following formula: =STIRCHROUGH(A1) (replace A1 with the cell where you want to strikethrough text).
- Using the STRIP Function
The STRIP function is a built-in function in Google Sheets that allows you to remove strikethrough from text. To use this function, enter the following formula: =STRIP(A1) (replace A1 with the cell where you want to remove strikethrough).
Tips and Tricks
- Use the STIRCHROUGH Function with Multiple Cells
The STIRCHROUGH function can be used with multiple cells by separating the cell references with commas. For example: =STIRCHROUGH(A1,B2) (select cells A1 and B2, then apply strikethrough).
- Use the STRIP Function with Multiple Cells
The STRIP function can be used with multiple cells by separating the cell references with commas. For example: =STRIP(A1,B2) (select cells A1 and B2, then remove strikethrough).
- Use the STIRCHROUGH Function with Formulas
The STIRCHROUGH function can be used with formulas by separating the formula references with commas. For example: =STIRCHROUGH(A1+B2) (select cells A1 and B2, then apply strikethrough).
Conclusion
Strikethrough is a powerful feature in Google Sheets that allows you to remove strikethrough from text. By using the keyboard shortcut, menu, formula, or STIRCHROUGH function, you can strikethrough text on Google Sheets and apply it to specific cells. With these tips and tricks, you can master the art of strikethrough in Google Sheets and take your spreadsheets to the next level.
Table: Strikethrough Methods
| Method | Description |
|---|---|
| Keyboard Shortcut | Applies strikethrough to selected cell |
| Menu | Applies strikethrough to selected cell |
| Formula | Applies strikethrough to selected cell |
| STIRCHROUGH Function | Applies strikethrough to selected cell |
| STRIP Function | Removes strikethrough from selected cell |
Additional Resources
- Google Sheets Help Center: https://support.google.comsheets/
- Google Sheets Tutorials: [https://docs.google.com/spreadsheets/d/1ZQXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXxXx
