Not able to drag formula to successive cells
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. |
Not able to drag formula to successive cells
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. |
Not able to drag formula to successive cells
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. |
All times are GMT +1. The time now is 09:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com