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)
