How to Add Strikethrough in Excel Toolbar (3 Easy Ways)

Strikethrough is a special character. It is mainly used to format the cells. When a person applies the strikethrough on any cell, a line appears through the text or the value contained in that cell. Though this is a cell format option, sometimes this option does not remain in the Excel Toolbar. In this context, we will demonstrate to you 3 different ways how to add strikethrough in Excel Toolbar. If you are also interested to know the approaches, download our workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


What Is Strikethrough in Excel?

Strikethrough is a special type of character available in Microsoft Excel. It is a cell format option. After applying the Strikethrough the cell shows a straight line through the cell value. The Strikethrough command in Excel toolbar shows like the image shown below:

How to Add Strikethrough in Excel Toolbar

As this feature is a cell format option, sometimes you will find it inside the Font group of the Home tab. The icon shows below for your convenience.

When we apply the Strikethrough command to any cell, the cell shows like the image.

How to Add Strikethrough in Excel Toolbar


3 Easy Ways to Add Strikethrough in Excel Toolbar

In this context, we will show you 3 distinct methods of adding Strikethrough to your Excel spreadsheet toolbar. After adding the command, we will also illustrate its application to our dataset. Regarding that issue, we are considering a dataset of 10 text strings. So, our dataset is in the range of cells B5:B14. We will apply the Strikethrough format to cell B8.


1. Add Strikethrough from Excel Options

In this following process, we will demonstrate to you how to add the Strikethrough command from the Options. The location of this command icon will be inside any existing tab of the Excel Toolbar. In our case, we choose the Home tab to allocate the command. The process is explained below as follows:

📌 Steps:

  • To enable the Strikethrough command, first of all, select File > Options.

  • A dialog box called Excel Options will appear.
  • Now, select the Customize Ribbon option.
  • After that, select the drop-down arrow of the box below Choose commands from.
  • Change the Popular Commands to All Commands option.

Add Strikethrough in Excel Toolbar from Excel Options

  • All the commands of Excel will show below the box. Then, move down the slide bar of that box with the help of your mouse and find the Strikethrough command.
  • Now, from the Main Tabs box, allocated on the right side, select your desired tab. We choose Home according to our desire.
  • Next, click on the New Group option below the Main Tabs box.

Add Strikethrough in Excel Toolbar from Excel Options

  • A new group titled New Group (Custom) will create. Rename the group, if you want. Here, we keep the default group name.

  • Then, select the Strikethrough command from the left box and click the Add button.

Add Strikethrough in Excel Toolbar from Excel Options

  • You will see the command will add to the group entitled New Group.
  • Finally, click OK.

Add Strikethrough in Excel Toolbar from Excel Options

  • Now, select cell B8 and look at the far left side of the Home tab. You will find the group called New Group and the Strikethrough command.

Add Strikethrough in Excel Toolbar from Excel Options

  • Click on the command icon and you will get the Strikethrough format on cell B8.

How to Add Strikethrough in Excel Toolbar

Finally, we can say that according to our working steps, we are able to add the Strikethrough command in Excel Toolbar.


2. Insert Strikethrough in New Customized Tab

In this method, we will create a new tab and add the Strikethrough command from the Options into that tab. After that, we demonstrate the application to our dataset on cell B8. The steps of this approach explain below:

📌 Steps:

  • In the beginning, select File > Options.

  • A dialog box entitled Excel Options will appear.
  • After that, select the Customize Ribbon option.
  • Then, select the drop-down arrow of the box below Choose commands from and change the Popular Commands to All Commands option.

Add Strikethrough in Excel Toolbar from Excel Options

  • You will see all the commands of Excel will show below the box. Now, move down the slide bar of that box and get the Strikethrough command.
  • Now, from the Main Tabs box, allocated on the right side of the previous box, select any tab after which you want to insert the new tab. We choose Help as we want to place the new tab at last.
  • Then, click on the New Tab option below the Main Tabs box.

Create a New Customize Tab to Add Strikethrough in Excel Toolbar

  • A new tab and group titled New Tab (Custom) and New Group (Custom) will create. Rename them, if you want. Here, we keep the default names.

  • Now, select the Strikethrough command from the left box, and after that New Group (Custom). Then, click the Add button.

Create a New Customize Tab to Add Strikethrough in Excel Toolbar

  • You will see the command will be added below the group name. At last, click OK to close the window.

Create a New Customize Tab to Add Strikethrough in Excel Toolbar

  • You will see a new tab is created after the Help tab titled New Tab.

Create a New Customize Tab to Add Strikethrough in Excel Toolbar

  • Now, select cell B8, and in the New Tab, select the Strikethrough command from the New Group.

Create a New Customize Tab to Add Strikethrough in Excel Toolbar

  • You will get the Strikethrough format on cell B8.

How to Add Strikethrough in Excel Toolbar

Thus, we can say that our method worked successfully and we are able to add the Strikethrough command in Excel Toolbar.


3. Add Strikethrough in Quick Access Toolbar

Another way of showing the Strikethrough command in the toolbar is to add it to the Quick Access Toolbar. This toolbar is a separate toolbar from the Excel ribbon. It is usually located below or above the main Excel Ribbon. People usually add the most frequently used commands in that toolbar. In this method, we will show the procedure to add the Strikethrough command to the Quick Access Toolbar. The steps are given below:

📌 Steps:

  • At first, select File > Options.

  • A dialog box entitled Excel Options will appear.
  • Now, select the Quick Access Toolbar option.
  • After that, select the drop-down arrow of the box below Choose commands from and change the Popular Commands to All Commands option.

Add Strikethrough in Excel Quick Access Toolbar

  • All the commands of Excel will show below the box. Move down the slide bar of that box through your mouse to get the Strikethrough command.
  • Then, select the Strikethrough command, and click the Add button.

  • You will see the command will be added to the empty box on the right side.
  • Below the All Commands box, check the Show Quick Access Toolbar option for displaying the toolbar. You can also choose the toolbar position by selecting the drop-down of the box titled Position. We choose the Below Ribbon option.
  • Finally, click OK to close the window.

Add Strikethrough in Excel Quick Access Toolbar

  • You will see below the main Excel Ribbon a new toolbar is created and it contains only the Strikethrough command.

Add Strikethrough in Excel Quick Access Toolbar

  • Now, select cell B8, and select the Strikethrough command from the Quick Access Toolbar.

Add Strikethrough in Excel Quick Access Toolbar

  • You will see the Strikethrough format is applied on cell B8.

How to Add Strikethrough in Excel Toolbar

So, we can say that our method worked perfectly and we are able to add the Strikethrough command in Excel Toolbar.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to add the Strikethrough command in the Excel Toolbar. If you have any further queries or recommendations, please share them with us in the comments section below.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo