Visually compare information on different spreadsheets (at the same time)

Please purchase 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 comparing the payroll spreadsheet to the payslips, or looking at the leave register and comparing it to allowed leave?

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: Excel for Human Resource and Payroll Personnel > Tips and Tricks- Intermediate