How to Unlock Rows and Columns in Excel
Step 1: Open the Spreadsheet
Open the spreadsheet and select Excel’s frozen or locked rows and columns.
Step 2: Go to the “View tab.”
Open the “View” tab and click the arrow icon below the “Freeze panes” option.
Step 3: Unfreeze/unlock panes
From the drop-down menu, click on the “Unfreeze panes” option.
How to Freeze a Row in Excel
When working with lots of data in Excel, it’s essential to keep key details visible. Freezing rows lets you lock the top part of your sheet so you can scroll through your data without losing sight of important information at the top.
This easy guide will show you how to use Excel’s freeze panes feature, making it simpler to work with big datasets by keeping essential data in view, no matter how far down you scroll.
Table of Content
- Why Freeze Rows in Excel?
- How to Freeze Rows in Excel
- How to Freeze Top Row in Excel
- How to Freeze Multiple Rows in Excel
- How to Freeze Rows and Columns in Excel
- How to Freeze Multiple Columns in Excel
- How to Freeze Panes in Excel
- Add Freeze Panes Option to Quick Access Toolbar
How to Lock the First Column- How to Unlock Rows and Columns in Excel