Here is how to freeze the left-most column: In such cases, it’s a good idea to freeze the left-most column so that the headers are always visible to the user.įreeze/Lock the Left-Most Column in Excel If you are working with a dataset that has headers/labels in a column and the data is spread across many columns, as soon as you scroll to the right, the header would disappear.
In the Freeze Panes drop-down, select the option to Unfreeze Panes.Įxcel Freeze Panes Options – Freezing Column(s). Now when you scroll down, all the header rows would always be visible. You would notice that a gray line now appears right below the rows that have been freezed. This will freeze all the rows above the selected cell. In the Freeze Panes drop-down, select Freeze Panes. Select the left-most cell in the row which is just below the headers row. If you have more than one header rows in your dataset, you may want to freeze all of it. Now when you scroll down, the row that has been frozen would always be visible. You would notice that a gray line now appears right below the first row. This will freeze the first row of the data set. Here are the steps to freeze the first row in your dataset: In such cases, it’s a good idea to freeze the header row so that these are always visible to the user. If you are working with a dataset that has headers at the top row and a dataset that spans hundreds of rows, as soon as you scroll down, the headers/labels would disappear. Let’s see how to use these options to Freeze Panes in Excel while working with large data sets: Freezing Row(s) in Excel You can use these options to lock rows or columns (or both) into panes in Excel. Freeze First Column: It freezes all the columns to the left of the active cell. Freeze Top Row: It freezes all the rows above the active cell. Freeze Panes: It freezes the rows as well as the columns. It shows three options in the Freeze Panes drop-down: In the Zoom category, click on the Freeze panes drop down. Freeze/Lock More than One Column in Excel. Freeze/Lock the Left-Most Column in Excel. Excel Freeze Panes Options – Freezing Column(s). Easy your work with WPS Spreadsheet like Microsoft Excel. These are the introductions on the function and method of Freeze Panes. If you want to learn more about using Reading Layout, you can watch more related videos in our WPS Academy. Now just click it and complete the settings.Ĭombining t his feature with Reading Layout, can make it easier for us to view data. Then the first option will change to Freeze to row 2 column A. First, we need to find the intersecting cells of the next row and the next column, the intersecting cells of row A3 and column B.Ģ. Now, w hat if we want to freeze a row and a column at the same time ?įor example, we want to freeze row A2 and column A at the same time.ġ. We will find that the first two rows are frozen now and will not be covered by other rows. Click Freeze to row 2, then drag the scroll bar. Now the first option becomes Freeze to row 2. For example, we now need to freeze the two rows A1, A2, then we need to select the A3 cell and click Freeze Panes. If we want to freeze a row, we first need to select the row below it and then do the settings.Ģ. So what should we do to freeze other rows and columns?ġ. Just select Freeze the first column, and then the first column of the table will be frozen. 
The Freeze First Column feature works in the same way. If we want to unfreeze, just click Freeze Panes again, and click Unfreeze Panes.
Click Freeze Top Row, then the top row of the table will be frozen.Ģ. The first is Custom Freeze, the second is Freeze Top Row, and the third is Freeze First Column. You can see that there are three options. Click the Home tab, then click the Freeze Panes button. Today I'm going to introduce you to a practical feature, Freeze Panes. So how can we freeze a row or column for us to check it more conveniently? Therefore, we won't be able to know exactly what each column of data represents. When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar.
0 kommentar(er)
