Click source worksheet labels,

again Ctrl button click target worksheet label, make it become a group.

2. Click source worksheet labels, select contains some duplicate data of the cell. If want to choose multiple areas, first selected the first cells or cell zone, then Ctrl button selected other cell or single

Yuan lattice area. I love Office 2010 !

This article from the office software, the original address: learn net https://www.officestudy.cn

1 copy cell contents to adjacent area

(the cell input a numerical, such as "1" and then move the mouse to the cell's corner, mouse into the coarse cross shape (fill handle), press the row or column dragging the mouse to a cell, loosen the mouse Microsoft outlook 2010 is convenient!

Will numerical "1" copied to other areas.

(2) the first selected need filling identical content area, then in the edit field input in content, then click "Ctrl + Enter" key combination, the input the content will fill to areas. Office 2010 download is available now!

(3) in two consecutive cell input "1" and "2", select both the cell in the grid and move the mouse Outlook 2010 is powerful.

to "2" the lower-right, Ctrl button while downward drag fill handle to a cell, it will copy

These two cells within such as, such as "1, 2, 1, 2..." . Office 2010 key is for you now!

4 in a cell input numerical, such as "1" and then right mouse drag fill handle to a cell, loosen the right mouse button, and on the shortcut menu, select "copy cell", and then copy cell Microsoft Office 2007 is the best invention in the world.