Some are marked “Done”, some are” not done”. This example shows various steps in an HR Procedure. The fastest way to apply strikethrough on cell/cells is by pressing CTRL+5Įxample: Here is a sample data on which we will apply the breakthrough effect. Method # 3 – Strikethrough in excel through the keyboard shortcut Press OK, and the strikethrough effect will be removed from the selected cell/cells. In case you want to remove the strikethrough from the selected cell/cells, just follow the same procedure and uncheck the strikethrough box as shown below. Then, as shown above, select the strikethrough option under “Effects”, and all the selected cell/cells will have a line passing through them. Step 2 – Select the cell/cells and press CTRL+1, and you will see the Format Cell dialog box. Now, under Effects, you need to check the box for strikethrough and press OK. Now click on format cells, and the Format Cell dialog box will appear as below. Step 1 – Right-click on the selected cell/cells and then select the Format Cells option in the drop-down menu. Now, you can use any of the ways to bring the Format Cell dialog box as shown below. Again, the help of previous sample data illustrates it.Įxample: Now, we will select all the cells under the Role column. Method #2 – Strikethrough in Excel using Format Cells Dialog BoxĪnother way to apply strikethrough in excel is by using the Format Cell dialog box. However, it is limited to text and can be any number, date, currency, or any other type. Strikethrough can be applied to any type of cell. Press OK, and the strikethrough effect will be removed from cells.
We can remove or disable strikethrough in excel anytime by selecting the relevant cell/cells and by unchecking the strikethrough box. In short, the strikethrough Effect is applied. If you are using a Mac, you can easily apply a strikethrough to selected cells, using the shortcut Command + Shift + X.A line now passes through all the cells in column “Executive”.
#Mac shortcut for strikethrough in excel how to
How to Apply Strikethrough on Excel Mac Version? This will apply the strikethrough formatting to all selected cells in that particular Excel workbook.
#Mac shortcut for strikethrough in excel code
Then run the following VBA code in the VBA editor ( Alt + F11) Sub ApplyStrike()
What if you need to strikethrough multiple cells split across multiple sheets? Don’t worry, as VBA codes come to your rescue.įirst, select the cells you want to strikethrough across multiple sheets by holding down the Ctrl button. In some cases, you may have too many cells that need to be striked off in one go. How to Apply Strikethrough to Multiple Sheets using VBA?Īll the methods that we just discussed apply to cells of a single sheet. Select the Strikethrough option in the Font tab and click OK You can even select multiple non-adjacent cells by holding the Ctrl button and clicking them. You can apply it by selecting a single cell, parts of a single cell, or a range of cells. The keyboard shortcut to apply strikethrough in Excel is Ctrl+5. There are different ways to do this in Excel. It is a formatting style that is generally used to indicate edits, cancelled or completed items in a spreadsheet. A strikethrough is just a line that crosses over the values of a cell. How to Make a Line Graph in Excel? 4 Best Line Graph Examples How to Apply Strikethrough in Excel?īefore we begin, let us first understand what strikethrough means. Add a Strikethrough Button in the Excel RibbonĮasily Make a Bullet Chart in Excel-2 ExamplesĬreating a Dynamic Pivot Chart Title Based on Slicer(6 Easy Steps).Add a Strikethrough Button in the Quick Access Toolbar.Shortcut Buttons for Strikethrough in Excel.How to Apply Strikethrough on Excel Mac Version?.How to Apply Strikethrough to Multiple Sheets Using VBA?.How to Apply Strikethrough via Format Options?.In this short guide, we will show you some easy methods to apply strikethrough in Excel. We are sure you have frantically searched for the strikethrough option in the Excel ribbon but, to your disappointment, didn’t find it. However, when it comes to formatting text, it can be a little confusing if you are not already familiar with some of the features. Note: This tutorial on strikethrough in Excel is suitable for all Excel versions including Mac and Office 365.Įxcel is a great program for crunching numbers and there is no doubt about that. Home > Microsoft Excel > 6 Easy Methods to Strikethrough in Excel 6 Easy Methods to Strikethrough in Excel Power Pivot, Power Query and DAX in Excel.
0 kommentar(er)
