How to quickly enter data in Excel2010

Source: Internet
Author: User

In the work we often want to use Excel, this tutorial for you to introduce fast data input methods, to provide everyone's work efficiency.

Adjust settings

To wrap text in a cell, select the cell that you want to format, and then on the Start tab, in the Alignment group, click Wrap Line.

To set column widths and row heights to automatically adjust to the contents of a cell, select the column or row that you want to change, and then on the Start tab, in the Cells group, click Format. Under Cell size, click AutoFit Column width or auto adjust row height.

Enter data

Click a cell, and then type the data in the cell, and press ENTER or tab to move to the next cell. To enter data in a separate row in the cell, press Alt+enter to enter a line break.

To enter a series of contiguous data, such as a date, month, or progressive number, type the starting value in a cell, and then type a value in the next cell to create a pattern. For example, if you want to use series 1, 2, 3, 4, 5 ..., type two and 1 in the first 2 cells. Select the cell that contains the starting value, and then drag the fill handle to cover the entire range you want to fill. To fill in ascending order, drag from top to bottom or from left to right. To fill in descending order, drag from bottom to top or from right to left.

Set data format

To apply a number format, click the cell that you want to format the number in, and then on the Start tab, in the number group, point to General, and then click the format that you want to use.

To change the font, select the cell that you want to format the data in, and then on the Start tab, in the Font group, click the format that you want to use.

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: 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.