Multiplier

D

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

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
Click to expand...

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top