Fill-handle doesn't fill all the way down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I double click on the small black square to auto fill a formula it stops
short. It should go to the last cell with data in the preceding column but
it doesn't. If I double click again it still stops short.
 
Any blank cells in the adjacent column?

The fill-down will stop at a blank cell.


Gord Dibben Excel MVP
 
I cannot replicate this without there being a blank cell in the column.

Can't think of another reason for this behaviour.

Stick around...someone else with a better memory may have a suggestion.


Gord
 
Perhaps hidden rows that contain blank cells in the
adjacent column?

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

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

Similar Threads

Fill handle fill down alternative methods question 2
Shortcut Key for Auto-Fill? 4
Series fill only copying and fill series greyed out 1
Fill Handle in Excel 2007 4
Is there a keyboard shortcut to fill handle a large # of cells? 1
Filling formulas 1
Fill down formulas in existing excel docs stopped working 1
2007 Excel Auto Fill - Lower right corner 4

Back
Top