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...
Menu
Want help in MS Excel regarding formula dragging
Replies (4)
| 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
Recent Topics :
- Pos related issue
- Gift of unlisted shares to friend upon marriage
- Utilising Section 54(F) for capital gains reinvest
- GST ewaybill closure and Bill to ship to GST numbe
- TDS ON PARNTER INTEREST
- Share important chapters of ca inter costing
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
Related Topics :
CAclubindia
