Paste Special, inserting and deleting

BeginnerBeginner

7 questions, about 13 minutes

Paste only what you need, and add rows and columns without breaking your formulas.

What we'll do

  • Pasting values and formatting
  • Transposing
  • Inserting or deleting rows and columns

What you'll use

  • The Excel menus

How it works

In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.

2examplesYou watch
7questionsYou do it yourself
Full explanation