Multiplier

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

Guest

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

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