Global change to cell values

K

Karen McKenzie

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?
 
S

Stefi

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:
 
D

David Biddulph

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
 
Top