Here's a quick way to copy and paste from one row to another.
The cell you are copying to must be directly below the one you are copying from.
Position your cursor where you want to paste the information.
Type Ctrl + D.
This copies and pastes information in one step.
For additional information, Learn Excel Formulas from A to Z - Atlanta Excel Training Class.
