B
Browniris
I am making a data-entry spreadsheet. I have a drop down menu for each
column, and I want to copy that drop down menu and paste it in each cell for
that column. When I have tried to follow instructions on excel (copy, paste
special, check validation), the top item in the menu is erased. It looks like
the range is changing in each cell (i.e. =F1:F6 in F16 goes to =F2:F7 in F17,
then =F3:F8 in F18). How can I copy my drop down menu and keep it the same
for each cell?
Thanks for your help!
column, and I want to copy that drop down menu and paste it in each cell for
that column. When I have tried to follow instructions on excel (copy, paste
special, check validation), the top item in the menu is erased. It looks like
the range is changing in each cell (i.e. =F1:F6 in F16 goes to =F2:F7 in F17,
then =F3:F8 in F18). How can I copy my drop down menu and keep it the same
for each cell?
Thanks for your help!