software

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

Go to the Tools menu, choose Options, then the Edit tab. There,
ensure that quot;Allow cell drag and dropquot; is checked.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Teresaquot; gt; wrote in message
news
gt; click amp; drag not working. worked fine for years, but
gt; downloaded a
gt; spreadsheet today for nephew, noticed formulas not working,
gt; click amp; drag not
gt; working. Tried Tools, Options, Allow cell drag off and on.
gt; Still not
gt; working. Must be able to drag vertically and horizontally!!!!
gt; HELP!
Does the problem exist with all Excel files, or just this new one........if
just this new one, then the file is probably at fault......you might try the
new file on another machine to see if it works ok there.....

Vaya con Dios,
Chuck, CABGx3quot;Teresaquot; wrote:

gt; click amp; drag not working. worked fine for years, but downloaded a
gt; spreadsheet today for nephew, noticed formulas not working, click amp; drag not
gt; working. Tried Tools, Options, Allow cell drag off and on. Still not
gt; working. Must be able to drag vertically and horizontally!!!! HELP!