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

Issue with Auto fill

A

arj

New Member
Hi,


Recently a problem has developed in Excel 2007 . I can't auto fill number in the cells, "+" sign is not appearing when I select the cell.


Also in page break view I can't drag the the break link.


I re installed excel in my system but this problem is as it is.


Please help in resolving this.


Thanks in advance.
 
Hi arj,


Welcome to the forum, when you select the cell, hover over the little black square, hold the Ctrl key and the "+" sign will appear, then drag down
 
Hi Arj,


If you are not able to see "+" sign when you select cell, then here is solution I think should help you:


Excel > Options > Advanced > under Editing options (first one), Check the 3rd option which states "Enable fill handle and cell drag-and-drop


This should bring back "+" sign on cells and :-) on your face.


Regards,

Prasad DN
 
You must log in or register to reply here.
Back
Top