I use a password protected worksheet that I have created, and I need to be
able to drag the contents of cell A1 (for example) as far as Cell A21 on some
occasions so that they show the same content. , and once I have password
protected the sheet I can no longer do this. I know I could select A1 and
copy then select the cells I need and then paste, but I have created this for
others to use and they are all used to dragging a cell. It wouldn't occur to
them that they can copy and paste. Th problem happened when I put a password
on the sheet. Up to that point I could drag the cells. I've checked the
options and they still show that the option to drag is available, but I can't.

I'd be grateful for any help I can get.

Thank you

Steve