Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy a drop down menu so it appears in each row of a column?
I'm trying to create a spread sheet to enter data into and i've figured out
how to make a dropdown list to simplify data entry. But how can i make the drop down list appear in evey row of a column? I'm an excel newbie! thanks for your help! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy a drop down menu so it appears in each row of a column?
Make your list somewhere and then use Data-Validation-and where it says "any
value" choose "list" and Then choose the source of the list. When you have done this for one cell, copy and then paste special and choose validation. Hope this helps "Vanmessa" wrote: I'm trying to create a spread sheet to enter data into and i've figured out how to make a dropdown list to simplify data entry. But how can i make the drop down list appear in evey row of a column? I'm an excel newbie! thanks for your help! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy a drop down menu so it appears in each row of a column?
Go to your drop-down cell, copy, then go down the row and paste!
"Robert24" wrote: Make your list somewhere and then use Data-Validation-and where it says "any value" choose "list" and Then choose the source of the list. When you have done this for one cell, copy and then paste special and choose validation. Hope this helps "Vanmessa" wrote: I'm trying to create a spread sheet to enter data into and i've figured out how to make a dropdown list to simplify data entry. But how can i make the drop down list appear in evey row of a column? I'm an excel newbie! thanks for your help! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copy a drop down menu so it appears in each row of a column?
Pre-select the range of cells to have the dropdown list.
Then create the DV list dropdown. If you have one created already, just select that cell and a bunch below and DataValidation A mesage will pop up "do you want to extend etc." Click Yes then OK Gord Dibben MS Excel MVP On Mon, 6 Oct 2008 11:16:06 -0700, Vanmessa wrote: I'm trying to create a spread sheet to enter data into and i've figured out how to make a dropdown list to simplify data entry. But how can i make the drop down list appear in evey row of a column? I'm an excel newbie! thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a column of cells have a drop down menu | Excel Worksheet Functions | |||
One value gives different drop menu in next column | Excel Discussion (Misc queries) | |||
How do I copy a drop down menu? | Excel Discussion (Misc queries) | |||
How do I copy a drop down menu? | Excel Discussion (Misc queries) | |||
Adding a Drop down menu to a column | Excel Discussion (Misc queries) |