+ Reply to Thread
Results 1 to 1 of 1

Drag down not working for drop down list once sheet is protected

  1. #1
    Registered User
    Join Date
    05-14-2021
    Location
    Queensland, Australia
    MS-Off Ver
    MS Office 365
    Posts
    1

    Drag down not working for drop down list once sheet is protected

    Hello, I have an intermediate knowledge of Excel but am having issues with using the drag down in a drop down list once I have protected the sheet.

    Before I protect the sheet, you can select from the drop down list in one cell and then drag this down to the below cells. You can see this in the attachment "Animal Form" in columns labelled 1 through to 5.

    However, when I protect the sheet this option is no longer available. See attachment "Animal Form - protected". You can use Ctrl D to fill the cells but would prefer the drag down option.

    Does anyone have a fix for this?

    Thank you.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Protected cells and drag-and-drop
    By Angus in forum Excel General
    Replies: 6
    Last Post: 12-02-2019, 05:47 PM
  2. Drop Down List in Protected Sheet
    By Lacey87 in forum Excel General
    Replies: 0
    Last Post: 02-21-2019, 10:43 PM
  3. Replies: 1
    Last Post: 11-03-2018, 04:26 PM
  4. [SOLVED] WOW : Multiple-Selection-from-a-Drop-Down-List IN PROTECTED SHEETT is working GOOD
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2017, 12:34 AM
  5. Replies: 1
    Last Post: 04-04-2017, 12:24 AM
  6. Need access to drop down list on protected sheet.
    By tbeat in forum Excel General
    Replies: 2
    Last Post: 02-15-2017, 04:54 PM
  7. Drop down list is Unprotecting my protected sheet
    By chrisowen in forum Excel General
    Replies: 1
    Last Post: 01-17-2017, 01:36 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1