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...]

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...]

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...]

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...]

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...]

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...]

Sometimes you have to share the Excel sheet with some other users also. Like, you have created an entire years surveillance data of the company and wanted your juniors to mark their remark on it. At the same time, you don't want your data to be hampered or changed in any way.  Then, you must protect the cells containing the important data. Sometimes you even want to protect the entire sheet from … [Read more...]

Suppose, you have an Excel sheet that contains a lot of data. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. It will make no sense of reading data without headings. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. The best way to retain rows and columns is … [Read more...]

In case you have entered some information in a single cell in Excel, and you want to split the text into separate columns then  MS Exel has provided an easy way to split the text in a cell. So let us begin with How to Split  Text in a Cell in MS Excel 2016? Step to Split Text in a Cell in MS Excel 2016: Step 1: First select the cells, whose text you want to split. You can observe in the image … [Read more...]

To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of  How to Create a Drop-Down List in MS Excel 2016? Steps to Create a Drop-Down List in MS … [Read more...]