G Guest Apr 26, 2005 #1 I have a simple question. Can you turn on/off drag option on a cell? If you can how? Thx
D Debra Dalgleish Apr 26, 2005 #2 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.
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.
