Keyboard shortcut to copy from below in Excel (opposite of Ctrl+D)
Is there an opposite of ctrld fill down?
Not directly, however:
you can fill up, but it's not a keyboard shortcut. In 2010, goto home, in the editing section (far right), second icon down on the left is fill.
Or:
ShiftUp, F2, CtrlEnter
Source Is there an opposite of the ctrl + d fill down
Or use the following macro:
- Tools > Macro > Record New macro
- Macro Name: FillUp, Short Cut: Ctrl+****+U (Because Ctrl+U is unavaliable)
- Stop recording
Alt+F11, open the VBA Use the following code to overwrite the code in Modules, Sub FillUp()
ActiveCell.Offset(1, 0).Select Selection.Copy ActiveCell.Offset(-1, 0).Select ActiveSheet.Paste Application.CutCopyMode = False
Save
...
how can I code it to work on multiple selected cells, like a row of data?
...
I got it. Just changed 'ActiveCell' to 'Selection'
Source Create shortcut for "Fill Up"
Related videos on Youtube
unubar
Updated on September 18, 2022Comments
-
unubar almost 2 years
Is there a way to copy a value from below a cell range to the cell range above it? Something opposite of Ctrl+D.
Say I have a value in A10 and I want to copy the value in A10 to the cells from A5:A9. Looking for a keyboard shortcut like Ctrl+D.