Go to the Tools menu, choose Options, then the Edit tab. There,
ensure that "Allow cell drag and drop" is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Teresa" wrote in message
...
click & drag not working. worked fine for years, but
downloaded a
spreadsheet today for nephew, noticed formulas not working,
click & drag not
working. Tried Tools, Options, Allow cell drag off and on.
Still not
working. Must be able to drag vertically and horizontally!!!!
HELP!