Large and small data sets can be managed with Microsoft Excel. But if you’re unaware of how to arrange your spreadsheet with so many menu options, it can rapidly get frustrating.
Your spreadsheet’s top row should be frozen as a starting point. Users can utilise this feature to browse through the remaining information while keeping headers or significant columns in view.
Here is all the information you need to know about Excel and Google Sheets’ “freeze” setting:
Excel freeze a row instructions
You can easily freeze the top row in your spreadsheet by following these simple steps if you want to keep your header row visible while you navigate up and down:
Activate “View” from the top menu.
To find “Freeze Top Row,” look for the blue and white grid icon with the asterisk.
If you’re using an older version of Excel, “Freeze Panes” can be an option in the dropdown menu. Choose “Freeze Top Row” from the alternatives if that is the situation.
Three options are available when using Excel’s “Freeze Panes” feature, and they are either shown side by side in your top panel or as a dropdown menu:
Rows and columns are kept visible while you navigate around the spreadsheet with the help of freeze panes.
Freeze Ensures that the top row is visible.
Freeze First Column: Continues to display the first column
When you’re done, a darker grey line ought to appear beneath your frozen row. It will stay at the top of the spreadsheet as you navigate. To reverse this operation, select “Unfreeze Panes.”
How to make an Excel column frozen
To freeze the first column in your spreadsheet and keep it visible while you scroll left or right, follow these steps.
If you’re using an older version of Excel, “Freeze Panes” can be an option in the dropdown menu. Choose “Freeze First Column” from the alternatives if such is the situation. To reverse this operation, select “Unfreeze Panes.”
How to freeze a number of columns and rows in Excel
By choosing a cell below the row you want to be fixed in place, you can freeze many rows at once. To make multiple columns scrollable, do the same thing: choose the column to the right of the ones you wish to be displayed.
We’ve chosen cell C1 in this image because we want columns A and B to stay in their original positions.