Pinterest Pixel

Add Calculator in Excel to the Toolbar

You might have found using the Windows in-built Calculator in Excel when you want to do some... read more

Bryan
Posted on

Overview

You might have found using the Windows in-built Calculator in Excel when you want to do some quick and basic calculations that did not require formulas. Many of the times, the Calculator app and Excel go hand-in-hand.

Did you know that instead of scrambling for the Calculator Application, you can actually have a Calculator in Excel itself!

Excel has a lot of customizations and one handy tool is to include the Calculator in Excel toolbar.

Add Calculator in Excel to the Toolbar | MyExcelOnline

You can literally place it on your Excel window, and it is very easy and handy to open it whenever needed:

Add Calculator in Excel to the Toolbar

Adding Excel Calculator to the Quick Access Toolbar would save you a lot of time and could prove to be extremely helpful.

Quick Access Toolbar (QAT) is located at the top-left portion of the Ribbon where you can access the commonly used functions and commands of Excel. To learn more about how to use QAT, go through the tutorial here.

Add Calculator in Excel to the Toolbar

By default, the only options available in QAT are Save, Undo, and Redo. But, it can be customized individually by Excel users. So, if you are one who frequently uses Calculator App with Excel. Adding a calculator to your QAT would be a perfect step!

In this tutorial, you will learn the following:

 

 

How to Add Calculator to QAT

The steps for how to create a calculator in Excel are very straightforward. They are outlined below:

STEP 1: Go to the top-left corner of the Excel Ribbon and click the down arrow on the Excel Toolbar.

Add Calculator in Excel to the Toolbar

STEP 2: From the drop-down menu, select More Commands from the list.

calculator-in-excel-01

STEP 3: Select Commands Not in the Ribbon.

Add Calculator in Excel to the Toolbar

 

STEP 4: Scroll down and select Calculator.  Click Add. 

Add Calculator in Excel to the Toolbar

 

STEP 5: Click OK.

Add Calculator in Excel to the Toolbar

 

STEP 6: Your Calculator icon is now ready.

Add Calculator in Excel to the Toolbar

This will add the Calculator option to the Excel Quick Access Toolbar. Give it a try!

 

 

How to Remove Calculator from QAT

Now that you know how to make a calculator in excel, you should also learn how to remove it from the QAT. Follow the steps below to do so:

STEP 1: Go to the top-left corner of the Excel Ribbon and click the down arrow on the Excel Toolbar.

Add Calculator in Excel to the Toolbar

STEP 2: From the drop-down menu, select More Commands from the list.

Add Calculator in Excel to the Toolbar

STEP 3: Under Customize Quick Access Toolbar, select Calculator and click on Remove.

Add Calculator in Excel to the Toolbar

STEP 4: Click OK.

Add Calculator in Excel to the Toolbar

This brings us back to the original QAT composition.

Add Calculator in Excel to the Toolbar

 

 

How to Use Calculator in Excel

This calculator tool is an extremely useful tool and does a lot more than just addition and subtraction. There are 4 modes available to use – Standard, Scientific, Programmer, and Date Calculation.

Add Calculator in Excel to the Toolbar

  • Standard – It is used for basic math calculations like add, subtract, divide, multiple, finding square root, calculating percentages, and working with fractions.
  • Scientific – It is used for functions like log, modulus, exponent, trigonometric degrees, sin, cos, tan, etc.
  • Programmer – It is used to switch between different number systems—binary, decimal, hexadecimal, and octal.
  • Date Calculation – It is used to calculate the difference between two specific dates.

 

Now, let’s give it a try and learn how to use a Calculator in Excel.

Say, you have to input the difference between two dates – 12th April 2020 and 2nd June 2020 in cell A2 without using any Excel formulas.

Step 1: Click on the calculator icon in QAT

Add Calculator in Excel to the Toolbar

Step 2: Click on the menu button at the top left and then select Date Calculation.

Add Calculator in Excel to the Toolbar

Step 3: Insert the two dates – 12th April 2020 and 2nd June 2020

Add Calculator in Excel to the Toolbar

Step 4: The difference between the two dates will be displayed.

Add Calculator in Excel to the Toolbar

Conclusion

In this tutorial, you have learned how to add a calculator in Excel toolbar and use it alongside with Excel. You can also use the calculator using macros instead of adding it in the Quick Access Toolbar.

 

Further Learning:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Add Calculator in Excel to the Toolbar | MyExcelOnline

You can learn more on how to use Excel by viewing our FREE Excel webinar training on Formulas, Pivot Tables and Macros & VBA!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Add Calculator in Excel to the Toolbar | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!