␡
- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
This chapter is from the book
copy and paste
One way to copy formulas is with the Copy and Paste commands.
)
Drag to select cells D3 and E3.
)
)
Choose Copy from the Edit menu.
A marquee appears around selected cells.
)
)
)
Activate cell D8.
)
)
Choose Paste from the Edit menu.
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.
)