{"id":1184,"date":"2022-11-30T20:09:01","date_gmt":"2022-11-30T20:09:01","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1184"},"modified":"2024-02-15T16:15:56","modified_gmt":"2024-02-15T16:15:56","slug":"how-to-strikethrough-text-in-excel-shortcut-and-example","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-strikethrough-text-in-excel-shortcut-and-example\/","title":{"rendered":"How to Strikethrough Text in Excel \u2013 shortcut and example?"},"content":{"rendered":"

Strikethrough text in Excel offers a versatile way to visually indicate changes, completed tasks, or canceled items within your spreadsheet. By applying strikethrough formatting, you can quickly draw attention to updated information or mark items as completed, making it easier to track progress or identify changes. Whether you’re managing tasks, editing text, or highlighting revisions, utilizing strikethrough text in Excel enhances clarity and organization. With this simple formatting tool, you can streamline your data presentation and improve readability in your Excel documents.<\/p>\n

What is Strikethrough?<\/strong><\/h2>\n

A strikethrough is plainly a line that runs through the middle of a word. It is indeed ideal for working together and showing others which words you believe should be eliminated.<\/p>\n

How to add a strikethrough in Excel through a keyboard shortcut?<\/strong><\/h2>\n

Step 1: <\/strong>Select the cells to do the strikethrough, here we select cells A2:A4 the project milestones that status is completed.<\/p>\n

\"Strikethrough<\/p>\n

Step 2: <\/strong>Now press CTRL+5 to strikethrough the selected cells.<\/p>\n

\"Strikethrough<\/p>\n

How to add a strikethrough in Excel through Format Cell Option?\u00a0<\/strong><\/h2>\n

Step 1: <\/strong>Select the cells to do the strikethrough, here we select cells A2:A4 the project milestones that status is completed. Right-click and select \u2018Format Cells\u2019 as indicated in the image.<\/p>\n

\"Strikethrough<\/p>\n

Step 2: <\/strong>From the following Format Cells window select Font, Effects as Strikethrough, and hit OK<\/p>\n

You can derive this Format Cells window by pressing CTRL+1.<\/p>\n

\"Strikethrough<\/p>\n

Step 3: <\/strong>After clicking OK, your selected text will be in Strikethrough format. Results outlined below:<\/p>\n

\"Strikethrough<\/p>\n

How to add a strikethrough button to Quick Access Toolbar?<\/strong><\/h2>\n

Step 1: <\/strong>Select More commands from the drop-down menu by clicking the down arrow to the right of the Quick Access Toolbar. The Options window appears.<\/p>\n

\"Strikethrough<\/p>\n

Step 2:<\/strong> Select “Commands Not in the Ribbon” from the “Choose commands from” menu.<\/p>\n

\"Strikethrough<\/p>\n

Step 3: <\/strong>Click Strikethrough in the list of commands, then click Add.<\/p>\n

\"Strikethrough<\/p>\n

Step 4:<\/strong> Select OK. The strikethrough icon will now appear in the quick access toolbar.<\/p>\n

\"Strikethrough<\/p>\n

Step 5: <\/strong>Select the cells to do the strikethrough.<\/p>\n

Step 6: <\/strong>Click on the \u201cStrikethrough button\u201d. It will strikethrough the selected cells.<\/p>\n

How to strikethrough automatically with conditional formatting?<\/strong><\/h2>\n

Step 1: <\/strong>Select the cells to do the strikethrough, here we select cell A2:A4 the project milestones.<\/p>\n

\"Strikethrough<\/p>\n

Step 2:<\/strong> Select “Conditional Formatting,” and then “New Rule.”<\/p>\n

\"Strikethrough<\/p>\n

Step 3:<\/strong> Simply tap on “Use a formula to determine which cells to format,” then enter the formula (=B2=” Completed”) and press “Format.”<\/p>\n

\"Strikethrough<\/p>\n

Step 4:<\/strong> Select the Strikethrough option in the Font tab from the Format Cells dialog box.<\/p>\n

\"Strikethrough<\/p>\n

Step 5: <\/strong>Click OK. It would implement the strikethrough format to the selected cells.<\/p>\n

\"Strikethrough<\/p>\n

Application of\u00a0<\/strong>Strikethrough Text in Excel<\/h2>\n