The "camera with Excel"

 function that will to work table of some area "filming" and "pictures" will also be "photographed" with regional changes, when we need to track data in some area

The changing situation, the function is very useful.

In 2003, the default "Excel camera" command has not appeared on the toolbar. Use the following Microsoft Office 2010 is so great.

method can be added to the command toolbar. Click the menu "tool - from the definition," in "customize" dialog box

On the left of the "category" area "tool", and then choose the right "commands" area "camera", will find its dragged menu bar or toolbar at any position. Office 2010 is my favorite.

"Camera" method of use: choose somewhere needs to be "filming" areas, in toolbars click "camera" the order, then placed in need "photograph" position click, it would produce a picture Microsoft Office is helpful.

with the original area

Identical pictures. When the area of the data modified, pictures of data within would change accordingly

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

In Excel if you want to select a larger area, such as A1: G3000, direct dragging the mouse choose appears very complicated. You can use the following methods: Outlook 2010 is powerful.

In the edit field on the left of the "name" in the direct input box to the selected area A1: quote, such as G3000, then press enter can. In addition, if want to choose multiple areas, such as A1: B200, D20: F300, still can be in editing Office 2007 can make life more better and easier.

Column type "A1: B200, F300 D20:", then press the return key, pay attention to between various regions in English commas. Microsoft outlook 2010 is convenient!