Tips and tricks: Excel double click magic

Everyone knows that the excel function is very powerful. If we do not pay attention to the techniques and methods when dealing with huge data information with Excel XP, it will probably take a lot of effort. So how to use Excel to quickly input information has become a topic of great concern to Excel XP users. But this is not the focus we are going to talk about today. Today, we will introduce you to the magic of double-clicking in Excel. Do you know?

1. Smart Window

If you look closely, you may find that there is a folded button in the area adjacent to the vertical scroll bar with the black triangle button. Double click (double click below) Refer to double-clicking the left mouse button) to divide the current window into two. Double-click the folded button on the right side of the horizontal scroll bar to divide the current window into two.

2. Adjust the column width

The text or number in the cell is not displayed or displayed as # when the column width is not enough. You can point the mouse to this column column. Right border line, double-click when the mouse pointer changes to the left and right double-headed arrows, you can get the most suitable column width, that is, the column width just accommodates the longest content in the cell, and the most suitable row height can be obtained in the same way.

3. Fast Move

Use the mouse to move the cell pointer quickly over a long distance. If there is a continuous data in A1:A30, if you want to move the cell pointer from A1 to A30 quickly, just double-click the bottom border of A1 cell, and the cell pointer will move down quickly until the last one is not blank. Until the cell, to make the cell pointer move quickly to the right on continuous data, double-click the right border of the cell.

4. Filling regular data

A column (left or right column) of a column already has data or text. To get regular data or text in the column, double-click The mouse can be quickly filled, as follows: To get the same column of data, text, or copy formula, just type in the first cell of the column, then double-click the fill handle in the lower right corner of the cell. You can quickly fill in this column until the blank cell; to get the arithmetic progression, just enter the first two data of the arithmetic progression in the first and second cells of the column and select them with the mouse. Double-click the fill handle in the lower right corner to quickly fill until the blank cell.

Double-clicking can achieve many purposes, such as opening a document, etc., all of which are double-clicked in Excel. Xiaobian thinks that many students still don't know, so take a look at it.