When we create an Excel table, if there are more rows and more columns, once the screen is scrolled down, the title row above will also scroll, and the data will be processed. It is often difficult to distinguish where each column of data corresponds to the title of the table header, and it is easy to misplace the data.
In fact, we can use the "Freeze Cells" function in Excel to deal with this problem very effectively.
The "Freeze Cell" function means to fix the contents of the specified row or column (mainly the left and top). When the row or column is dragged, the fixed row Or the columns are not moved to facilitate comparison and viewing.
Here, I have a score table. When you scroll down with the mouse, information such as student number, name, English, accounting principles, advanced mathematics, and computers will scroll along. Sometimes, you may be confused. These scores are difficult to distinguish clearly, so we can use the "freeze cell" function to fix the row "student number, name, English, accounting principles, advanced mathematics, computer"
, no matter we How to scroll down the mouse, the second line of information will never scroll, it will always be displayed there.
Operation method:
① First, select the next row of the row that needs to be frozen with the mouse (as shown in the picture below, I want to freeze the fixed header and the first row) second line, and I positioned the cursor in the third line);
②Click "Window" on the menu bar and select "Freeze Panes" in the pop-up drop-down list That's it.
At this time, it has been frozen. No matter how you scroll, the second row and the first row will never change. In this way, we can clearly identify the scores of each subject!
For more Word related technical articles, please visit the Word Tutorial column to learn!
The above is the detailed content of Where are the frozen cells in word. For more information, please follow other related articles on the PHP Chinese website!