EXCEL Tips: Batch modify data

 In the EXCEL spreadsheet data have been completed, how easy for any one column (row) of data to modify it?

 For instance, we do an EXCEL table, fill the data, and now want to modify a column (row), for example: like in the A column on the basis of the original data plus 8, there is no such formula? Not have to manually one by one, add the data to live? For this we naturally think of the use of formula, you use the public input A1 = A1 8, you will get a warning EXCEL: "MICROSOFT EXCEL the formula can not be calculated ... ..."Only we ourselves think of a way out, and here a Kinds of simple methods:

 The first step:

 You want to modify the column (assumed to be A column) next to insert a temporary new column (for the B column), and the first column in the B cell (B1), enter 8.

 Step two:

 B1 or the mouse on the bottom corner, wait until after the live cross down into the data until the desired length, then all of the data column B 8.

 The third step:

 In the B column, click the right mouse button, "Copy"B column.

 Step four:

 A column in the right-mouse click in the pop-up dialog box, click "Paste"in the pop-up dialog box, select "operation" in the operator you need, here we choose "add" This is the key to this method.

 Step five:

 The B column removed.

 How? A column with each of the data is not all 8 it? The same approach can be achieved on a column (row) of multiplication, addition, subtraction, and other computing operations. The format of the original form has not changed.

 At this point the end of the work, the use of skilled, it will take less than ten seconds.