LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can create dropdown lists in Word by using the Drop-Down Form Field
tool on the Forms toolbar. However, you won't be able to copy and paste
this into Excel.

In Excel, you can create dropdown lists by using the combobox from the
Forms toolbar, or from the Control toolbox.

You may find them more difficult to use than data validation lists.

abfabrob wrote:
Can I create a drop down menu in Word (I have no idea how to), then cut and
paste into Excell?

"abfabrob" wrote:


I can create a drop down menu by clicking data and then validation, but when
I click in another cell, the drop down arrow (next to the cell) disappears.
Is there a way to keep that arrow on display, regardless of which cell you
click in? So that it is always obvious that there is a drop down menu?



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



 
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
Drop down menus Please help Excel Discussion (Misc queries) 1 January 29th 05 07:05 PM
How do you create dual drop down menus in excel 2000? Phlashh Excel Discussion (Misc queries) 1 January 11th 05 08:56 PM
Adding drop down menus to a spreadsheet angiejoe Excel Worksheet Functions 1 January 3rd 05 09:14 PM
Drop Downs Menus GBH99 Excel Worksheet Functions 4 December 10th 04 02:48 PM
how do you create drop down menus for individual cells in excel? Frosty1 Excel Worksheet Functions 2 November 15th 04 11:02 PM


All times are GMT +1. The time now is 12:10 AM.

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

About Us

"It's about Microsoft Excel"