Excel Tips

Checkbox in excel is a very handy tool for creating the checklist or simple user forms. There is no need of any Excel VBA knowledge to insert Checkbox into a excel sheet. This is increase the speed at which user enters data as well as it reduces the chances of misspellings which will give trouble [...]

At times, in Excel worksheet the first row(Row 1) or first column(column A) doesnot show up. It is tricky to unhide  the first row or column as there is no easy way to do it. Based on the situation, you need to apply different method to access the first row or column. So here is the quick [...]

In today excel tip let us discuss on how to remove leading space and trailing space in a cell of Excel worksheet.  By default there are three excel functions which are very useful in removing the space in a cell. The Excel function we are going to use cleanup the cell are CLEAN, TRIM and [...]

There are many situation where we need to find the maximum and minimum in a range. Like many other worksheet functions, finding the maximum and minimum also there is a direct functions available. Let us have a quick look into the maximum and minimum excel worksheet functions.Finding Maximum in a range using the Excel worksheet [...]

VLOOKUP in Excel Tips and Tricks

We already learned on how to use VLOOKUP in Excel.  In my earlier different posts, i have shown, the different ways you can use vlookup functions. This post is the summarisation all the things which we have already discussed. VLOOKUP in Excel Tips and Tricks Here is the list of few VLOOKUP in Excel tips [...]

In my earlier post, I have shown you how to create a simple drop down list in Excel. But meets most of our day to day requirements. However, when we create a dashboard or a template, we need to dependent drop down list or a conditional drop down list in Excel. That is based on [...]

1 2 3 4 8 9