add sgtrikethrough to the quickaccess ribbon in excel for mac

Add Sgtrikethrough To The Quickaccess Ribbon In Excel Code For You

Click OK twice. Now, whenever you tick the checkbox, the text in the cell will get a cut line on it.

But there also one more thing which we can use: Thats Strikethrough It means to draw a line through a value in a cell.

In Microsoft Word, the option for striking through a text is there on the home tab of the ribbon.

When it comes to Excel, we dont have any direct option to apply strikethrough to a cell.

So today, in this post, Id like to share with you 5 different methods which you can use to apply strikethrough in Excel.

Quick Navigation 1 Shortcut Key 2 Quick Access Toolbar 3 Format Options 4 VBA Code 5 Conditional Formatting Bonus Tip 1.

Shortcut Key to Apply Strikethrough to a Cell Lets say youre in hurry and dont want to waste your time, then a keyboard shortcut is a perfect option for you.

To apply strikethrough on a cell you can use: And, if you are using Mac then you can use the shortcut key: But heres the kicker: If you want to apply this to a particular part of the text in a cell then you can edit the cell and select only that part of the text, after that use the shortcut key.

And, if you want to apply it more than one cell then you select the entire range or select the non-continues range of cells and the use the shortcut.

After that, from Choose commands from select Commands Not in the Ribbon.

Now, select Strikethrough from the list and add it to the QAT.

Click OK. Now you have an icon of QAT and you can apply strikethrough with a single click.

This button also works if you want to apply it on a particular part of a text and on multiple cells.

Apply Strikethrough from Format Option The real thing is here.

As I said there is no direct option in Excel for strikethrough, but actually, theres a option which you can access from format options.

In font tab, tick mark the strikethrough option.

Click OK. It works same like other options.

Want to know the best part You can also access to other formatting options which are no where on the ribbon through the same.

Add Sgtrikethrough To The Quickaccess Ribbon In Excel Code For You

Run a VBA Code to Apply Strikethrough Macro codes work like a charm and, if you want to use a VBA for strikethrough here is the code for you.

Sub addstrikethrough() Dim rng As Range For Each rng In Selection rng.Font.Strikethrough True Next rng End Sub Above code will help you to apply strikethrough on selected cells.

Use Conditional Formatting to Apply Strikethrough Get to the next level.

Conditional formatting is one of the best ways to apply formatting in a smart way.

Look at the below check list where I have used a check box with conditional formatting to apply strikethrough.

After that, link to cell A1 and change font color of A1 to white.

Select cell B1, go to Home Tab Styles Conditional Formatting New Rule.

Select Use a formula to determine which cell to format option.

Add Sgtrikethrough To The Quickaccess Ribbon In Excel For Mac