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