![]() ![]() 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 |