How to strikethrough in Excel
This short tutorial explains how to use strikethrough format in Excel desktop, Excel Online, and Excel for Mac. Strikethrough is a term that refers to drawing a line through a value in a cell in a variety of ways.
Excel strikethrough shortcut
Ctrl 5 is the keyboard shortcut for strikingthrough in Excel. It can be used to strikethrough an entire cell or specific parts of the cell contents, as well as a single cell or a range of cells using a key combination.
Apply strikethrough via cell format options
Choose Format Cellsu2026 from the context menu to draw a line through a cell value in Excel. Select one or more cells on which you want to apply the strikethrough format, and right-click the selected cell(s).
Add a strikethrough button to Quick Access Toolbar
Click the small arrow in the upper left corner of the Excel window, then More Commandsu2026. Select Commands Not in the Ribbon under Choose commands from, and then OK. Strikethrough will be added to the list of commands on the right pane.
Put a strikethrough button onto Excel ribbon
Place the Strikethrough button on the ribbon instead of the Quick Access Toolbar if your Quick Access Toolbar is only for the most frequently used commands, which strikethrough is not. You can move the Strikethrough button to any position on the ribbon by using the Up and Down arrows in the Excel Options dialog box.
How to strikethrough automatically with conditional formatting
If you’re going to use a strikethrough in a checklist or to-do list, Conditional Formatting lets you specify a formula to determine which cells to format and how much space to give them.
Add strikethrough with a macro
If you don’t want to use VBA in your Excel worksheets, you can use this line of code to apply strikethrough to all selected cells (step-by-step instructions on how to insert VBA code in Excel can be found here).
How to use strikethrough in Excel Online
The strikethrough option is where you’d expect it to be in Excel Online – next to the other formatting buttons on the Home tab – but there’s a catch: you can’t select non-adjacent cells or ranges in Excel Online.
How to strikethrough in Excel for Mac
Strikethrough text can also be done from the Format Cells dialog, just like in Excel for Windows: select the cell(s) or part of a cell value you want to cross out, right-click it, and select Format Cells from the popup menu.
How to remove strikethrough in Excel
The correct way to remove strikethrough from a cell phone depends on how you added the text, so make sure the instructions on your device are clear and easy to read before adding any additional letters or characters.
Remove strikethrough added manually
The strikethrough will disappear if you press Ctrl 5 again, or if you open the Format Cells dialog (Ctrl 1) and uncheck the Strikethrough box there.
Remove strikethrough added with conditional formatting
If strikethrough is added by a conditional formatting rule, you must remove that rule to remove it. To do so, select all the cells you want to remove strikethrough from and go to Conditional Formatting > Clear Rules. That’s how you can add and remove strikethrough in Excel.
How do you quickly draw a line in Excel?
Select a row and use the shortcut CTRL SHIFT to quickly insert a row in Excel. To quickly insert multiple rows, select multiple rows and use the same shortcut.
How do I manually draw a line in Excel?
In Excel, how to Draw a Line
- Click the “Insert” tab in Excel.
- Click “Shapes” in the “Illustrations” section.
- Click the “Line” button, which is the first button on the left under “Lines.”
- Click and drag to draw the line.
What is the command for strikethrough?
You can use a keyboard shortcut to quickly achieve a single strikethrough effect on a PC: Alt H 4; on a Mac: Cmd Shift X. So, select a piece of text or an entire paragraph and hit these keys on your keyboard.
How do you put a line through text on Samsung?
Tap and hold the text on an Android smartphone, then select Bold, Italic, or More; tap More to select Strikethrough or Monospace.
How do I enter multiple lines in an Excel cell?
You can precisely control where the line breaks appear by following these simple steps.
- Click on the cell where you want to enter multiple lines of text.
- Type the first line.
- Press Alt Enter to add another line to the cell.
How do I make grid lines bold in Excel?
Make sure the Show gridlines check box is selected in the Advanced category, under Display options for this worksheet, and in the Gridline color box, click the color you want. Tip: To return gridlines to the default color, click Automatic.
Can I draw a diagonal line in Excel?
Choose the diagonal line option at the bottom right of the menu, or click the other diagonal line icon on the lower left of the menu to draw your line in the opposite orientation.
How do I draw a horizontal line in Word?
To make a horizontal line in Word, follow these steps:
- Select the u201cInsertu201d tab, then u201cShapes.u201d
- From u201cLines,u201d choose the style you want.
- Select the place to add the line on the document.
- Hold and drag your cursor to draw the line, releasing it at the end.
How do you draw a line on a spreadsheet?
To draw a line in Excel, select LINE from the Lines section of Shapes, then draw it anywhere on a sheet by holding the left click of the touchpad or mouse, moving it in any direction we want, and then letting go of the buttons to drop the line’s endpoint.
How do you Strikethrough in notepad?
In a notepad, highlight the text you want to strikethrough, then press “CTRL” to strike it out.
Is there a keyboard shortcut for Strikethrough in Excel?
Once the cells have been selected, simply press Ctrl 5, the excel strikethrough shortcut key, to strikeout the data.