HOW TO FREEZE MULTIPLE PANES IN EXCEL 365 HOW TO
HOW TO FREEZE MULTIPLE PANES IN EXCEL 365 CODE

HOW TO FREEZE MULTIPLE PANES IN EXCEL 365 HOW TO

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 TO FREEZE MULTIPLE PANES IN EXCEL 365 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. Step 2: Click on the first row number that you want to include in the group.10 Ways to Freeze Selected Panes in Excel Step 1: Open the Excel file containing the rows that you want to group. The steps in this article were performed in the Excel for Office 365 version of the application but will also work in other versions of Excel such as Excel 2013, Excel 2016, or Excel 2019. How to Create a Group of Rows in Microsoft Excel for Office 365 Our guide below is going to show you how to group rows in Excel for Office 365 so that you can take advantage of these options. This adds an extra section of controls to the left of the spreadsheet that you can use to quickly hide or show a selection of rows. Luckily there is an option in Microsoft Excel that lets you group a set of rows. While you may have previously experimented with hiding and unhiding rows and columns, but that can be tedious when you need to constantly change the viewability of rows or columns. Click the Data tab at the top of the window.Ī spreadsheet with a lot of data can easily become unruly.

Hold down the Shift key on your keyboard, then click the bottom row to include in the group.Click on the top row number to include in the group.The steps in this article are going to show you how to select a number of rows and put them into a group using the Excel for Office 365 version of the application.

How to freeze multiple panes in excel 365