You know how it is. You are filling out an Excel spreadsheet and you need to copy the value above. Now, everyone knows the two ways to do this (copy /paste and to “drag and fill” the data down). Well, I was shown a third way today and thought I’d share it with you.
Simply select the cell where you want the data to be copied into and press CTRL + D (for Duplicate) and that’s it.
Before and After
Philip Flint 