Multipication of cells by same number (2000)

Topic

New Reply

What is the easiest and best way to multiply all numbers on the graph by 1.76, seee screen shot.
All numbers show need to be multipled by 1.76

Reply | Quote

Replies

Enter 1.76 in an empty cell.
Copy the cell to the clipboard.
Select the range with the cells you want to multiply.
Select Edit | Go To…
Click Special…
Select the Constants option.
Click OK.
Select Edit | Paste Special…
Click the Multiply option.
Click OK.
You can now clear the cell in which you entered 1.76

Reply | Quote

That is very impressive Hans,
Exactly what l required.

Many many thanks for that.

Reply | Quote