Excel2010 Practical Skills Daquan

Source: Internet
Author: User

   1. Double-click a cell to move the selected cell

In an Excel table, if we want to move a cell's data quickly, just select the cell, and if you want to move to the right, just select the cell, move the mouse pointer to the right of the cell, and then press and hold it to the right, and then move in the other direction.

  2. Quickly select discontinuous cells

Before we want to select a discontinuous cell, many people may use the continuous hold down CTRL key and then click the cell, in fact, without this trouble, in the Excel2010 has a "add selected" mode, as long as you press the SHIFT+F8 at the same time, you can enter the Add selected mode, We can click on the discontinuous cell.

  3. Smart variable text as a number

When we copy some data, we sometimes find that some data is imported into Excel in the form of text, in Excel, the numbers are aligned to the right by default, and the text is left, so what do we do to solve this situation? One way to do this is to quickly convert text formats into digital formats, First we enter a blank cell in a number 1, select the cell after the copy, then select the need to adjust the range, sticky paste when choosing the "selective sticky" in the "multiply" this time you will find that the content from the text format into the number format.

4. Select cells based on criteria

In the Excel2010 has a positioning function, click F5 can be opened positioning function, in the positioning function we can according to their own positioning criteria to choose the type of cell, the condition is set up after the desired cell data can be found.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.