Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity > Microsoft Excel

  • Print
  • + Share This
This chapter is from the book

Copy and Paste

One way to copy formulas is with the Copy and Paste commands.

  1. Drag to select cells D3 and E3.
  2. Click the Copy button in the Clipboard group on the Ribbon’s Home tab.

    A marquee appears around selected cells.

  3. Activate cell D8.
  4. 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.

  5. Activate cell D22.
  6. Press Enter. The formulas are copied to cells D22 and E22. The marquee disappears, indicating the selection can no longer be pasted elsewhere.
  • + Share This
  • 🔖 Save To Your Account