When copying a cell that contains validation criteria to a different cell, the criteria are copied along with the text formula and format. If you want to copy only the validation criteria, use Paste Special.
Paste Special: You can use the Paste Special to paste the specific cell content or attributes such as formula, formatting, comments etc.
Let’s take an example and understand how we can copying and pasting the validation list only in Microsoft Excel.
I have a table of month in Column and we want to create drop down list in cell C3.
To create the Month drop down list follow below given steps:-
This is the how we can update the drop down list from one cell to another cell by just clicking the copy the cell and use the Paste special function in Microsoft Excel.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.