Excel - Drop-down list for entering the same data in multiple cells

K

kevin muniz

once you have created one drop down list right click it
to highlight and then select copy. go to where you want
it inserted and right click again and click on paste. It
will make an exact copy of the first cell. after you have
them all created I would recommend holding down control
and right clicking all of them again until they are all
selected and then right click on one of them and select
the group option of the menu. this will allow you do
move and resize etc as a group. It is a pain to do this
individually later.....hope that helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top