To get rid of the strikethrough format that was applied using a conditional formatting rule, do the following: Remove strikethrough applied through conditional formatting rule
Excel mac strikethrough shortcut how to#
Learn how to apply conditional formatting when a checkbox in Excel is checked here. If you have checkboxes on your worksheet and they’ve been linked to cells that track their status, conditional formatting may also be used to further convey the idea of a completed item. Therefore, Excel applied the rule B3=“Y” to cell A3, B4=“Y” to cell A4, and so on. Note that even though all the cells within the range B2 to B10 were highlighted, the formula that was entered used B2 as a relative cell reference. Click OK to confirm the format and OK to apply to the selected cell(s).Īll text within the highlighted cells will now have the strikethrough format applied.Check the Strikethrough checkbox in the Effects section.In the “ Format values where this formula is true:” field, type =B2=“Y”.Under Select a Rule Type, choose Use a formula to determine which cells to format.Click the conditional formatting dropdown from the Home tab and select New Rule.Select the cell or range of cells to which you want the conditional formatting applied.The condition would likely be based on a value entered in another cell, for example, “Y” in the cell adjacent to the task. In cases where the strikethrough formatting is needed to show that a task is completed, we would use the “formula” option to create our conditional formatting rule. The strikethrough format may also be applied to cells that satisfy the conditions of a specified conditional formatting rule. Strikethrough with conditional formatting This will reveal the More Font Options menu, from where you can select Strikethrough. If you’re using Excel for the web and you want the strikethrough format applied to values in a cell, it’s actually available by clicking on the ellipsis (.) next to the other text formatting commands right from the Home menu. A Strikethrough icon will now appear on the QAT, above the ribbon.Scroll down and select the Strikethrough command, and click Add>.From the Quick Access Toolbar option, choose ‘All Commands’ from the dropdown list on the left.Alternatively, right-click on any ribbon tab and select Customize the Ribbon. Right-click on any existing QAT icon and select Customize Quick Access Toolbar.The Quick Access Toolbar (QAT) offers exactly that solution. If the strikethrough format is one you’ll be using frequently, you may want to access it a bit more quickly. Method 3: Add to Quick Access Toolbar (QAT) When you click OK, the selected cell(s) will have the displayed text formatted with the strikethrough effect.You will see a preview of the strikethrough format in the Preview section of the window. This will open the Format Cells dialog box, from which you can select the Strikethrough checkbox.Go to the Home tab on the ribbon and click on the Font Settings button within the Font command group.Select the cell(s) which should have the strikethrough format.If that’s one too many shortcuts, and you’re not willing to memorize it, follow these steps instead:
0 kommentar(er)
