Google-sheets – How to get Google Sheets CTRL-D “Fill Down” to behave like Excel when single cell selected

google sheetskeyboard shortcuts

If there is a value in cell A1, CTRL–D while a single cell A2 is selected behaves differently in Excel and Google Sheets:

  • Excel: copies cell A1 to cell A2
  • Sheets: nothing

The Excel behavior is documented and demonstrated here under "Duplicating Into a Single Cell."

Is there any way to get Google Sheets to behave like Excel when CTRL–D is used?

Best Answer

Ctrl+D works if you select the first cell too. In excel, if you ctrl+D in one cell it understands the cell above is the original, if you select 2 or more it takes the first selected as the original. Google sheets does the same except the 1st mentioned case. You always have to select the original data cell too

Related Topic