Forum Discussion

Jim22122's avatar
Jim22122
Copper Contributor
Mar 25, 2022

Keyboard shortcut for fill down not working in Excel

There used to be a keyboard shortcut to fill down (CRTL+D).  But it no longer works.  CRTL+R works.  What's happened?   Microsoft Excel for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20118) 3...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Mar 25, 2022

Jim22122 

As far as I know (maybe I'm wrong) CTRL+D has no function, although the Excel help says it uses the Fill Below command to fill in the contents and format of the top cell of a selected range in copy the cells below. For this there is Ctrl+R in Excel.

As far as I can understand, all information without guarantee, since I don't have Excel 365, but from Excel 2007 to 2016 I'm pretty sure that's the case.

 

additional info:

Excel help & learning

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

 

  • Jim22122's avatar
    Jim22122
    Copper Contributor
    Mar 25, 2022

    NikolinoDE 

    I've had previous versions of Excel and CTRL+D always worked to fill down.  In fact, it also worked in Excel 365 until within the last few months.  Strange thing is that in some of my older Excel files, it works, but when I save them, then it seems to stop working.  Don't know if I have changed some setting to invalidate it.

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Mar 25, 2022

      Jim22122 

      Please follow Mr. Baklans advice, disable all add inns and try again.
      If it doesn't work there either, the procedure from the beginning,
      perform update, Office Repair, start in safe mode .

      Sry for the incorrect information, I was almost sure that's why the quick answer...

      whatever...to err is human...and sometimes more human :).

       

      thank you for your patience

      • ShellyDxGen's avatar
        ShellyDxGen
        Copper Contributor
        Dec 27, 2023
        Jim22122 did you find the fix? I have been using Ctrl + D in MS Excel for over 25 years and it just stopped working for me this month. I'm wondering if is has something to do with new safety protocols with my current employer; OneDrive; some other random software that prevents it. Same as you Ctrl + R still works to fill right; my workaround is to add Fill Down to my quick access toolbar. So frustrating. (Menu path is Home > Editing menu > Fill > Down right click to add to Quick Access) (Keystrokes - Alt H, Fi, menu key, A)
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Mar 25, 2022

      Jim22122 

      Ctrl+D shall work on any version. Perhaps you have another software which uses this shortcut and bloks it for Excel? Try in safe mode.

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Mar 25, 2022

        SergeiBaklan 

        Sergei can it also be in the keyboard layout? why does it work with CTRL  U...weird. 

        With CTR D it never worked for me as far as I can remember, even if I have to admit that I hardly dealt with it.

        As you say, it could also be due to the add ins, have to check that again, thanks for the tip.

Resources