In cases like these, it’s good practice to freeze the title rows, so they’re always visible. If you’re working with a large dataset and your columns have headers, as soon as you start scrolling down, the titles of the columns will move out of your sight. Let’s see how we can use these tools for freezing rows or columns in Excel while working with large data sets. You can use these options for freezing rows or columns (or both) in Excel panels. Freeze the first column: By choosing this option, the first left column will be frozen.Freeze top row: This just freezes the first top row of the excel sheet.Freeze Panes: This allows you to freeze select rows or columns.Accessing the Options for Excel Freeze Panes By doing this, you will always have the selected rows and columns in view regardless of how far down you scroll. In situations like this, you can use the Excel Freeze Panes feature for keeping certain rows or columns in the view. You're recommended to explore it.While working with large data sets in Excel, you’re usually forced to scroll down a lot, which will take the title of the columns and rows out of your sight. It's more convenient to view and edit table data in WPS Office for PC. Then the cell range above the second row and that on the left of column B will be frozen.
Select cell B2 and click Current Cell to freeze it.Ģ. In addition to these, we can also freeze any cell range according to our actual needs.ġ. Then we can scroll through the table with the first column fixed.
If you want to view the column labels more expediently, choose First Colum n here. Then we can scroll through the table with the heading row fixed.Īnd how can we disable this feature? Click Freeze Panes again. If we want the heading row of this table to always be visible, choose Top Row. Here we can see three options of Freeze Panes, namely, Top Row, First Column, and Current Cell. The Freeze Panes function can solve this problem.Ĭlick Tools, and in the View tab, select Freeze Pane s. When dealing with huge amounts of data, we find it difficult to view data and its corresponding headings at the same time.
0 kommentar(er)
