Freezing column and row labels in Excel (a.k.a Freeze Panes) locks parts of your screen so that you don’t lose sight of the heading labels at the top of a column or beginning of a row when you scroll.
When working on large worksheets, labels used to identify data can be lost when you scroll in either direction, and then you find yourself wasting time scrolling backwards and forwards, up and down, just to check you are actually in the correct column and row.
Freezing row and column panes
Freezing panes can be used when you want to keep row and column labels visible as you scroll.
1. Click on the cell below and to the right of the row and column you want frozen.
2. From the View tab, in the Window group, click on Freeze Panes and select the top option Freeze Panes.
3. Non-printing lines will indicate the position of the freeze points. In the image below the user selected the cell holding $78.12 in column K prior to turning Freeze Panes on. Therefore the freeze points are above row 2 and to the left of column K.
As you scroll the rows and columns inside of the frozen area will constantly be visible.
This may seem confusing at times when you can’t see all of your data. For example, in the example below columns D to J are hidden. To see these columns you would need to scroll to the left to expose them again.
Unfreezing panes
From the View tab, in the Window group, click on Freeze Panes and select Unfreeze Panes.
Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.
She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.
If you enjoyed this you may also enjoy...
NETWORKDAYS in Excel – Calculate the number of work days between two dates
The Excel NETWORKDAYS and WORKDAY functions are both powerful tools for handling date and time-related calculations, particularly in the context of workdays and business schedules. While both functions are related to workdays, they serve slightly different purposes. The WORKDAY function in Excel calculates a date a specified number of workdays in the future or past from
How the SUMPRODUCT formula in Excel can help you work more efficiently
When it comes to performing calculations and analysis in Excel, there are numerous functions that can save you time and effort and one of these is the SUMPRODUCT function. In this blog post, we’ll dive into what the SUMPRODUCT function is, how it works, and provide a step-by-step guide on how to create a SUMPRODUCT formula
How to Remove #DIV/0 Error in Excel
If you’re an Excel user, you’ve probably encountered the dreaded #DIV/0 error at some point. This error occurs when you attempt to divide by zero. In the example below cell A6 is blank, therefore Excel evaluates A6 as zero and the formula returns the #DIV/0! Error.Excel #DIV/0 errors can be frustrating to deal with. Not only
Find and break links in Excel
Linking from one worksheet to another is a fantastic way to connect data from one source to another, and a great way to avoid having to enter the same data in multiple places. However, there are times when you need to break links in Excel, and this can create the challenge of having to locate and
Excel Count cells with Text (3 easy functions + 9 valuable formula examples)
Are you trying to count cells with text in Excel?Are you wondering why the COUNT function in Excel returns a result of 0?You’re not alone. Counting cells with text can be a bit of a struggle in Excel if you are unaware of which function to use when.What’s more, there are several different formula options
Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function
There are many areas within business reporting where we are looking for the average of a selection of results. A good example of this may be when we are looking to find the average value of sales made within a particular month, within a particular region, or to an individual customer. To find the average all we