werahealing.blogg.se

The above steps would only apply the strike-off only the cell content that was selected.

Double-click on the cell in which you want to apply the strikethrough format (or select the cell and hit the F2 key to get into the edit mode).Click on the ‘Customize the Quick Access Toolbar’ icon.You can add the strikethrough format icon in the Quick Access Toolbar (QAT) so that it’s always visible and you can use it with a single click whenever you want.īelow are the steps to add the strikethrough format icon in the Quick Access Toolbar: If you’re not a fan of using keyboard shortcuts in Excel, or you already have a lot of keyboard shortcuts that you need to memorize and don’t want another one, let me show you another quick way to apply the strikethrough format in Excel. If you select a range of cells and then use this keyboard shortcut, the strikethrough format would be applied to all the cells.īonus Tip: This strikethrough keyboard shortcut also works in Google Sheets Add Strikethrough Icon to Quick Access Toolbar The keyboard shortcut would work as a toggle, so if you use it once it would apply the strikethrough format on a cell, and if you use it again it would remove it. To use this, hold the Command and the Shift key and then press the X key. To use the shortcut, hold the Control key and then press the 5 key.Īnd if you’re using a Mac OS, here is the keyboard shortcut for strikethrough: Cmd+Shift+X Let’s start with the easiest way to apply strikethrough format on a cell in Excel – a keyboard shortcut.īelow is the keyboard shortcut for strikethrough in Excel (Windows): Control + 5 How to Change Strikethrough Color in Excel?.Can You Apply Strikethrough to Partial Text in a Cell?.Strikethrough Using Conditional Formatting.Using Cell Styles to Apply Strikethrough Formatting to Cells.Strikethrough Using Format Cells Dialog Box.Add Strikethrough Icon to Quick Access Toolbar.Strikethrough Keyboard Shortcut in Excel.