View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Using fill handle - validated cell - protected sheet

Probably easier to use your arrow keys to select thecell, copy, highlight
where you want the validation cells and paste.

"Matt" wrote:

I want to be drag a cell down. This cell is set up for validated entries only
(typed or from a list). The cell is not locked, yet when the worksheet is
protected I can not access the fill handle. When the sheet is not protected I
can get to the fill handle, although it is partially blocked by the
validation handle.

Help please.