Share via

Double click to fill down doesn't work

Anonymous
2012-01-16T22:54:04+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2016-03-27T23:35:58+00:00

    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.

    300+ people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2012-01-17T04:03:03+00:00

    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:

    • Under the View menu, select Toolbars, and then choose Customize Toolbars and Menus... from the submenu to open the Customize Toolbars and Menus dialog.
    • Click on the Keyboard... button at the bottom right edge of the dialog to open the Customize Keyboard dialog.
    • Select the Edit category on the left, and then scroll down the list of Edit commands on the right and select the Down command.
    • Place the cursor in the Press new shortcut key text box, and type whatever keystroke combination you want to use.
    • If the keystroke combination is already in use by another command, Excel will tell you that it's currently assigned and will tell you what function it's assigned to. If you want to override the current assignment, click the Add button. Excel will display a prompt asking you whether you want to reassign the key combination to the selected command. If so, click OK, or click Cancel to return to the dialog and select another key combination.
    • When you're done, click OK on both dialogs to close them.

    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.

    20+ people found this answer helpful.
    0 comments No comments

Answer accepted by question author

  1. Anonymous
    2012-01-17T04:14:40+00:00

    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:

    http://screencast.com/t/IH7K5wNY

    5 people found this answer helpful.
    0 comments No comments

10 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-02-16T15:38:21+00:00

    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.

    10+ people found this answer helpful.
    0 comments No comments
  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-03-28T15:52:23+00:00

    Head to Excel > Preferences. Make sure that Extend data range formats and formulas is checked.

    10 people found this answer helpful.
    0 comments No comments