Freeze Panes and views

BeginnerBeginner

8 questions, about 14 minutes

Keep your headings in view while you scroll, and look at your sheet in different ways.

What we'll do

  • Freezing rows and columns
  • Switching views
  • Showing formulas

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
8questionsYou do it yourself
Full explanation