In Office 2007 Excel, to the distance of the two columns of data (such as column A and Z columns) were compared, only constantly on the move within the table window, respectively, the horizontal scroll bar to view, this operation is very cumbersome and error-prone . Use the following tips, you can be a data table “change” into two, so far away from the data with display. The mouse pointer on the bottom of the sheet a small piece of the horizontal scroll bar on the right side of the mouse pointer will become a bi-directional cursor.

This small piece onto the middle of an Excel worksheet, you will find the entire worksheet is divided into two, there were two data frames, which are the contents of the current worksheet. So you can make a data box displays the data in column A and one column data box shows the data Z, which can be easily compared.

Excel how to eliminate the calculation of shrinkage bit error: Sometimes we enter the numbers after the decimal point two digits, but in accuracy as long as one, abbreviated after the show no problem, but the results but they are errors. The solution is: Click “Tools → Options → recalculate”, select “to show the value of subject”, so there is no error of calculation.

In fact there is not a calculation error, but rather a set of rounding. Using this technique provides a method that can solve the display problem, but will change the value of precision in the use of Excel will give you a warning before. If an Excel worksheet in a large number of digital formats, and you want to take all the negative numbers, use the Paste command.

Operation as follows: in an empty office 2007 download Excel cell type “-1″, select the cell, and click the “Edit → Copy” command, select the target cell. Click the Excel “Edit → Paste Special” command, select the Paste column values ​​and by computing the column, click “OK”, all numbers will be multiplied by -1. You can also use this method to reduce the value of the cell 1000 or greater multiples.

In actual operation, we sometimes need to quickly change the order of cell contents, the specific methods of operation are: First, the selected cell with the mouse while pressing the Shift key on the keyboard, then move the mouse pointer to the cell edge, until Drag the arrow pointer appears, then drag and drop.
While dragging the mouse up and down between the cell boundary will become a level “workers”-shaped logo, so drag will become vertical “workers”-shaped logo, release the mouse button to complete the operation, the order between the cells that changed .

Data on the introduction page to Microsoft office 2007 Excel spreadsheet: The information in tabular form on the page can be copied directly from the browser into Microsoft office 2007 Excel, and excellent results. In Excel, you can use an Excel worksheet as open as Html files, and get the same features, format and edit mode.
Available online Excel-generated graphics: Excel is one of the important functions can be quickly and easily generate data in the worksheet column, pie, line, etc. analysis graphics.To be used in Web publishing and report such to indicate class decorative graphic, first click the “Tools → Options” command.

In the “General” select “Web Options”, choose whether to adopt the Portable Network Graphics format (PNG) to store files, to speed up download speed and reduce the magnetic storage space, but pay attention to the graphics file format will require browser support not suitable for all browsers. If you do not select the PNG graphics format, Excel will automatically select and converted to GIF, JPG format, and create a file called “file name files” sub-folder to save the converted graphics.

Text box text and diagrams to establish the link: blank in the Excel worksheet cells enter the text you want to link, click to select the chart, in the edit field, enter an equal sign, and then click the link text contains the cell, then press Enter the text to appear somewhere in the chart on.

Whenever an office 2007 download Excel worksheet cell changes within the text, the text within the chart along with the change. But to note is that once you cancel the selected text box, it is difficult to re-use the mouse to select the text box to further modify, then you can use our chart elements introduced earlier selection method, using the arrow keys to move Select the chart element.

Word list and actually add multi-level bulleted or numbered list is similar, but the multi-level list of bulleted or numbered each paragraph indented under the scope of change.Multi-level list is based on the paragraph indent Word format using bullets and numbered list of features multi-level menu automatically generates up to nine levels of symbols or numbers.

Use as follows: the need for input to the numbered paragraphs in Word, and using different indentation that different levels. Do not indent the first layer. Indented from the second floor, you can use Word format tool in the “Increase Indent” and “decrease indent” button.

From practical experience, the indent of the control is a problem: indent between levels should be consistent, otherwise the use of multi-level list the number of errors may occur.Therefore, the second layer can be transferred to indent marker 1 position transferred to the third layer position marker 2, and so on, so that the indentation remains between levels on a scale of distance.

And select List. In the Microsoft office 2007 Word “Format” menu, select “Bullets and Numbering”, click the “multi-level symbol” command. In the pre-specified number of multi-layered style in select multi-level list style, then if you need to paragraph numbers in front of the article should select the “continue previous list”, then select the  Word requires a separate number in the “Restart Numbering”, select OK .

In Word, Equation Editor is the need to take up a lot of system resources, use the Equation Editor users often feel when the computer slows down. One way to indirectly address this issue. When you want to edit or insert a formula, first open a new Word document, file transferred to the new “Equation Editor” edit the formula, then define the formula block, press Ctrl + C key combination to copy in the clipboard.

Press Alt + Tab key combination to return to the original office 2007 download Word document, or from the “Window” menu, select the original file for editing, press the key combination Ctrl + V to paste the formula into the text. When you need to insert or edit a formula once again, simply press Alt + Tab back to the “Equation Editor” button, keep the front of the formula allows the user to the “Equation Editor” and copy the formula in the same part, thereby speeding up the editing speed.