Excel tips: Double-click the magical

1. Clever Division window

If you look carefully you may find that in the Excel vertical scroll bar with the black triangle button adjacent to the place, there is a folded button, double-click (double-click the following double click) it, you can split the current window up and down; Double-click the folded button on the right side of the horizontal scroll bar, The current window can be split in half.

2. Adjust column widths

The text or number in the cell is not in column width, the width portion is not displayed or displayed as #, you can point to the right border of the column column, and when the mouse pointer changes to a double-headed arrow, you can get the most appropriate column width, which is just the longest content in the cell, and the same way you can get the most appropriate row height.

3. Fast Moving

With the mouse, you can quickly move the cell pointer a long distance. If there is a continuous data within the A1:A30, to move the cell pointer from A1 to A30, simply double-click the bottom border of the A1 cell, and the cell pointer moves down quickly until the last cell is not empty, so that the cell pointer moves to the right fast on the continuous data. Double-click the right border of the cell.

4. Fill with regular data

There is already data or text in the adjacent column (left or right) of a column to get regular data or text in the column. Double-click the mouse to quickly fill, as follows: To get the same column of data, text, or need to copy the formula, just enter the contents of the first cell in this column, and then double-click the padding handle in the lower-right corner of the cell with the mouse , you can quickly populate this column until you have blank cells; to get arithmetic progression, just enter the first and second cells of the column in arithmetic progression and select them, and double-click the fill handle in the lower right corner to quickly populate until the blank cell.