What do freeze panes do in excel

One such ability is to freeze panes in Microsoft Excel. There are times when we have to compare all that information in the worksheet. We need to keep an area of that worksheet visible when we scroll to any other area of that particular sheet. It proves very useful to freeze specific rows and columns in place at that time. You can even split the panes in excel for creating separate windows of that worksheet. We will help you understand how to freeze multiple rows and columns in excel with easy steps through this tutorial.

You can easily freeze top rows, columns, and cells and then unfreeze them when required by just following a few steps. Read on for more about how to freeze multiple rows and columns in excel.

Check How to Lock Formulas in Excel for a shared spreadsheet. If you want to freeze just the top row in your Excel sheet then these are the steps you need to follow:. Step 3: In the next step when trying to freeze panes in MS Excel, scroll down at the end of the worksheet. Excel will automatically add a dark grey horizontal line that indicates that the top row is now frozen. Apart from that, you can freeze the top row only regardless of where the position of the cursor is using a keyboard shortcut that is Alt-W-F-R.

If you want to know how to freeze the first column in your excel spreadsheet, you are required to follow the below-mentioned steps:. Step 3: Scroll till the right end of the worksheet where the column ends. Excel will add a dark grey vertical line which indicates that the first column is now frozen. There is a keyboard shortcut as well for freezing the first column only in your Excel sheet regardless of the position of the cursor.

Just press Alt-W-F-C. People usually tend to freeze rows in their Excel sheet when they want to see particular sets of rows in the worksheet. On the View tab, in the Window group, click Freeze Panes. Chapter Worksheets. Download Excel File freeze-panes. Next Chapter Format Cells. Follow Excel Easy. Become an Excel Pro Examples. Freeze panes to lock the first row or column in Excel for Mac. Split panes to lock rows or columns in separate worksheet areas.

Overview of formulas in Excel. How to avoid broken formulas. Find and correct errors in formulas. Keyboard shortcuts in Excel. Excel functions alphabetical. Excel functions by category. Table of contents. Insert or delete rows, and columns Article Select cell contents in Excel Article Freeze panes to lock rows and columns Article Hide or show rows or columns Article Filter for unique values or remove duplicate values Article Split text into different columns with the Convert Text to Columns Wizard Article Create a list of sequential dates Article.

Next: Cells. Need more help?