Viewing many parts of the spreadsheet (at the same time)

Please sign up for the course before starting the lesson.

When working on spreadsheets, you often need to work on different parts of the spreadsheet at the same time. Perhaps you are building the capital expenditure requirements but you want to see how revenue is changing to match capex with activity. Or you want to see the consolidated income while working on one of the divisions.

In this lesson you will learn about:

  • Freezing the panes
  • Splitting the screen so you can see row 10 while looking at row 1000
  • Watching key cells as you move around your spreadsheet
  • See two (or more) spreadsheet workbooks next to each other
  • See two sheets WITHIN the same spreadsheet at the same time

Split Screens

To see the full course contents click here.

Back to: Intermediate Excel Course > Tips and Tricks- Intermediate