Strikethrough formatting is majorly used to highlight the tasks as completed or no longer required. This formatting passes a line through the middle of the text which indicates the task is now completed or become older and no longer required.
Users can apply this formatting when they want to highlight any task as completed and want to leave that task as done with no longer action required.
In this tutorial, we will show you multiple ways of applying Strikethrough in Google Sheets
Apply Strikethrough Using Format Menu
- First, select the cells, where you want to apply strikethrough and go to the “Format” tab.
- After that, hover the mouse on the “Text” option and then click on the “Strike-through” option.
- The moment, you click on the “Strike-through” option, it will apply the strikethrough formatting on the selected cells.
Apply Strikethrough Using Toolbar Strikethrough Icon
In Google Sheets, the Strikethrough shortcut icon is by default available on the toolbar, which you can use to apply the formatting quickly.
- First, select the cells, where you want to apply strikethrough.
- After that, click on the toolbar “Strikethrough” icon and the formatting will get applied to the selected cells.
Apply Strikethrough Using the Keyboard Shortcut
The strikethrough shortcut is a good option for those, who use this formatting often and love to use the shortcuts to speed up the tasks.
- For Windows OS, Select the cells, where you want to apply the formatting and then simply press “Alt + Shift + 5”.
- For Mac OS, Select the cells, where you want to apply the formatting and then simply press “Cmd + Shift + X”.
Apply Strikethrough with Conditional Formatting
Conditional Formatting is the best way to apply the auto strikethrough formatting to the “To do list”. The best way of applying this formatting is along with the checkboxes. To do the same, follow the below steps:
- First, select the cells and go to the insert tab and click on “Tick box” to add the checkbox in the selected cells.
- After that, highlight the task list and go to the “Format” tab and then click on the “Conditional formatting” option.
- Now, click on the “Format cells if” value field’s drop-down arrow and choose “Custom formula is”.
- Once selected, enter the formula “=$A2=TRUE” within the input bar below the “Custom Formula is” to apply the formatting only when the checkbox gets checked.
- In the end, choose the strikethrough format from the “Format style” and color if want to apply to the strikethrough cells and click “Done”.
Now, whenever you tick the checkbox, the text in the cell next to it will get strikethrough applied to it. We had also chosen the green color from the “Formatting style” in the above step, so the strikethrough cells are also getting green but you can choose another color or no color based on your preference.
Apply Strikethrough to the Part of a Cell
- First, double-click on the cell to bring the cell into edit mode, and then select only the part of the text, where you want to apply strikethrough.
- After that, click on the toolbar “Strikethrough” icon or press the keyboard shortcut “Alt + Shift + 5” and it will add the strikethrough on that selected part of the cell.
Remove Strikethrough Formatting in Google Sheets
- First, select the range of cells, from where you want to remove the strikethrough formatting.
- Once selected, go to the “Format” tab and then click on “Clear formatting” and it will remove all kinds of formatting from the selected cells.
