A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Double click fill down does work, but there must be data in the adjacent, left-most column, so Excel knows how far to copy data down.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
When I double click to fill down a formula in Excel 2011, nothing happens. When I drag down it works but since I have over 2000 rows this is very time consuming. Any ideas or help?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Double click fill down does work, but there must be data in the adjacent, left-most column, so Excel knows how far to copy data down.
Answer accepted by question author
I'm not even sure how you ever got that to work. I've never heard of that before.
Of course, the Fill Down command is available as a menu item, but I've always found it most convenient to assign the Command+D keystroke command to it. It actually was one of the default keystroke commands in older versions of Excel, but I think they changed it to Control+D in the first version of Excel for OS X.
Anyhow, you can set the Fill Down command to work with any keystroke combination you want in the Customize Toolbars and Menus dialog:
Sorry that I can't tell you how to make the double-click work. I guess there might be a way to write a macro using mouse actions for something like that, but as far as I know, there's no way to assign mouse actions to Edit functions in the normal user-definable interface features in Excel.
Answer accepted by question author
On my MacBook Pro fill down Click on a cell move the mouse over to right lower corner.
the cursor will change to a cross-hair (or plus sign) click mouse button or click trackpad down and Drag down, or across until desired position and let go when finished see this movie:
Double clicking on the bottom right of the cell where "+" appears doesn't work when there is a blank Column between the cell you are filling/copy pasting/dragging down from and the rest of your Data.
As everybody else advised, Copy and Paste (Select using ctrl-shift-Down arrow) is the safest when doing thousands of rows.