How to fix the first row of cells
Mar 01, 2021 am 11:04 AMHow to fix the first row of cells: First open the Excel table and enter the content that needs to be fixed on top in the first row; then select the content that needs to be fixed on top in the first row of the excel table; then click on "Start" Find the "Freeze Window" button on the right side of the function interface; finally click "Freeze First Column".
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
Just set it to the top. The steps are as follows:
1. Open the Excel form on the computer and enter the content that needs to be pinned to the top in the first row, as shown in the figure:
2 . Select the content that needs to be pinned to the top in the first row of the excel table. It is best to select all the data. The data added later will be directly pinned to the top by default, and there is no need to set it multiple times. As shown in the picture:
3. Click "Start" in the Excel worksheet function bar above, and find "Freeze Window" on the right side of the "Start" function interface. button, as shown in the figure:
[Recommended: Excel Tutorial]
4. Click the "Freeze Window" drop-down button . There are three options: "Freeze Pane", "Freeze First Row" and "Freeze First Column". Click "Freeze First Row" here. As shown in the picture:
5. After clicking "Freeze First Row", you can complete the fixing of the first row on top. No matter how you scroll down, the first row will be It is always displayed at the top, as shown in the picture:
The above is the detailed content of How to fix the first row of cells. For more information, please follow other related articles on the PHP Chinese website!

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Excel found a problem with one or more formula references: How to fix it

How to set the print area in Google Sheets?

How to embed a PDF document in an Excel worksheet

What should I do if there are too many different cell formats that cannot be copied?

How to remove commas from numeric and text values in Excel

How to find and delete merged cells in Excel

How to prevent Excel from removing leading zeros

How to create a random number generator in Excel
