Home >Topics >excel >How to quickly scroll down to the bottom in excel

How to quickly scroll down to the bottom in excel

青灯夜游
青灯夜游Original
2021-02-05 14:36:57110034browse

How to quickly pull down to the bottom in excel: 1. In the excel table, click on the cell in the first row at the top; then place the mouse on the bottom edge of the cell, a black cross pointer will appear, and double-click the mouse. 2. Click on the cell in the first row at the top and use the shortcut key "CRTR Down Arrow" directly.

How to quickly scroll down to the bottom in excel

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

When we use excel to edit a table, we often pull up and down to the bottom to view the summary data. If there is little data, we can pull slowly, but if there is a lot of data, it is very troublesome to pull to the bottom. things. Here’s how to get to the bottom quickly.

Method 1:

1. Open a test form with a lot of data. The last page is the summary data, which is no longer the first page. The last data is the summary data.

How to quickly scroll down to the bottom in excel

How to quickly scroll down to the bottom in excel

2. Click on the top cell.

How to quickly scroll down to the bottom in excel

#3. Place the mouse on the bottom edge of the cell, and a black cross pointer will appear.

How to quickly scroll down to the bottom in excel

4. Double-click the mouse, and we can see that the focus can quickly reach the bottom.

How to quickly scroll down to the bottom in excel

Method 2:

Click on the top cell, and then press the shortcut key "CRTR Down Arrow" to go directly last row.

How to quickly scroll down to the bottom in excel

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of How to quickly scroll down to the bottom in excel. 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