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...
ABHINANDAN JAIN (CA Student) (886 Points)
01 July 2011i 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...
Deepak Gupta
(CA Student)
(15922 Points)
Replied 02 July 2011
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
Data entry
(sales)
(24 Points)
Replied 02 July 2011
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.
ABHINANDAN JAIN
(CA Student)
(886 Points)
Replied 03 July 2011
solved:
Go to Tools--Optons---Edit---Tick Allow cell drag and drop-click OK