Forum Discussion
Solved
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!!