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

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details