Right-click on the selected cells and choose Format Cells. Alternatively, you can use the shortcut Ctrl+1. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. Right-click on your selection and click on Format Cells options. Add Icon in QAT to Access Strikethrough in Excel You can also select non-adjacent ranges and then apply the strikethrough format. 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.
How to do strikethrough in excel mac how to#
Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box: While the earlier mentioned techniques (keyboard shortcut and icon) are faster ways to access strikethrough formatting, using format cells dialogue box gives you access to a lot of other formatting options as well. Now when you return to your spreadsheet, you should see a strike through your.
When the Format Cells window appears, select the Font tab. Select the cells where you want to apply the strikethrough format. While your mouse is over the selected text, right-click and then select 'Format Cells' from the popup menu.Press Control + 1 (or right click and select Format Cells).In the format cells dialogue box, select the font tab and check the Strikethrough option.This would apply the strikethrough format to the selected cells. While this option is longer as compared to a keyboard shortcut or using the icon, it also gives access to many other formatting options at a single place. For example, you can also change color, font type, font size, border, number format, etc., using this dialogue box.