If you are working on a large spreadsheet, it can be useful to “freeze” certain rows or columns so that they stay on screen while you scroll through the rest of the sheet.
As you’re scrolling through large sheets in Excel, you might want to keep some rows or columns—like headers, for example—in view.
Excel lets you freeze things in one of three ways:- You can freeze the top row.
- You can freeze the leftmost column.
- You can freeze a pane that contains multiple rows or multiple columns—or even freeze a group of columns and a group of rows at the same time.
So, let’s take a look at how to perform these actions.
Freeze the Top Row
Here’s the first spreadsheet we’ll be messing with. It’s the Inventory List template that comes with Excel, in case you want to play along.
The top row in our example sheet is a header that might be nice to keep in view as you scroll down. Switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze Top Row.”
Now, when you scroll down the sheet, that top row stays in view.
To reverse that, you just have to unfreeze the panes. On the “View” tab, hit the “Freeze Panes” dropdown again, and this time select “Unfreeze Panes.”
Freeze the Left Row
Sometimes, the leftmost column contains the information you’ll want to keep on screen as you scroll to the right on your sheet. To do that, switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze First Column.”
Now, as you scroll to the right, that first column stays on screen.
In our example, it lets us keep the inventory ID column visible while we scroll through the other columns of data.
And again, to unfreeze the column, just head to…
The post How to Freeze and Unfreeze Rows and Columns in Excel appeared first on FeedBox.