Lost functionality to copy a formula across rows

S

SandieB

Recently I lot the functionality to copy a formula across a group of cells.
Normally clicking on the cell will give you a "handle" to allow you to drag
across a range of cells. At work we are currently using the 2002 Excel and I
had this functionality until just recently. I have been getting several
worksheets from other sources--could there be a problem with compatibility?
I note that even my older spreadsheets lost this functionality.

Help!
 
×

מיכ×ל (מיקי) ×בידן

Maybe:
Tools > Options > Edit > allow cell drag and drop > OK
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Formula fill across workbooks 3
Require formula to search across multiple worksheets 2
Copy formula where the cell refrence is not sequential 1
how to copy a formula to other cells-any shortcut 5
how can I copy/paste a formula that skips 27 rows? 0
copy formula 2
Copy and Paste Formulas 0

Top