Home  >  Article  >  Topics  >  How to quickly select a column of data

How to quickly select a column of data

藏色散人
藏色散人Original
2021-04-26 16:44:37104321browse

How to quickly select a column of data: first open the target file; then use the mouse to select a cell in the target column; then press [Ctrl Shift Down Arrow Key] on the keyboard at the same time to quickly select a column of data .

How to quickly select a column of data

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

Use shortcut keys to select a column of data in excel:

1. First, use the 2007 version of excel software to open the target file on your computer.

How to quickly select a column of data

#2. Then use the mouse to select a cell in the target column, as shown in the figure.

How to quickly select a column of data

#3. Then press "Ctrl Shift Down Arrow Key" on the keyboard at the same time, as shown in the figure.

How to quickly select a column of data

#4. After completing the above settings, you can use shortcut keys to select a column of data in excel.

How to quickly select a column of data

[Recommended learning: Excel tutorial]

The above is the detailed content of How to quickly select a column of data. 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