Excel drop down list - replace existing cells with drop down list

ashley1984

New Member
Joined
Mar 31, 2018
Messages
13
Hi,

I've got a long list of data with a set of ingredients/proteins e.g. Burger, Chicken, Sausage, Bacon etc. I've inherited the document with the data and i'm looking to make some improvements, including a drop down list. Creating the drop down list is not an issue, its when I try to replace cells with ingredients already in the cell with the drop down list I run into an issue.

I've created the drop down list in the first cell which has burgers in it and the drop down list selects burgers which is great, however when I copy the drop down list down to a cell that has chicken the drop down list replaces chicken with burgers. How can I make sure the drop down list automatically selects what was in the cell before? E.g.

A1 = Burgers
A2 = Burgers
A3 = Chicken - when I copy down the drop down list from A2 it replaces chicken with Burgers

Thanks
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

mse330

Well-known Member
Joined
Oct 18, 2007
Messages
697
Office Version
  1. 365
Platform
  1. Windows
Hey Ashley,

Copy the first cell with the data validation, select the range then right click paste special -> validation
 

Watch MrExcel Video

Forum statistics

Threads
1,114,255
Messages
5,546,801
Members
410,759
Latest member
Bufnercash
Top