- Name the Sheet
- Understand References
- Enter Information
- Activate a Cell
- Enter Row Headings
- Enter Column Headings
- Make a Column Wider
- Enter Values
- Calculate a Difference
- Calculate a Percent Diff
- Sum Some Values
- Calculate Net Income
- Copy Formulas
- Copy and Paste
- Use the Fill Handle
- Change a Value
- Extra Bits
Copy and Paste
One way to copy formulas is with the Copy and Paste commands.
- Drag to select cells D3 and E3.
Click the Copy button in the Clipboard group on the Ribbon’s Home tab.
A marquee appears around selected cells.
- Activate cell D8.
Click the Paste button in the Clipboard group of the Ribbon’s Home tab.
The formulas in cells D3 and E3 are copied to cells D8 and E8. The marquee remains around the originally selected cells, indicating that they can be pasted elsewhere.
- Activate cell D22.
- Press Enter. The formulas are copied to cells D22 and E22. The marquee disappears, indicating the selection can no longer be pasted elsewhere.