Re: How do I set cell drag and drop to be on as a default

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is an application setting that should be remembered after you toggle it.

If it's not being remembered, it sounds like you don't have permission to save
this setting in the windows registry. You may want to complain to your IT folks
and ask them why you can't do this.

But until they fix it, you could have a dummy workbook that opens, changes this
setting, then closes. Put it in your XLStart folder so that it opens each time
excel starts up.

This code would go into a General module:

Option Explicit
Sub auto_open()
Application.CellDragAndDrop = True
ThisWorkbook.Close savechanges:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

*** Morgan wrote:
>
> I often use the cell drag and drop functionality in EXCEL. (eg enter 1 in
> cell a1, 2 in cell a2, select the 2 cells and click on the bottom right
> corner, and drag down will add a sequence of 3 4 5 6 etc in the cell dragged
> to).
>
> My current version of EXCEL 2003 has cell drag and drop in Tools --> Options
> --> Edit set to OFF how do I set to ON as a default.

--

Dave Peterson
.

Quantcast