• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto fill : Need Help

S

senthilkumar_rm

Member
Hi Solvers


When i drag auto fill option is not visible ( That "+"sign usually appears in bottom right corner of cell and it is used for draging formulas and numbers )


Where can i found the option to sort it down -


Ps : In 2003 & 2007
 
HI Senthil,


Sorry, currently I don't have Excel proposed version.. :)

Can you please go to VBA (Alt + F11) >> Immediate Windoe (Ctrl + G)

and type


Code: 
Application.CellDragAndDrop = TRUE


It will solve the problem.

Regards,

Deb
 
Hi Senthil,


I got it..

Tools > Option > Edit > Allow Cells Drag & Drop (CheckBox)


http://www.hotexcel.com/wp-content/uploads/2010/11/MS-Excel-2003-enable-AutoComplete-feature.jpg


Regards,

Deb
 
In 2007


Check Enable Fill handle...

http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/To_Turn_On_Autocomplete_Option___Click_Advanced_Select_Enable_Autoco.PNG
 
You must log in or register to reply here.
Back
Top