Data out how to excel as a whole increases, negative

in the blank cell, type -1, copy, require changes in the data, right-click – Paste — – By, the original data can be classified as A, B out in the B1 enter =”-“& A1

and then drag it down.Upstairs approach also can be, but a little trouble, my way More simple than you.We learn from each other.Select the data need to change in the region in accordance with the original copy, in other regions according to the Paste Special, by the election options, all of the data combined with the negative, then the original Data can be replaced.More than just the mouse steps can be completed.