Global change to cell values

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

Guest

I have a spreadsheet that I'd like to divide all the numbers in a named range
by 1000 so that the new figures replace the original ones. Is this possible?
 
Hi Karen,

Enter 1000 in an unused cell,
Select that cell and press Ctrl+C (Copy)
Select your named range (type its name in the Name field and press Enter)
Edit/PasteSpecial/Check Operation option Division and press Enter

Regards,
Stefi


„Karen McKenzie†ezt írta:
 
Karen McKenzie said:
I have a spreadsheet that I'd like to divide all the numbers in a named
range
by 1000 so that the new figures replace the original ones. Is this
possible?
Click to expand...

Put 1000 in a spare cell, Copy
GoTo your named range, Paste Special/ Divide
 
Back
Top