| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Drag option
I have a simple question. Can you turn on/off drag option on a cell? If you
can how? Thx |
|
#2
|
|||
|
|||
|
To turn off the drag option for all cells:
Choose ToolsOptions 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. pcachoi wrote: I have a simple question. Can you turn on/off drag option on a cell? If you can how? Thx -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
| How to protect option button? | Excel Worksheet Functions | |||
| Second option button disappears when I make another column | Excel Worksheet Functions | |||
| Filter option | Excel Discussion (Misc queries) | |||
| What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
