Forum Discussion
Keyboard shortcut for fill down not working in Excel
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:
Hope I was able to help you with this information.
I know I don't know anything (Socrates)
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.
- Please follow Mr. Baklans advice, disable all add inns and try again.If it doesn't work there either, the procedure from the beginning,
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
- 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)
Today someone posted on anther thread that it could be a shortcut in WebEx. For me it was. In the WebEx desktop app I went to my profile picture, Settings, Keyboard Shortcuts, Meetings & Calls, and disabled all the keyboard shortcuts including Ctrl+D decline call.
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.
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.
Thank you for sharing how your version of Microsoft Office Excel maps out the keyboard shortcuts within Microsoft Office. I currently use the German Language Package for all of my personal use (preferred after a study-abroad in Germany) and I found that Ctrl+U is also the keyboard shortcut for when I want to fill information down. This is related to "Nach unten Ausfüllen" and serves as the mnemonic command thereby. Additionally, when I want to make bold-face or italic print, I have to use Ctrl+Shift+F or Ctrl+Shift+K, respectively. The letter "F" denotes "fett" related to "fat" in English or bold print and "K" denotes "kursiv"; however, Ctrl+X, Ctrl+C, and Ctrl+V remain unchanged.
I hope that this helps!
