RECOMMENDED: Click here to fix Windows errors and optimize system performance
Microsoft Office operates an online store that offers extensions for Office applications such as SharePoint, Word, PowerPoint and more. These applications help you personalize your documents or speed up your work in progress. With an application, for example, you can add an online map to your document without having to exit Excel 2013 or perform basic operations such as adding, subtracting, and so on. If you find performing basic addition tasks, multiplication in Excel tedious as a standard method, here is an application that will help you do the job quickly – Range Calculations app from Ablebits.
The free tool performs calculations such as multiplying or dividing a range by a value or adding or subtracting a value from a range. In addition to addition and subtraction, the Range Calculations application is also capable of adding or subtracting percentages to a range.
Although you can do the same with Excel Paste Special options, beginners often fight at first. The application requires that you simply select the field, the type of calculation and the value you want to work with, and then it does all the work.
When you click the Calculate button, you are warned that formulas in the range will be overwritten with values after processing. When prompted, click Yes to continue or Cancel to complete the operation.
To use the application, open the Excel workbook, click’Paste’ and select the’Apps for Office’ section.
Then enter the application name in the Office App Store search field.
If found, click’Add’.
After adding the application to Excel 2013, you can see a number of options that the application has to offer in the right pane.
If you do not want to use an application for Excel, hide it so that it does not appear in your list of applications. If you want to use the application again later, you can call it. To do this,
Click Insert > Office Applications. Click Manage My Applications.
If you don’t see’Manage my applications’, click on’My applications’ under’Office Applications’.
Locate the application in the list and click Hide under Action. You must log into your Microsoft account to perform this step. To see the applications you have hidden, click Hidden next to Show.
Hope this helps!
RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance