How To Do Just About Everything
For instance, we have finished a EXCEL workbook,but want to modify the one (colum), such as: we want to add each data in colum A plus 8, on this issue, we naturally think of the use of the formula, when you use the input A1 = A1 +8, you will get a warning EXCEL: "MICROSOFT EXCEL can not calculate the formula……" Only we ourselves would like to approach, introduced here A simple method.
insert a new provisional colum B befor the colum A which is wanded to be changed , and fill the first cell in row B with 8.
Put the mouse on the bottom corner of cell B1, wait until a cross after living down the length of the required data, at this time all of the B is filled with 8.
Right click mouse on row B,"copy" row B.
Right click row A and click "Paste Special" in the pop-up dialog box,select the "operation" you need an operator, we choose in this "add".Then colum A is changed.
Enthusiast 
