Multiplier

[Dave]

I'm creating a spreadsheet for work, and I would like to use one multiplier
throughtout the entire spreadsheet, instead of having to enter repeatedly
putting in the same forumula over and over again.. the cells contain
different numbers but the multiplier will always be the same.

 

[Sandy Mann]

Enter the multiplier in an unused cell then highlight the range that you
want to update and the right-click and select Paste Special, (or select Edit

Paste Special), then select Multiply

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk