Article Overview
ToggleAMPDo you need anything to mark something off a list? Then you need the strikethrough format. If you know how to do it, an Excel strikethrough shortcut may be easily added. Let’s examine how to use the strikethrough format to highlight text in more detail.
The Excel formatting effect known as “Strikethrough” inserts a horizontal line through the value of a cell. One can use this effect to declare a value destroyed or to mark an operation as complete. You can use both text and numerical values with the strikethrough feature.
Using the strikethrough does not alter a cell’s real value, even though it appears as though its value has been removed. It serves only as a formatting tool for displays.
As an illustration, we have a total sum of values 1 and 2. There are regular values in row #2 and values with the strikethrough effect in row #3. In column C, both have a total of 30, although this disparity. Even if a strikethrough has a visual impact, a cell’s value remains unchanged.
The strikethrough shortcut Excel is Ctrl + 5 on both Mac and Windows.
Using the format dialogue box is another method for applying the strikethrough effect. To do this, click Ctrl+1 on Windows to bring up the dialog box for formatting cells. Next, check the strikethrough effect on the lower left corner beneath the font ribbon.
Press Command +1 to bring up the conversation box on a Mac. Next, select the font ribbon and click the strikethrough shortcut box to activate it.
To remove the strikethrough feature in Excel, press Ctrl+5 on the cell currently with the strikethrough feature. This applies to both Mac and Windows.
Alternatively, you can undo the strikethrough by selecting the “untick” option in the format cells dialogue box. To open the format cells dialogue box, press Ctrl +1 on Windows or Command +1 on Mac.
To strikethrough only a portion of a cell’s value, you must first choose the desired portion. For this, you can use the mouse or the shift + arrow keys to move through the characters in the cell. Once chosen, apply the strikethrough effect by pressing Ctrl+5.
Select the required cells with the mouse or the shift + arrow keys to strikethrough several Excel cells. Once the pertinent cells are selected, you can strikethrough every one of them with a single click by pressing Ctrl+5. Once the required cells have been selected, you can use the format cells dialogue box option here.
Strikethrough can be applied with the Format Cells dialog box.
The Format Cells dialog box and keyboard keys can be used to apply strikethrough to a cell or its contents:
Adding Strikethrough to the Quick Access Toolbar and using Alt to access it are additional tactics. The Quick Access Toolbar is easier to use if shown below the Ribbon. Click the down arrow to the right of the Quick Access Toolbar and choose Show below the Ribbon from the drop-down menu if it is above the Ribbon.
To include Strikethrough in Excel’s Quick Access Toolbar:
Hit the Alt key. The Quick Access Toolbar displays essential tips. Press 1 to activate Strikethrough if you’ve moved it to the first position. Press 2 to activate Strikethrough if you’ve pushed it to the second position, and so on. These come in order.
To sum up, Excel provides a variety of formatting options, and one of them is the ability to strike through text. Strikethrough shortcut formatting can be applied and removed from Excel spreadsheets easily by following the above-described techniques. It will improve your data’s visual appeal and readability.