Want help in MS Excel regarding formula dragging

Originally posted by : ABHINANDAN JAIN
	i want to drag a formula but in my excel sheet dragging symbol sign whch comes at d corner of a cell or box is not showing, wht to do now.. pls solve its urgent...

If you are using Excel 2007

> Click on MS Office button at the top left corner of your screen

> Click on Excel Options

> Click on Advanced Tab

> Check the box, Enable fill handle and cell drag and drop

> Ok

Originally posted by : Deepak Gupta
	Originally posted by : ABHINANDAN JAIN i want to drag a formula but in my excel sheet dragging symbol sign whch comes at d corner of a cell or box is not showing, wht to do now.. pls solve its urgent... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} If you are using Excel 2007 > Click on MS Office button at the top left corner of your screen > Click on Excel Options > Click on Advanced Tab > Check the box, Enable fill handle and cell drag and drop > Ok

I thing My Suggestion copy all data select the new sheet  and delete old sheet solve esaily problem.

data entry india

solved:

Go to Tools--Optons---Edit---Tick Allow cell drag and drop-click OK
 

Thanx a lot