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