1

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.

1

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"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.