How to Freeze Panes in MS Excel
Вставка
- Опубліковано 26 сер 2024
- How to Use Freeze Panes in MS Excel?
Ever scrolled down a spreadsheet and lost sight of your column headers? 📊 In today’s tutorial, I'll show you how to use the Freeze Panes feature in Microsoft Excel to lock your headers and columns, making it easier to navigate large datasets.
Steps to Freeze Panes in MS Excel:
1. Open Excel: Start by opening your Excel workbook that contains the data.
2. Navigate to the View Tab: Click on the ‘View’ tab in the Excel ribbon.
3. Freeze the Top Row:
- Click on ‘Freeze Panes’ in the ‘Window’ group.
- Select ‘Freeze Top Row’ to keep the header visible while scrolling down.
4. Unfreeze Panes:
- If needed, click on ‘Freeze Panes’ again and choose ‘Unfreeze Panes’ to remove any freezes.
5. Freeze Columns:
- Select the cell right next to the columns you want to freeze (e.g., if freezing first two columns, select cell C1).
- Click on ‘Freeze Panes’ then ‘Freeze Panes’ again from the dropdown.
6. Freeze Both Rows and Columns:
- Click on the cell where rows and columns you want to freeze intersect (e.g., B2 if freezing the first row and column).
- Select ‘Freeze Panes’ and then ‘Freeze Panes’ from the dropdown.
👍 If this video helps you, please like and subscribe for more practical Excel tips. Drop your questions or suggestions in the comments-I love hearing from you!
Subscribe to WebWise - / @web-wise