Strikethrough shortcut excel mac how to#
Strikethrough shortcut excel mac free#
Strikethrough shortcut excel mac mac#

Some of the basic keyboard shortcuts for Excel are the same on a Mac or PC, but most shortcuts, especially the more complex ones, are mapped differently for Excel on macOS. In this article, we'll review the most useful Mac Excel shortcuts, organized into a simple table for quick reference. That's where a handy 'cheat sheet' can be a game changer. While these shortcuts make many tasks easier, it can take time to learn and master them all.

Strikethrough shortcut excel mac free#

Or try our free Excel in an Hour crash course for something quick and basic.If you use Excel frequently, you know how much time keyboard shortcuts can save. If you found this useful, you should check out our other resources, or take a look at our Excel - Basic and Advanced course. So, which strikethrough in Excel method was your favorite? This means it can also be used to copy the strikethrough effect, as seen below. The format painter can be used to apply any formatting style, including conditional formatting, to the destination cell.After that, apply the strikethrough formatting using your method of choice. If you want to apply a strikethrough format only to a part of the text in a cell, then simply get into edit mode, either by double-clicking the cell or pressing the F2 key, then highlighting the desired text or values.From the expanded menu, select either Clear Rules from Selected Cells (to stop applying the rule only for the active and any other highlighted cells), or Clear Rules from Entire Sheet (to remove all conditional formatting rules from the current worksheet).

Click the Conditional Formatting dropdown menu from the Home tab.

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

Strikethrough shortcut excel mac 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: