We review how to freeze panes, locking both rows and columns in order to keep sections of our spreadsheet visible when scrolling around.
This is video 4 of our course, below is a link to lesson 5 and a playlist of the full Module 1.
RESOURCES & LINKS:
► Become an Excel Power User in 2.5 Hours (81% discount):
Module 1 of Course:
► Preview the first six lessons of the course:
► Next Lesson: Formatting & Moving Columns, Rows & Tabs:
► Build a Basic Financial Model:
► Subscribe for more finance videos:
To access the entire course, take a look at the above link.
Freezing panes is one of the fundamental Excel formats that you should use in basically any spreadsheet, and are one of the most common formats in business.
Freezing panes will allow us to freeze certain sections of the spreadsheet, usually a header and one or two columns, so that we can navigate around the rest of the sheet without getting lost.
When we freeze panes, we “lock” rows and columns along the top and left side of our spreadsheet, so that they stay static when we are scrolling around.
This skill will improve all of your models and make them look more professional.