I have tried to search for the answer but could not quite find what I was
looking for. I have a spreadsheet which have cells that have a drop down box
which allows the user to select four choices. I need to insert rows, which
contain a lot of formulas along with the cell for the drop downs. When I
insert my rows, I can drag the formulas down-no problem. But, I lose the drop
down box capability in several cells. I did not create this spreadsheet so I
don't know how the drop downs were created. When I right click on the cell, I
get this in this order: Cut, Copy, Paste/ Paste Special are greyed out,
Insert, Delete, Clear Contents, Insert Comments, Format Cells, Pick from
List, Add Watch, Hyperlink.

I don't (know how) want to add a new one as there are formulas whose outcome
is based on the choice a user makes. It is a very complicated spreadsheet.
Is there any help for me? Thanks!
Karen