Home >Topics >excel >How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

尚
Original
2020-03-02 13:45:2315748browse

How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

How to fix the header in excel so that you can see the header when you pull down the entire table:

1. Set the header in the first row, and then select first row.

How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

#2. After selecting the table header, click to enter the view page, and then click Freeze First Row in the Freeze Pane.

How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

#3. After clicking Freeze the first row, the table header will be fixed at the top. No matter how you pull down the cell, the table header will be at the top.

How to fix the table header in Excel so that when you pull down the entire table, you can see the table header

Recommended: "excel tutorial"

The above is the detailed content of How to fix the table header in Excel so that when you pull down the entire table, you can see the table header. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn