Adjust cell values without a formula or temporary cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of values that are all off by 1000. I simply want to
highlight the range and somehow indicate to multiply all values by 1000. I
don't want to create a temporary range, along with a formula, and then
convert to values and copy back. Is there an easy way to do this?
 
In an empty cell, enter 1000, copy the cell. Then select the range,
right-click > paste special > multiply > ok.
 
Back
Top