In the realm of digital documentation, accuracy and clarity are paramount. When working with data or reports in Google Sheets, it becomes essential to occasionally strike through text to indicate it is outdated, irrelevant, or simply incorrect. Fortunately, Google Sheets offers a straightforward method to cross out text, enhancing the readability and organization of your spreadsheets.
How to Cross Out Text in Google Sheets
The process of crossing out text in Google Sheets is quite simple and can be accomplished in two ways: using the keyboard shortcut or the built-in formatting options.
Method 1: Keyboard Shortcut
To cross out text using the keyboard, simply highlight the cell(s) containing the text you want to strike through. Then, press the following key combination:
- Windows/Linux: Ctrl + Shift + ~
- Mac: Command + Shift + ~
The text within the selected cell(s) will now be crossed out.
Method 2: Formatting Options
Alternatively, you can right-click on the cell(s) you want to cross out and select “Format Cells.” In the “Font” tab, locate the “Strikethrough” option and check the box. Click “OK” to apply the formatting.
How to Cross Out Text in Google Sheets
In Google Sheets, there are several ways to visually indicate that text is no longer relevant or applicable. One common method is to cross out the text.
Using the Strikethrough Function (See Also: How To Make Google Sheets Print Landscape)
The built-in strikethrough function is the simplest way to cross out text in Google Sheets. To use it:
- Select the cell or range of cells you want to cross out.
- Click on the `Format` menu.
- Choose `Strikethrough` from the `Text formatting` section.
This will apply a strikethrough to the selected cells.
Using the CHAR Function
The CHAR function can also be used to create a strikethrough effect. The code for a strikethrough is `9997`. To use this method:
- Type the formula `=CHAR(9997)` in the cell.
- Surround the formula with double quotes to treat it as text: `=”` and `”`.
This will display a strikethrough over the text in the cell.
Using a Custom Function (See Also: How To Make A Correlation Matrix In Google Sheets)
If you need more flexibility or want to apply a strikethrough to multiple cells simultaneously, you can create a custom function. This requires some knowledge of Google Apps Script.
Key Points
– The strikethrough function is the simplest way to cross out text in Google Sheets.
– The CHAR function can also be used to create a strikethrough effect.
– A custom function can be created for more flexibility and efficiency.
**Recap:**
To cross out text in Google Sheets, you can use the built-in strikethrough function, the CHAR function, or a custom function. Choose the method that best suits your needs and preferences.
How to Cross Out Text in Google Sheets
How do I cross out text in a cell?
Select the cell you want to edit, type the strikethrough symbol (`) over the text you want to cross out, then press Enter or click outside the cell.
Can I use a keyboard shortcut to cross out text?
Absolutely! Hold down the `Ctrl` key and type `~` over the text you want to cross out.
How do I cross out multiple cells at once?
Select the range of cells you want to cross out, then hold down the `Ctrl` key and click on each cell you want to cross out individually.
What if I want to clear the strikethrough from text?
Select the cell and type the backspace key over the striked-through text until it’s gone.
Is there a way to automatically cross out text based on a condition?
Yes! Use the conditional formatting feature in Google Sheets to apply a strikethrough formatting rule based on a specific condition in the cell.