Title says it all. When I press Ctrl+D, it clears the contents in the cell instead of filling down the columns.

Any idea why this could be happening and how to fix it? I reset all of my customizations but that didn't fix it.

I also tried recording a new macro for Ctrl+D by clicking and dragging down the rows, but then when I use the macro it just fills those specific cells instead of any cells in the sheet.

1 Answer

similar to:

crtl-d works by copying the cell above to the active cell, so if the cell above is empty it copies the blank cell to the active cell (it just looks like it is clearing the content of the active cell).

Note if selecting a range of cells, the cell(s) to be copied should be the top cell(s) in the range.

3

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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