Results 1 to 3 of 3

Thread: Is it possible to copy/paste a drop down list in Microsoft Excel

  1. #1
    Join Date
    Jan 2004
    Posts
    21

    Is it possible to copy/paste a drop down list in Microsoft Excel

    I have a drop down list in cell A1 and I need to copy and paste that list all the way down to A200. Copying and pasting is not working nor is dragging down the corner of the cell. Help.

  2. #2
    Join Date
    May 2011
    Posts
    410

    Re: Is it possible to copy/paste a drop down list in Microsoft Excel

    There is a easy for that. Copy cell A1 and then select the range A2:A200. Then Goto Edit > Paste Special > Validation > OK.

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    Re: Is it possible to copy/paste a drop down list in Microsoft Excel

    Dragging with the fill handle works for me in 2003. Do you have drag and drop enabled. There is no option to copy the entire drop down list. Somehow the paste special can help you in this.

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2012, 07:08 PM
  2. I need help to update drop down list on Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 3
    Last Post: 28-01-2012, 03:57 PM
  3. How to paste data in filtered list of Microsoft Excel
    By SeanZ in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 01:00 PM
  4. How to do Copy/Paste on protected work sheet in Microsoft Excel
    By Chini mao in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 06:58 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,694,158.36917 seconds with 17 queries