Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using excel 2007. When I have put dates in the "A" column, I have to write all the dates way down to 31st of the month. While using the mouse, one can write the first date of the month & then scroll the cell from bottom right side of the cell. My problem is that I can't scroll down, as the plus sign doesnot feature at the bottom right side of the cell (when I am using it). Therefore, I can't use the mouse add dates by scrolling down with the help of mouse. My mouse is otherwise functioning properly. Please help.

share|improve this question
add comment

1 Answer

In Excel, click on File
-> Options
-> Advanced
-> Under the first section, enable file handle and cell drag-and-drop

Check the box and click OK

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.