Home > Topics > excel > How to fix table area in excel

How to fix table area in excel

coldplay.xixi
Release: 2021-01-02 11:25:53
Original
43252 people have browsed it

How to fix the table area in excel: first move the mouse to cell O5 and click; then keep the cursor at cell O5, and select "View - Freeze Panes" in the toolbar. -Freeze Split Panes".

How to fix table area in excel

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to fix the table area in Excel:

1. First, move the mouse to cell O5 (the next cell next to the row to be fixed) ) and click to make the cell selected, as shown in the figure.

How to fix table area in excel

2. Keep the cursor in cell O5, select "View" - "Freeze Panes" in the toolbar - click "Freeze Split Panes" ",as the picture shows.

How to fix table area in excel

3. Return to the document, continue dragging or scrolling the table, and you will find that rows 3 and 4 have been fixed at this position. At this point, all operations are completed, and the process is very simple, as shown in the figure.

How to fix table area in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to fix table area in excel. 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