Google
 

Tuesday, October 23

A Little to the Right

We all know how to copy the contents of one cell to another, right? I'll bet you don't know about this copy shortcut. You can copy the contents of one cell to the cell that's directly to the right of that cell by selecting the cell to the right and pressing Ctrl-R. Did you get that? For example, to copy the contents of cell A1, you'd select cell B1 and press Ctrl-R. Similarly, you can copy a cell's contents to the cell below by selecting the cell below and pressing Ctrl-D. To copy the contents of cell A1, you'd select cell A2 and press Ctrl-D .
Google