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.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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.
ShiftUp, F2, CtrlEnter
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
how can I code it to work on multiple selected cells, like a row of data?
I got it. Just changed 'ActiveCell' to 'Selection'