Google Sheets offers numerous easy ways to strikethrough text when needed.
While strikethrough is usually utilized in Google Docs, Google Sheets may also need it.
Sometimes you want to express how information is no longer relevant, but you want to maintain it in the table: you covered strikethrough formatting. You have to check on how to strikethrough on google docs.
Unlike Microsoft Excel, strikethrough is front and center in Google Sheets. Users familiar with Excel who now use Sheets may come over with the notion that both products bury this feature: this is not the case. Here are easy ways to attach Or Switch Strikethrough On Google Docs.
Keyboard Shortcut to Strikethrough Google Sheets
If you often use strikethrough formatting, you can use keyboard shortcuts to accelerate the process.
The shortcut depends on the operating system.
To use this function, select the cells to format with strikethrough and enter the following key combination:
MacOS: Command + Shift+X
Unfortunately, keyboard shortcuts aren’t great for Google Sheets touchscreen devices.
The “Strikethrough” icon is easier to use for devices that do not use a physical keyboard.
Add Strikethrough to Format Drop
Suppose you have the dataset as given below and apply the strikethrough to some cells.
The ways to use strikethrough in Google Sheets:
Select the cells to format with a strikethrough. This can be a single cell or cell range. Knowing how to strikethrough on google docs is something essential.
Open the “Format” drop menu on the menu bar.
Select “Strikethrough” options.
The selected cells now format a strikethrough.
Strikethrough the Toolbar
Alternatively, use the “Strikethrough” shortcut in the second-row menu formatting section (the toolbar) to use this text format.
The “S” icon has a horizontal line drawn through the middle.
Select the text to format with a strikethrough.
Click or press the toolbar “Strikethrough” symbol.
It’s a quick, easy way to add strikethrough formatting to text.
Note that Google Sheets will hide the “Strikethrough” menu shortcut if the browser window is too tiny. However, you may still access this option by hitting the menu expansion ellipsis icon.
Add strikethrough with formatting.
You can use strikethrough formatting to a new utility level using conditional formatting.
Conditional formatting is a helpful tool for visually transmitting extra information for those viewing a table.
Google Sheets also simplifies adding strikethrough with conditional formatting.
This can be quite beneficial when the stock count hits 0 when applying strikethrough to discontinued products in an inventory list. Or you can perform jobs when the status is accomplished, so it looks like these chores are checked off. But, first, you have to know how to strikethrough on google docs.
Below is an example with the tasks and status for each job in the next column.
The objective is to apply the strikethrough format to all ‘Completed’ jobs.
Conditional formatting for our hypothetical example:
Choose the cell range for conditional formatting. In the example, I outlined A2:A6.
Open Menu “Format”
Click Add new rule option in the Rules section Conditional format.
In Format rules,’ select ‘Custom formula is.’
insert the formula: =B2=”Completed”
In the section Formatting style, select the strikethrough format. If you want to provide alternative formatting (such as color the cell in green)
The above methods would apply the strikethrough format to all tasks that complete the status.
Eliminating strikes Google’s sheets
Like any other text formatting, you can delete strikethrough simply repeating the process on the already strikethrough produced text.
Pick the cells with the strikethrough formatting you wish to delete and click the toolbar strikethrough option (or in the Format option in the menu).
You can also remove “Clear Formatting” (but remember that it will remove all the other formatting as well).
Select the text to remove the strikethrough formatting.
Open drop “Format” menu.
Select “Clear formatting” from the choices list.
Alternatively, you can utilize clear keyboard shortcuts that again differ between operating systems:
Windows + Spacebar
MacOS: Command +\
So these are some approaches for applying strikethrough formatting in Google Sheets. You can learn to utilize the feature in a concise period because it’s easier to use than some rival spreadsheet apps.
I hope this tutorial helps you!
Explore your options
Google Docs offers various capabilities to edit and customize your text, and strikethrough is just one. Best of all, they’re available on all devices. It doesn’t matter if your phone, tablet, or web browser uses Google Docs.
Anything else you’d like to know about Google Docs? Let us know in the comments area below, and we may follow up in another article or two.
Be specific to the range.
The Vlookup feature can be quite performance-hungry and cause crawl performance of how to strikethrough on google docs.
By the ranges you reference, you can avoid slow performance.
Instead of calling whole columns like “A: B,” the specific start and end cells like “A1:B1000.” This reduces how much Google Sheets needs to perform to bring in the same amount of information.
When looking for information in column A and returning the result in column D, use “A1:D1000” instead of “A1:F1000.” No need to mention columns E and F if not utilized in the range.
This is especially crucial when calling information between workbooks. A cross-workbook lookup requires internet capacity to transport data between the two.
The above steps are easy to find on how to strikethrough on google docs This will open the file in Google Sheets, but your file in Google Drive will remain in Excel file format. You will need to read those steps as explained above.