Here, we will use the Split option to freeze the first 4 rows and first 2 columns of our datasheet. Method-6: Using Split Option to Freeze Selected Panes in Excel
HOW DO I FREEZE FIRST TWO ROWS IN EXCEL HOW TO
Read More: How to Freeze Top Row and First Column in Excel (5 Methods) Now, we will have two separate grey lines indicating the fixed rows area and the fixed columns area of this worksheet.įor moving down or to the right side we will find our frozen selected panes fixed all over time. ➤ Select a cell below the last row (here, the last row is Row 4 so we selected a cell in Row 5) and to the right side of the last column (here, the last column is Column B so we selected a cell in Column C) up to which you want to freeze the panes. Here, we will try to freeze some rows and columns at a time, and to fix these selected panes we will use the Freeze Panes option. Method-5: Freeze Selected Panes in Excel for Rows and Columns Simultaneously Read More: How to Apply Custom Freeze Panes in Excel (3 Easy Ways) Now, you can scroll to the right side as much as you want but the first two columns of the frozen panes will not move. Then a grey line will appear to the right side of Column B indicating the boundary of the frozen panes. ➤ Select a cell to the right side of the last column (here, the last column is Column B, so we selected a cell in Column C) up to which you want to freeze the panes.
HOW DO I FREEZE FIRST TWO ROWS IN EXCEL CODE
Method-4: Freeze Selected Panes in Excel for Multiple Columnsįor freezing multiple columns like the Product Code and Product column of the following table you can use the Freeze Panes option here.
Read More: How to Freeze First 3 Columns in Excel (4 Quick Ways) So, for moving to the right side of your dataset you will find that the first column is not moving during this process. Then you will have a grey line on the right side of the first column which specifies the first column of this sheet as a fixed pane. ➤ Go to View Tab > Window Group > Freeze Panes Dropdown > Freeze First Column Option. Read More: How to Freeze Selected Panes in Excel (10 Ways)įor freezing only the first column or Column A of your dataset you can use the Freeze First Column option. So, when we try to scroll down through our dataset we can see that the first 4 rows remain fixed during this process. Then a grey line will appear under Row 4 indicating the boundary of the frozen panes. ➤ Go to View Tab > Window Group > Freeze Panes Dropdown > Freeze Panes Option. ➤ Select a cell beneath the last row (here, the last row is Row 4, so we selected a cell in Row 5) up to which you want to freeze the panes. Suppose, we want to freeze the first 4 rows of the following dataset, and to freeze these selected panes in Excel we will use the Freeze Panes option here. Method-2: Freeze Selected Panes in Excel for Multiple Rows Read More: How to Freeze Top Two Rows in Excel (4 ways) Now, if you try to scroll down through your worksheet then you will notice that the first row is not moving with the scrolling process.
Then you will have a grey line below the top row which indicates that you have fixed the top row of this sheet. ➤ Go to View Tab > Window Group > Freeze Panes Dropdown > Freeze Top Row Option. If you want to freeze only the first row of your worksheet then you can do it easily by using the Freeze Top Row option. We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience. We will use the following dataset containing sales records of a company to demonstrate the ways of freezing selected panes in Excel. 10 Ways to Freeze Selected Panes in Excel