excel2010 What's the effect of double-clicking?

Source: Internet
Author: User
Tags arithmetic split

excel2010 What's the effect of double-clicking?

excel2010 Double click

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.