Create a drop down list

Resolved · Low Priority · Version 2010

Thu 17 Nov 2011, 11:44 Delegate Gurdeep said...

Gurdeep has attended:
Excel Advanced course

Create a drop down list

excel drop down list

Thu 17 Nov 2011, 17:06 Trainer Paul said...

RE: create a drop down list

Click in your cell

Select
>Data
>Data Validation
>Choose List
>Go to the source box and either enter your named range, ie, =namerange or manually find the list you want to show.

Hope that helps.

Thanks
Paul

Wed 23 Nov 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips