excel 2007

By patb071 ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

excel 2007?

by Mehul Bhai In reply to excel 2007

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.

Collapse -

I tried..

by patb071 In reply to excel 2007?

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.

Related Discussions

Related Forums