DClick works intermittently?

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,968
One of the features in Excel is to double click on the right-hand lower corner of a selected cell to fill the cells below it w/ the same values in the selected cell.
But I have trouble understanding when this will or will not work. Can someone give the lowdown on the criteria that is required for this fill operation to function?

Thanks,

Doug S.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Hi Doug,

I believe that there must be a column of data adjacent to the column you are autofilling, since the autofill looks at the adjacent columns to determine how far down to fill. Also it will only fill down, not across horizontally.

Damon
 
Upvote 0
Damon,
Thanks, but I just tried dclick in an area w/out adjacent cell w/ data and it worked w/ no problem.

Back to square 1.
 
Upvote 0
Seti,
I use this feature regularly and follow along w/ your explanation. But I still get intermittent results. The thing that happens is when I d-click on the fill handle, nothing happens. So there must be something that Excel does not like.
I also experimented w/ this feature and the dclick and fill works when there is no filled adjacent cell.

Any other ideas here?
 
Upvote 0

Forum statistics

Threads
1,211,434
Messages
6,101,838
Members
447,758
Latest member
jojo3strada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top