Drag option

P

pcachoi

I have a simple question. Can you turn on/off drag option on a cell? If you
can how?

Thx
 
D

Debra Dalgleish

To turn off the drag option for all cells:

Choose Tools>Options
On the Edit tab, remove the check mark from 'Allow cell drag and drop'
Click OK

Or, if you only want to protect one cell, you could lock the cell,
unlock other cells, and protect the worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top