Autofill or dropdown box help

  • Thread starter Thread starter gtslabs
  • Start date Start date
G

gtslabs

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?
 
You could have a drop down in each cell or a macro taking the dropdown to
the active cell
 
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
 
Back
Top