Here's the keyboard shortcut to strikethrough in Excel:Ctrl + 5 The shortcut can be used on an entire cell, certain part of the cell contents, or a range of cells. To apply the strikethrough format to acell, select that cell, and press the shortcut: To draw a line through all valu...
Also relevant for you is the ‘Format painter’ that I mentioned before. That’s actually also a way of copying the strikethrough format to other cells. The keyboard shortcut for strikethrough in Excel is great – but Excel has tons of other keyboard shortcuts worth mentioning. Learn 7 total...
There is another way you can access strikethrough in Excel – Using the Format Cells dialog box. While the earlier mentioned techniques (keyboard shortcut and icon) are faster ways to access strikethrough formatting, using the Format cells dialog box gives you access to a lot of other formatting...
3. On the Font tab, under Effects, click Strikethrough. 4. Click OK. Result: You can also use a keyboard shortcut to quickly apply strikethrough formatting in Excel. 5. For example, select cell A7. 6. Press Ctrl + 5. Result:
The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard. A plus sign (+) in a shortcut means that you need to press multiple keys at the same time. A comma sign (,) in a shortcut means that ...
Solution 2: By Adding Strikethrough Option to Quick Access Toolbar Solution 3: Using the Format Cells Options Solution 4: Strikethrough Using Conditional Formatting Solution 1: By Using a Keyboard Shortcut Step 1:Select all the cellsthat you want to apply the strikethrough formatting to. Once the...
1. Shortcut Key to Apply Strikethrough to a Cell Let’s say you’re in hurry and don’t want to waste your time, then a keyboard shortcut is a perfect option for you. To apply strikethrough on a cell you can use: And, if you are using Mac then you can use theshortcut key: ...
Using Excel keyboard shortcut keys allows you to stay focused on what matters — the data. You won’t need to stop and search for commands in the toolbar. This helps you stay in the zone and makes even the most data-heavy tasks easier to manage. ...
Keyboard shortcuts to edit Excel Cells Want to edit cells with keyboard shortcuts? Use these options. F2:Edit a single cell Shift+F2:Add or edit a single cell comment Ctrl+X:Do this if you want to cut the contents of a cell, selected data, or selected cell range ...
1. Use the Excel Strikethrough Keyboard Shortcut The Excel strikethrough shortcut is the fastest way to apply a strikethrough. If you’re already used to usingkeyboard shortcuts for Microsoft Wordand other applications, it’s easy to add the Excel strikethrough shortcut to your muscle memory: T...