Google Sheets also makes it straightforward to add strikethrough with conditional formatting. You can take your use of strikethrough formatting to a new level of usefulness with conditional formatting.Ĭonditional formatting is a very helpful tool for getting across extra information visually for people reading a spreadsheet. Add Strikethrough with Conditional Formatting However, “Underline” is still present under the “Format” drop menu in Sheets. Excel emphasizes “Underline” formatting in its shortcut section, which is missing from the Sheets shortcut section. Having “Strikethrough” immediately accessible through an “always present” shortcut highlights a functional difference between Google Sheets and Microsoft Excel. The selected cells are now formatted with a strikethrough. Select “Strikethrough” from the options.Open the “Format” drop menu in the main menu bar.This can be a single cell or a range of cells. Select the cells where you want to format with a strikethrough.Suppose you have the dataset as shown below and you want to apply the strikethrough to some of the cells.īelow are the steps to apply strikethrough in Google Sheets: Add Strikethrough with the Format Drop Menu The ease-of-access to the “Strikethrough” icon is easier to use for devices that don’t use a physical keyboard. Unfortunately, keyboard shortcuts aren’t ideal for touchscreen devices on Google Sheets. To use this feature, select the cells where you want to format with strikethrough and press the following combination of keys: The shortcut is different depending on the operating system. If you find yourself using strikethrough formatting frequently, you can use keyboard shortcuts to speed up the process. Keyboard Shortcut to Apply Strikethrough In Google Sheets Removing Strikethrough In Google Sheets.Add Strikethrough with Conditional Formatting.Add Strikethrough with the Format Drop Menu.Keyboard Shortcut to Apply Strikethrough In Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |