In our last post about Finding duplicates in Excel, we created a clever formula to find only single instance of a duplicate value using the concept of Excel absolute references. In that post, we were unable to discuss further Absolute and Relative references, but today we will understand what these references mean.Excel Relative … [Read more...]
Find and Delete Duplicates in Excel – The Ultimate Guide
While working with huge data tables in Excel there are times when your data may contain duplicate records.To eliminate the confusions that duplicate records may result in and to avoid an unnecessary increase in the physical size of the spreadsheet it is better to find and remove the duplicate records.Today I will be sharing five easy and … [Read more...]
How to Unhide Columns in Excel
While doing data analysis in excel you would have noticed that all the data is not important for the end user (can be your boss).Some of the columns are used merely for calculation purpose and that’s why it’s better to hide these columns as they create un-necessary confusions.But now when it comes to unhide these columns, there are few … [Read more...]
How to Find Cells containing Formulas in Excel
A few days back I had a huge spreadsheet in which I had to find out the cells containing formulas. Initially, I was totally clueless about how this task can be done.But later after doing some Google searches, I got a few ideas on how I can effortlessly identify the formula cells in excel.And today to share my experiences with you guys, In … [Read more...]
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...]
