Home > Topics > excel > How to quickly select the entire table

How to quickly select the entire table

步履不停
Release: 2019-06-13 16:03:56
Original
23652 people have browsed it

How to quickly select the entire table

Have you ever had this experience: You want to select the entire table, but there is too much data and you can’t finish it no matter how you pull down. Use Ctrl A to quickly solve this problem.

Ctrl A

Select the entire continuous area.

How to quickly select the entire table

Ctrl A

Everyone should know that if you want to select the content of multiple areas, you can do it by holding down Ctrl.

Ctrl

Continuously select multiple areas

How to quickly select the entire table

Ctrl

The following is the key point , what if I want to fill content in these selected areas? This requires Ctrl Enter.

Ctrl Enter

Fill the content in the selected area at once.

How to quickly select the entire table

Ctrl enter


Some friends said: There is no problem in selecting all data, then I just want to Select a part, but there is a lot of data? Don't worry, Shift will take care of it for you.

Shift

Select a continuous area.

How to quickly select the entire table

shift

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of How to quickly select the entire 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