The key is this: you must select all cells at once. I have a separate Ctrl+Enter post here, but here’s a brief summary. You can also copy and paste multiple cells at the same time.
The range you copy into must be in the same column/row as the cell you’re copying.Ĭtrl+D and Ctrl+R work on formulas, values and formatting. The first cell in your selection must be either the cell you are copying or the one just below / to the right of it. Second, if you include the cell you’re copying in your selection, then you can copy it down to an entire column of cells that you select - and there can even be gaps in the column that you select.Ĭtrl+R does the same thing except it goes to the right instead of down. There are two possible scenarios, and they are illustrated in the magic show above:įirst, if you select only the cell below the one you want to copy, it will copy down that cell’s value or formula. But when they do fit, they’re lightning fast.īelow is a magic show - and after that the magic tricks are discussed.Ĭtrl+D copies and pastes downward in one quick shortcut. These magic tricks don’t fit every situation. Just use Ctrl+D, Ctrl+R, Ctrl+Enter or Autofill. Did you know you can copy and paste simultaneously in Excel?
0 kommentar(er)
