This will add the strikethrough icon in the quick access toolbar.Īccess Strikethrough Format from Format Cells Dialogue 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 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |