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. Qiaofen 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 to double click the left mouse button) It can divide the current window into the next 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 When the column width is not enough, the excess width portion is not displayed or displayed as #, then you can point the mouse to the right boundary line of the column column, wait for the mouse pointer Double-clicking on the left and right double-headed arrows gives you 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
The adjacent column (left or right column) of a column has data or text. To get regular data or text in the column, double-click the mouse to quickly fill it. As follows: To get the same column of data, text or need to copy the formula, just enter the content in the first cell of this column, then double-click the fill handle in the lower right corner of the cell to quickly fill in this column. Until the blank cell; to get the arithmetic progression, simply enter the first two data of the arithmetic progression in the first and second cells of the column and select them, double-click the fill handle in the lower right corner with the mouse. , you can quickly fill until the blank cell.
Double-click can achieve a lot of purposes, such as opening a document, etc., is a double-click in Excel, the small series thinks that many students still don't know, then hurry to see it