How to Make a Drop Down List In Excel

Drop down list is a tool that can help you to force users into selecting a specific value from a predefined set of values. It is always good to have drop down lists for accepting user inputs.This approach is better because it validates each input from user against a predefined set of values and hence users can only input valid and excepted … [Read more...]

How to Enable Macros in Excel

Macros can be defined as a set of instructions that can be used to perform some specific tasks in Microsoft Office applications. The availability of macros is very helpful for the users as they can create user defined programs and functions specifically designed to perform their tasks.Although macros are so useful, but if misused they can play … [Read more...]

Find Merged Cells in Excel

There are times when you try to sort a column in your spreadsheet and it throws an error saying that, “To do this, all merged cells should be of same size”. As you can clearly see that this issue is due to the presence of merged cells in the column to be sorted.  To resolve this issue you simply need to find the Merged Cells present in the … [Read more...]

How to Hide Formulas in Excel

Using formulas in excel can make your day to day tasks easier. Excel provides formulas for just about anything. But if you are sharing your spreadsheets with other people then it looks quite rude to write formulas as it is.  All the formulas and the calculation stuff should be hidden from the viewers. The best way to do this is to hide … [Read more...]