Increasing all values in spreadsheet by same percentage.

[Excels Alot]

I would like to know a simple way to increase all values in data cells by the
same percentage. I can't figure out how to write the formula that will
increase the value and add it it the current number in each cell of the
spreadsheet.

 

[Dave Peterson]

Say you want to increase a range of numbers by 38%

Put 1.38
in an empty cell
Edit|copy (that cell)

Select the range to adjust
Edit|Paste special|check Multiply and Values
Then clean up that cell with the 1.38 in it.