Excel gives you a pair of shortcut keys that can be used to copy cells down and to the
For example, say you want to copy the contents of cell B3 to the fifteen cells just
Follow the steps below to learn how:
- Select the sixteen cells (making sure that cell B3 is the top cell in the selection) and then press Ctrl+D. Cell B3 is copied to all the other cells below it.
- Alternatively, if you would like to copy cells to the right, you can make a selection and Click Ctrl+R. The value of the left-most cell in the selection will be copied to its right, filling out
the selected range.