There is another way you can access strikethrough in Excel – Using Format Cells dialogue box. Access Strikethrough Format from Format Cells Dialogue # This will add the strikethrough icon in the quick access toolbar. Scroll down and select Strikethrough from the list. In the Excel Options dialogue box, select All Commands from the drop-down. Right-click on any existing QAT icon or the ribbon tabs and select ‘Customize Quick Access Toolbar…’. Here are the steps to add strikethrough icon in the QAT: While the icon is not available in the ribbon or Quick Access Toolbar (QAT) by default, you can add it easily. Add Icon in QAT to Access Strikethrough in Excel # You can also select non-adjacent ranges and then apply the strikethrough format.

If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. Just select the cell where you want to apply the strikethrough format and press Control + 5. Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel. Keyboard Shortcut to Apply Strikethrough in Excel # In this tutorial, I will share various ways to access the strikethrough option and apply it to text in Excel. However, there is no icon in Excel ribbon to do this.

Those who work with Microsoft Word use this extensively, and there is strikethrough icon right there in the ribbon. In most cases, it means that the task or activity has been completed and has been checked off. What comes to your mind when you see text with a strikethrough in Excel (something as shown below)?

Format date cells in excel not working