doubleclicking autofill crosshairs doesn't work in Excel 2007

K

KDaddy

In past versions of Excel, if I needed to copy a sequence or formula down all
the rows of a large table, I could enter the first row, select that cell, and
double-click the crosshairs at the lower right corner of the cell. Excel
would then auto-fill the sequence all the way down the table.

I have updated the Excel 2007 on two different machines, and now when I
double-click, nothing happens. Yet I have spend a few hours searching the
internet and everything I read assumes that it works in 2007 - I can't find
anything about what to do if it doesn't work.

Anybody have any ideas how I can get it working again?
 
G

Gord Dibben

Button>Excel Options>Advanced>Editing Options.

"Enable fill handle and cell drag and drop"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top