A nice feature of this shortcut is that is leaves the cell in “edit mode” after the copy, so you can immediately edit. This can be handy when you want to copy a value from above and adjust the result manually. For example, if you need to enter a set of invoice numbers that are similar, but not necessarily sequential.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
