Home > Topics > excel > How to fold and expand tables

How to fold and expand tables

藏色散人
Release: 2023-01-13 00:42:39
Original
84295 people have browsed it

How to fold and expand the table: First open the EXCEL table, select the rows to be folded; then click "Data-Combination"; finally press "1" or "-" to collapse the data.

How to fold and expand tables

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

Method: Use the "combine" command.

First open the EXCEL table, select the rows to be folded (combined), and click "Data"--Combine.

How to fold and expand tables

After that, the cells in rows 1 to 6 are grouped together. At this time, press "1" or "-" to collapse them.

How to fold and expand tables

If you want to see the collapsed content, click the "2" or " " sign.

How to fold and expand tables

Recommended study: "Excel Tutorial"

The above is the detailed content of How to fold and expand tables. 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