To create the Month drop down list follow below given steps:-
- Select the cell C3, go to in Data tab select Data Validation in the Data Tools group.
- Data Validation dialog box will appear.
- In Settings tab from the Allow drop down list select List then source tab will get active click on source tab and select the range A2:A13.
- Go to Input Message tab, in Input Message Box type Enter only the month name, the message box will appear near to the cell.
- Go to Error Alert tab and write the message in the box of Error Message Input Error and click on ok
- If you will enter the number instead of month name the pop up will get to appear and give the message what you had entered in Error Message box.
- Copy the cell C3 by pressing the CTRL+C and paste in cell D1, select the cell D1 and right click of the mouse, select Paste Special from the popup.
- Paste Special dialog box will appear, click on Validation Click on ok.
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