Forum Discussion
Locking a Row...Excel hates me
Ok, I'll try to provide as much information as I can so you can conceptualize what I'm trying to do and, hopefully, help me PLEASE. I have an Excel spreadsheet with Columns from A-J and Rows from...
Select A2:J45 (or to the last used row).
On the Insert tab of the ribbon, click Table.
In the dialog that appears, make sure that the check box "My table has headers" is ticked, then click OK.
 
Select A2:J45 (or to the last used row).
On the Insert tab of the ribbon, click Table.
In the dialog that appears, make sure that the check box "My table has headers" is ticked, then click OK.
 
- OMG it's so beautiful!! Thank you so much!! It put in the dropdown menu and now it's behaving like I wanted it to!!
- I have a follow up question I'm hoping you can also help me with, since you are already familiar with what my table looks like. I want one column to have very specific entry options. So, Column D I want the only options to be 'yes' 'no' 'maybe' 'n/a' so nothing else can go in that Column besides those options. But I want to be able to choose more than one option per cell. So, for example D4 may have 'yes' D5 may have 'no' and D6 may have 'yes' 'n/a'-how can I do that??
Excel doesn't have built-in support for that - it requires some VBA trickery. See Excel Data Validation - Select Multiple Items
