microsoft excel 2003 vba courses - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel 2003 vba courses - Excel

microsoft excel 2003 vba courses - Excel

resolvedResolved · Low Priority · Version Standard

Excel

How do I create a drop down list?

RE: excel

You can do this by using DATA > VALIDATION

Choose LIST from the ALLOW menu, and then type your list of data, separated by commas.


 

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Server loaded in 0.09 secs.