Multiplier

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 03 Oct 2007 18:52 GMT

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.

Reply to this Message

Sandy Mann - 03 Oct 2007 19:09 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

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

Reply to this Message