Home >Topics >excel >How to freeze two rows in excel

How to freeze two rows in excel

藏色散人
藏色散人Original
2020-02-29 10:53:288367browse

How to freeze two rows in excel

How to freeze two rows in excel?

Excel window freezing method/step

Recommended "excel tutorial"

Select an anchor point and click the cell with the mouse.

This positioning point is the position you want to fix on the top and left side. The selected positions in Tutu are fixed on rows 1 and 2 and columns A and B are fixed.

How to freeze two rows in excel

Open the View menu and click the freeze split window command in the freeze window selection drop-down box.

How to freeze two rows in excel

Scroll down to see the frozen effect of rows 1 and 2, as shown below:

How to freeze two rows in excel

Scroll right to see the left column The effect of freezing columns A and B:

How to freeze two rows in excel

The above is the detailed content of How to freeze two rows in excel. 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