3/31/2023 0 Comments Excel strikethrough hotkeyIn the ‘Format rules’ drop-down, select the ‘Custom formula is’ option.Click on the Add new rule option in the Conditional format rules pane.This will open the conditional formatting pane on the right Select “Conditional formatting” from the options list.Select the cell range you want to add conditional formatting to.To add conditional formatting in our hypothetical example, do the following: The intent is to apply the strikethrough format to all the tasks where the status is ‘Completed’. Or you can strikethrough tasks where the status is completed, so it looks as like these tasks are checked off.īelow is an example where I have the tasks and the status for each task in the column next to it. This can be very useful for things like adding strikethrough to discontinued products in an inventory list when the stock count hits zero. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |