Prev: Pivot table format on paste values
Next: Excel sluggish performance
From: SandieB SandieB on 21 Mar 2010 11:20
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!

From: מיכאל (מיקי) אבידן on 21 Mar 2010 12:10
Maybe:
Tools > Options > Edit > allow cell drag and drop > OK
Micky


"SandieB" wrote:

> 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!
>
 | 
Pages: 1
Prev: Pivot table format on paste values
Next: Excel sluggish performance