Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Francisco
 
Posts: n/a
Default How can i create in one cell scroll-down different options?

Hi there
I am working in excel and I would like to create like a menu/scroll-down in
one cell with different options (like including kind of transport, train,
airplane, car, etc...) where you have an arrow on the right side and you can
choose one of the options given.

Thanks for your help.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html

Francisco wrote:
Hi there
I am working in excel and I would like to create like a menu/scroll-down in
one cell with different options (like including kind of transport, train,
airplane, car, etc...) where you have an arrow on the right side and you can
choose one of the options given.

Thanks for your help.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
I want to be able to scroll smoothly rather than one cell at a ti. blueboy Excel Discussion (Misc queries) 2 February 27th 05 12:01 AM
Can I create a cell that will count by one every time I print the. Tyler Hopfner Excel Worksheet Functions 1 February 7th 05 06:10 PM
Problem with IF condition or vector lookup? J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM
How to create thin cell border Dale Fox Excel Discussion (Misc queries) 4 December 7th 04 04:37 AM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 08:55 PM


All times are GMT +1. The time now is 01:21 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"