How To Freeze Panes In Excel

Scroll down to the rest of the worksheet.

How to freeze panes in excel. You can always ask an expert in the excel tech community get support in the answers community or suggest a new feature or improvement on excel user voice. Overview of formulas in excel. When you freeze a column it will stay visible when youre scrolling through that worksheet.

This will now freeze all the rows above row 6. When you have a huge amount of data under a common heading you are unable to see the heading when scrolled down the worksheet. This wikihow will show you how to freeze panes to lock columns in excel.

For example select row 4. On the view tab in the window group click freeze panes. Open your project in excel.

Split panes to lock rows or columns in separate worksheet areas. Shortcut key of freeze panes. Youd select cell d5 and then on the.

All rows above row 4 are frozen. What freeze panes does is it lets you freeze particular rows and columns of your choice so that you can see that frozen portion even when the rest of the datas are being scrolled. How to avoid.

Say you want to freeze the top four rows and leftmost three columns. To freeze rows execute the following steps. Example 5 unfreeze the panes in excel if you have data on which the freeze pane is already applied but you dont know where it is applied then you can just simply remove the freeze pane by selecting the.

Now you can scroll through the data while the four rows of data for standid 1001 year 2013 and productid a10011 remain visible. To freeze multiple rows starting with row 1 select the row below the last row you want frozen and click freeze panes. The next step is to go back to freeze panes and choose freeze panes this time instead of freeze top row.

To freeze multiple rows in excel starting with row 1 select the row below the last row you want frozen and click freeze panes. You can either open the program within excel.