Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Drop down boxes in Excel 2007

Can anyone tell me how to create a drop down box in Excel 2007, which would
allow me to select from a variety of choices?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 533
Default Drop down boxes in Excel 2007

Try Data Validation on the Data tab. Select the "List" option. Have a list
of the items you want to appear in the drop down already entered somewhere.

--
Jim
"Shannon" wrote in message
...
Can anyone tell me how to create a drop down box in Excel 2007, which
would
allow me to select from a variety of choices?



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
Using List Drop Boxes in Excel shellydd Excel Discussion (Misc queries) 1 September 26th 06 02:09 PM
Drop down boxes in Excel colt Excel Discussion (Misc queries) 1 October 3rd 05 07:07 PM
Excel Drop Down Boxes CRS Excel Discussion (Misc queries) 1 September 21st 05 03:45 PM
Can I use drop down boxes in pocket excel? Kman Excel Discussion (Misc queries) 0 August 30th 05 05:27 PM
Drop Down Boxes in Excel Excel Discussion (Misc queries) 2 April 15th 05 01:33 PM


All times are GMT +1. The time now is 09:55 PM.

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

About Us

"It's about Microsoft Excel"