Microsoft Excel: Freeze Panes, Views & Large Worksheets

Wishlist Share

About Course

Stop losing your place in long spreadsheets. This course shows you how to keep headings in view with Freeze Panes, compare different parts of a workbook with Split and New Window, move around large sheets quickly with the keyboard, and use Sheet View so your sorting and filtering does not disrupt colleagues in a shared file.

Tutwoo is an independent learning provider and is not affiliated with or endorsed by Microsoft. Menu names and features can vary between versions and platforms and change with updates. This course is general skills training and is not an accredited qualification.

What Will You Learn?

  • Keep header rows and key columns visible while you scroll Compare two areas, sheets or workbooks at the same time Move around thousands of rows quickly with keyboard shortcuts Sort and filter a shared workbook without changing what others see

Course Content

Course Lessons

  • Freeze Panes: keeping headings in view
  • Split, New Window and Arrange All
  • Moving around large sheets quickly
  • Sheet View: sorting and filtering in shared workbooks

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕