Home > Topics > excel > How to freeze a row in a table

How to freeze a row in a table

藏色散人
Release: 2020-07-04 11:53:28
Original
21579 people have browsed it

How to freeze a row of the table: 1. Click "View" → "Freeze Panes" → "Freeze Split Panes" in the menu bar; 2. Click "View" in the menu bar, and Select Freeze Panes → Unfreeze Panes.

How to freeze a row in a table

Freeze a certain row of the table

We want to freeze a certain row of the window. When the mouse scrolls down, the row will not freeze. move, but how to achieve this effect? Let's take the freezing of the window in the third row as an example.

How to freeze a row in a table

Click the mouse to select the fourth row, and click "View" → "Freeze Panes" → "Freeze Split Panes" in the menu bar.

How to freeze a row in a table

# In this way, when the mouse scrolls down, the cells above the thick black line will be fixed. Simply put, just click on the next row of cells you want to freeze.

How to freeze a row in a table

If we want to cancel this setting, also click "View" in the menu bar, then "Freeze Panes" → "Unfreeze Panes", so just now The settings are cancelled.

How to freeze a row in a table

If we want to freeze certain rows and columns of the window, how can these rows and columns be fixed when the mouse scrolls down? Let's freeze them below. Take the window in row 9 and column C as an example. Click the mouse to select cell D10, and click "View" → "Freeze Panes" → "Freeze Split Panes" in the menu bar. That is to say, click on the intersection of the cells in the row and column next to the cell in the row and column you want to freeze.

How to freeze a row in a table

After freezing the window, scroll down with the mouse, and the cells above the straight line pointed by the arrow will be fixed.

How to freeze a row in a table

Similarly, drag the scroll bar to the right, and you can see that the windows to the left of the line pointed by the arrow are fixed.

How to freeze a row in a table

If we want to cancel these settings, also click "View" in the menu bar, then "Freeze Panes" → "Unfreeze Panes", so that just now The setting is cancelled.

How to freeze a row in a table

The above is the detailed content of How to freeze a row in a table. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template