Category: microsoft excel
How to add a drop down data set in excel
- 0
I wanted to add a dropdown data set which can be picked for a cell instead of the manual entry. This can be achieved in excel very easily. Here’s how to do it: Method 1: Using a Comma-Separated List Select the cell or range of cells where you want the drop-down list to appear. Go to…
Read More
Formula to count the blank cells in excel
- 0
When I was working on some data calculations in a excel sheet, we had a situation to count the blank number of cells in a range of rows. There are lot of statistical formulas available in excel Here is the one formula which can be used to achieve this. and We can see how can use…
Read More