Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 17, 09:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default Default value for drop down list?

I just saw this today and had the same issue. An easy fix or hack that may not be too dynamic is to just add "Select Item" as one of the items on the range.
This works if you are starting off and you choose the "Select Item" text from the drop down menu and then copy it down.
I know it doesn't solve dynamic issues but it was a simple fix for my template.

Thank you.
Miguel

On Thursday, November 7, 2002 at 2:42:08 PM UTC+1, Mary Birrell wrote:
This seems pretty basic, but I cannot seem to find
information in Excel Help or when I searched this News
Group...perhaps I'm searching wrong!?

My QUESTION: How do you set a drop down list (which is
created using data validation) to be populated with a
default value?

What I want to do: I want to 'prod' the user to "select"
a value from a list. For example:

I have a list called "Regions". Valid values a

(Select Region)
AP
Canada
EMEA
Japan
LA
US

I do data-validation in a cell, using the LIST option and
referring to my list. I want to default the value in the
drop down box to the first value in the list, "(Select
Region)". How do I get excel to allow me to default a
value from my list in the drop down box? I have seen
this in other spreadsheets, but cannot tell how it was
done...

Any help would be appreciated!
Thanks.



  #2   Report Post  
Old October 3rd 17, 06:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2017
Posts: 1
Default Default value for drop down list?

^^ This worked great. Thanks!
  #3   Report Post  
Old April 19th 19, 08:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 1
Default Default value for drop down list?

On Tuesday, October 3, 2017 at 10:16:06 AM UTC-7, wrote:
^^ This worked great. Thanks!


yup!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default to Top of Drop Down List Anita Excel Worksheet Functions 5 December 6th 06 11:22 PM
Setting default values in a drop down list in excel? Dave Excel Discussion (Misc queries) 2 May 18th 06 07:33 AM
Default Cell Value with Validation Drop-Down List Dave H Excel Discussion (Misc queries) 0 January 30th 06 08:58 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
drop down list default Justin VN Excel Worksheet Functions 2 December 21st 04 08:00 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017