Since the strikethrough is a classic formatting style that looks like crossed-out text, it logically follows that you should be able to strike through text and numbers in Excel.
It is easily removed because it is a format. You can apply strikethrough to text or values by double-clicking and dragging to the other cell.
What is Strikethrough?
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.
How to add a strikethrough in Excel through a keyboard shortcut? / Applying strikethrough using a built-in keyboard shortcut. / Strikethrough through the excel shortcut key.
Step 1: Select the cells to do the strikethrough, here we select cells A2:A4 the project milestones that status is completed.
Step 2: Now press CTRL+5 to strikethrough the selected cells.
How to add a strikethrough in Excel through Format Cell Option? / Applying strikethrough using the Format Cells dialog box. / Apply strikethrough via cell format options.
Step 1: Select the cells to do the strikethrough, here we select cells A2:A4 the project milestones that status is completed. Right-click and select ‘Format Cells’ as indicated in the image.
Step 2: From the following Format Cells window select Font, Effects as Strikethrough, and hit OK
You can derive this Format Cells window by pressing CTRL+1.
Step 3: After clicking OK, your selected text will be in Strikethrough format. Results outlined below:
How to add a strikethrough button to Quick Access Toolbar? / Add a strikethrough button to Quick Access Toolbar / Strikethrough using Quick Access Toolbar.
Step 1: 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.
Step 2: Select “Commands Not in the Ribbon” from the “Choose commands from” menu.
Step 3: Click Strikethrough in the list of commands, then click Add.
Step 4: Select OK. The strikethrough icon will now appear in the quick access toolbar.
Step 5: Select the cells to do the strikethrough.
Step 6: Click on the “Strikethrough button”. It will strikethrough the selected cells.
How to strikethrough automatically with conditional formatting? /Strikethrough using Conditional Formatting.
Step 1: Select the cells to do the strikethrough, here we select cell A2:A4 the project milestones.
Step 2: Select “Conditional Formatting,” and then “New Rule.”
Step 3: Simply tap on “Use a formula to determine which cells to format,” then enter the formula (=B2=” Completed”) and press “Format.”
Step 4: Select the Strikethrough option in the Font tab from the Format Cells dialog box.
Step 5: Click OK. It would implement the strikethrough format to the selected cells.
You may be interested:
