[manu213]

Hi €“ I am using Excel 2003. I am not able to drag formula to successive
cells. Usually when you move the cursor to right bottom corner of the cell
and if the cell is entered with formula then cursor will automatically change
to dragging option. I am not able to get that option with my Excel. I think I
have disabled something unknowingly, which is not allowing me to drag
formula. Please help me to solve this problem.

[T. Valko]

Check this setting:

ToolsOptionsEdit tabAllow cell drag and dropOK

--
Biff
Microsoft Excel MVP


"manu213" wrote in message
...
Hi - I am using Excel 2003. I am not able to drag formula to successive
cells. Usually when you move the cursor to right bottom corner of the cell
and if the cell is entered with formula then cursor will automatically
change
to dragging option. I am not able to get that option with my Excel. I
think I
have disabled something unknowingly, which is not allowing me to drag
formula. Please help me to solve this problem.

[Max]

Try clicking Tools Options Edit tab
Check "Allow cell drag n drop" OK
voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"manu213" wrote:
Hi €“ I am using Excel 2003. I am not able to drag formula to successive
cells. Usually when you move the cursor to right bottom corner of the cell
and if the cell is entered with formula then cursor will automatically change
to dragging option. I am not able to get that option with my Excel. I think I
have disabled something unknowingly, which is not allowing me to drag
formula. Please help me to solve this problem.