Freezing Header Rows and Key Columns
Learn how to freeze header rows and pin identifier columns in spreadsheets. Keep your titles visible while scrolling through large multi-row tables.
Why This Feature Matters
When you work with a large spreadsheet containing hundreds of rows, scrolling down hides the top header row. Suddenly, you are staring at a grid of raw numbers and guessing whether column D is "Unit Price", "Total Cost", or "Gross Margin".
Freeze Panes solves this by permanently pinning your top header row (or leftmost column) on screen. No matter how deep you scroll down, your column titles stay locked at the top so you never lose your place.
How Freeze Panes Works
In Excel (under the View tab) and Google Sheets (under View > Freeze), you can lock different parts of your view:
| Freeze Option | What Gets Locked | When to Use |
|---|---|---|
| Freeze Top Row | Row 1 stays fixed at the top. | Scrolling vertically down through hundreds of transaction records. |
| Freeze First Column | Column A stays fixed on the left. | Scrolling horizontally to the right across wide tables with many months. |
| Freeze Panes (Custom) | Locks all rows above and all columns to the left of your active cell. | Keeping both headers and product names visible simultaneously. |
Step-by-Step Practice Guide
Practice calculating inventory valuation metrics across rows while referencing fixed warehouse metrics in column H:
Practice 1 — Product Alpha Line Inventory Value
In cell D2, calculate total value by multiplying Units in Stock (B2) by Unit Cost (C2).
=B2*C2In cell D2, calculate the total line inventory value for Product Alpha (Units * Unit Cost). Formula: =B2*C2.
Practice 2 — Share of Total Warehouse Inventory
In cell E2, divide Line Value (D2) by the Total Warehouse Asset in $H$2 ($120,000).
=D2/$H$2In cell E2, calculate the inventory share by dividing Line Value (D2) by Total Warehouse Asset in H2 ($H$2). Formula: =D2/$H$2.
Practice 3 — Inventory Reserve Margin
In cell F2, subtract the Minimum Reserve Ratio in $H$3 (15%) from Inventory Share (D2/$H$2).
=(D2/$H$2)-$H$3In cell F2, calculate the inventory variance margin after deducting the Minimum Reserve Ratio in H3 ($H$3). Formula: =(D2/$H$2)-$H$3.
Practice 4 — Master Catalog Label
In cell G2, combine Product Name in A2 and Line Value in D2 into a clean tag like Product Alpha [$36000].
=A2 & " [$" & D2 & "]"In cell G2, create the master catalog tag by combining Product Name (A2) and Line Value (D2). Formula: =A2 & " [$" & D2 & "]".
To freeze both row 1 and column A at the same time in Excel, select cell B2, then go to View > Freeze Panes > Freeze Panes. Everything above and to the left of your selected cell will freeze instantly.
Share This Lesson
Spread the word with your peers and challenge your friends