All the value added in the excel spreadsheet 100 how simple operation

CodePudding user response:

Requirements described in detail, the best can explain the appended drawings, is taking just the value of the additive is equal to 100 or take nearly 100 the number of combined at random?

CodePudding user response:

Enter 100 in a space, select, copy, select the region needs to add 100, "paste special", select the "add" operation, sure,

CodePudding user response:

refer to the second floor zara's reply:

enter 100 in a space, select, copy, select the region needs to add 100, "paste special", select the "add" operation, sure.

Don't I want to the

=XXX + 100??

CodePudding user response:

=x + 100

CodePudding user response:

=where cell data + 100, and then to down can

CodePudding user response:

Write 100, beside you all Numbers and then choose your data + 100 row sum

CodePudding user response:

All selected values, enter 100, press CTRL + enter

CodePudding user response:

On the third floor is the solution, test and correct

CodePudding user response:

+ 100=each cell, then any other format