nomadcr.blogg.se

Select the cells where you want to apply the strikethrough format.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. There is another way you can access strikethrough in Excel – Using Format Cells dialogue box. This will add the strikethrough icon in the quick access toolbar.Īccess Strikethrough Format from Format Cells Dialogue

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 EXAMPLE 2: Using Checkboxes (to show completed tasks).EXAMPLE 1: Using Conditional Formatting.Examples of Using Strikethrough in Excel.Access Strikethrough Format from Format Cells Dialogue.Add Icon in QAT to Access Strikethrough in Excel.Keyboard Shortcut to Apply Strikethrough in Excel.