Avail 20% discount on updated CA lectures for Dec 21 .Use Code RESULT20 !! Call : 088803-20003

ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

ABHINANDAN JAIN (CA Student)     01 July 2011

Want help in MS Excel regarding formula dragging

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...



 4 Replies

Deepak Gupta

Deepak Gupta (CA Student)     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

Data entry (sales)     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.

data entry india

ABHINANDAN JAIN

ABHINANDAN JAIN (CA Student)     03 July 2011

solved:

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

Sambhav Gupta

Sambhav Gupta (AVP)     20 July 2011

Thanx a lot


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Start a New Discussion

Popular Discussion


view more »







Subscribe to the latest topics :
Search Forum:

Trending Tags