With the passage of time, the Office has become an indispensable tool to master the operation of the office software skills necessary technical means, following an application in Office 2007 Excel skills to share, we want to help.
Office 2007 Excel in two data (such as column A and Z column) distance compared to only constantly on the move within the table window, respectively, the horizontal scroll bar to see, this is a very complex operation and error-prone. Use the following tips, you can "change" into a data table, away from the data display. The mouse pointer on the right side of the small piece of paper at the bottom of the mouse pointer on the horizontal scroll bar will become a bi-directional cursor.
A small piece of this to an Excel worksheet, you will find the entire work is divided into two, with two data frames, this is the contents of the current worksheet. This allows a data frame to display data in the column and a data box shows the data Z, you can easily compare.
How to eliminate the abbreviated calculation error in Excel: Sometimes, we enter the two digits after the decimal point, but as long as accuracy, referred to after the show there is no problem, but the result, but they are wrong. The solution is: click "Tools → Options → recalculate", select "Show the value of the subject, so there is no calculation errors.
In fact, not a calculation error, but rather a set of rounding. Using this technique provides a way to solve the display problem, but will change the exact value to use in Excel, and will give you a warning before a. If a large number of digital format an Excel worksheet, you have to take all negative, use the Paste command.
As follows: Download Office 2007 in an empty cell in Excel, enter "-1", select the cell, click Edit → Copy command, select the target cells. Click on the Excel's Edit → Select selective paste "command, select" Paste column values, and computed column, click "OK" all the numbers will be multiplied by -1. You can also use this method to reduce the value of the cell 1000 or greater multiples.
