When you open an excel file that have macro or macros, a warning appears to enable macros in excel file. The macros are used to automate the tasks that the user needs to perform repeatedly. The macros are created by recording a sequence of commands over a cell in a file. The macro once created, can be run over any cell/cells when you have to perform the desired task. Most of the macros are … [Read more...]
How to Add or Sum in MS Excel 2016?
Adding is a basic mathematical operation, and is often used during the mathematical calculations. You have a variety of method to add or sum in Excel. One of the popular method to add in excel is AutoSum. It generates the sum of two or more cells in a sheet quickly. In this section, we will discuss the other options which can also be used to add the cells in excel 2016. We will discuss how we … [Read more...]
How to Convert Text to Number in MS Excel 2016?
In this section, we will see how you can convert text to number in Excel. Excel allows you to choose the format for your cells such as you can keep the format of your cell as Date, Time, % Percentage, Fraction, Text, Number etc. If your cell is in Text format it generates an unexpected result for mathematical formulas. Like, look at the picture below, in a cell, I have written a formula =12+4 … [Read more...]
How to break Links in MS Excel 2016?
In the previous article, we learned to create a link in MS Excel 2016. Now if you do not need the links anymore, break the link between the source and referencing workbook. This article explains the steps to break links in MS Excel 2016. Remember once you break a link between source workbook and referencing workbook, the link/formula will convert to the current value of the cell. And most … [Read more...]
How to create Links in MS Excel 2016?
MS Excel allows you to create a link between two worksheets of the same workbook, or between two different workbooks. The beauty behind this linking is that if you modify the original data, you will also experience modification in your linked data as well. In this article, I have explained the steps to create links in MS Excel 2016. Steps to create Links in MS Excel 2016: Step 1: Select the … [Read more...]
How to use VLOOKUP in MS Excel 2016?
VLOOKUP is a function that helps you to find the thing from a table array, the data you stored on the spreadsheet. There are four parameters in the VLOOKUP function. Let us start with the steps of How to use Vlookup in MS Excel 2016? Steps to use Vlookup in MS Excel 2016: The data I have, contains the number of copies of an XYZ book sold in each month from the year 2011 to 2015. Step 1: … [Read more...]
How to Sort Data in Ms Excel 2016?
Sorting comes in a frame when we need to arrange data in a certain fashion i.e. smallest to largest or vice-versa. You can also create your own order for sorting data. So let us move on How to Sort Data in Ms Excel 2016 ? Steps to Sort Data in Ms Excel 2016: Step 1: Select the cell to which you want to apply sorting operation. Like, I selected the cell below Total. Inside Home tab, under … [Read more...]
How to Transpose in MS Excel 2016?
Transpose is an array function i.e. it is applicable to arrays. There are two methods to perform the transpose first is Paste Special method, second Transpose function. The drawback with Paste special method is that if we perform any change in the source data it does not reflect in the transposed data. But if you are using Transpose function and perform any change in the source data it will … [Read more...]
How to Delete Macro in MS Excel 2016?
Macro is an action or group of actions that is recorded, and it can be played back again as many times as required. The actions in macro can be a keystroke, mouse movements, typing text, or modifying text. In this article, we will discuss How to Delete Macro in MS Excel 2016? If you want to delete a macro that belongs to Personal Macro Workbook. Then you need to first unhide the workbook to delete … [Read more...]
How to Create Macros in MS Excel 2016?
Suppose you are working on Excel, and repeatedly you have to perform the same actions. Then you can create a macro for that and use it as many time in the worksheet. A macro record the actions, it can be a mouse click, keystroke, or modification in a font, etc. Creating macro saves time. So let's move towards the steps of How to Create Macros in MS Excel 2016? Steps to Create Macro in MS Excel … [Read more...]