| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill or dropdown box help
I need an easy way of entering predefined text into cells. I have 4
cells on each of my worksheets that I contunally enter one of 5 different words. Is there a way to have a dropdown list in a cell or have an autofill based on 5 predefined words? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill or dropdown box help
You could have a drop down in each cell or a macro taking the dropdown to
the active cell -- Don Guillett SalesAid Software "gtslabs" wrote in message oups.com... I need an easy way of entering predefined text into cells. I have 4 cells on each of my worksheets that I contunally enter one of 5 different words. Is there a way to have a dropdown list in a cell or have an autofill based on 5 predefined words? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill or dropdown box help
Go to
Highlight the 5 cells Data --- Validation Then select Lists and input the source range of your list. You can also use combo boxes "gtslabs" wrote: I need an easy way of entering predefined text into cells. I have 4 cells on each of my worksheets that I contunally enter one of 5 different words. Is there a way to have a dropdown list in a cell or have an autofill based on 5 predefined words? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| Can a dropdown list be used to autofill data in more than one colu | Excel Worksheet Functions | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| How do I create a dropdown within a dropdown? | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Linear Mode
