Software

Ask something
Question Locked

excel 2007

0 helpful
3 replies

by patb071

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In excel 2007 i am tring to have numbers go down a column 1-100 if i type 1,2, how do i get excel to autofill by me pushing the down arrow key? This worked in office xp but now i have to manually type the numbers in.

Thanks

3 replies

by 93961

Go to Tools/Options/Edit Tab in Menu and select & enable "Allow cell drag and drop" option. This thing works in Office XP. Try in Office 2007 and let us know.

by patb071

I tried this but it was already marked

Click the Microsoft Office Button , and then click Excel Options.
In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box to turn drag-and-drop editing on or off.

This discussion is closed to new replies.