Excel Fill Handle Double Click Problem

[aechase]

I recently switched at the office from Excel 2003 to 2010. Once of the sheets I work with regularly requires filling down a significant number of rows on a repetitive basis, which I would accomplish by double clicking the fill handle (with one cell selected for unique fills, 2 for repeat cells). This would fill to the last row of the column to the left, which is what I need. Now, this action fills all the way to the very bottom of the sheet, leaving my only option as clicking the handle and dragging it down. Is there any way to change this setting back to the 2003 style?

Related: If I try typing the name of a company two cells in a row, the second no longer tries to autocomplete the name. Is there a way to turn this functionality on?

Thanks!

[shg]

(1) Don't have Excel 2010, but Excel 2007 works in the same fashion as 2003

(2) Excel Options > Advanced > Editing Options, tick Enable Autocomplete for cell entries

[optomyst]

Same for 2010... File...options...advanced... check "Enable Autocomplete"

[aechase]

Thanks, all set on the autocomplete!

Anyone with 2010 have ideas on the first problem?

[aechase]

Bump for Monday!