1. The artful points window

03/09/2011 18:06

 

If you observe carefully may find that in Excel vertical scroll bar above with black triangles button adjacent place, a fold, double click the button (hereinafter double-click shall mean double-click I love Office 2010 !

the mouse) it, it will

The current window split up and down, Double-click the horizontal scrolling right fold button, can be in the current window or so in two.

2. Adjust column width Office 2010 key is for you now!

Cells within the text or digital among the wide when insufficient, beyond width part not display or display for #, the Russian listed mark the mouse pointing to the mouse pointer right boundaries, become the two-way arrow around when. Double click Office 2010 download is available now!

To the most suitable column width, namely column width just hold this cell is the longest in content, using the same way they can get the most suitable row height.

3. Move fast

Use the mouse pointer, can make the cell fast moving very long distances. If the whole A1: A30 there is a continuous data, if want to make the cell pointer from A1 quickly moved to A30, need to Outlook 2010 is powerful.

use mouse click A1 cell under the borders,

Cell pointer is fast moving downward, until finally a not blank cells so far, if want to make the cell in continuous data on a pointer to the right move quickly, then double-click the cell's right borders. Microsoft outlook 2010 is convenient!

4. Fill regular data

One column of the adjacent columns (left or right column) existing data or text in this column, if want to get regular data or text, double click the mouse can be rapidly fills, the method is as follows: to get the same column data, text or need Microsoft Office 2007 is the best invention in the world.

Copy formula, only in the first Russian within a cell with the mouse input content, then double-click on the lower right corner of the cell, can fill handle in Russian rapid filling, until the blank cells so far, If you want to get such difference