| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Multiplier
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Multiplier
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 Replace @mailinator.com with @tiscali.co.uk "Dave" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can prices be changed by one multiplier? | Excel Discussion (Misc queries) | |||
| updating a range of cells by a multiplier | Excel Worksheet Functions | |||
| Counter variable and a multiplier | Excel Discussion (Misc queries) | |||
| how to create a repeat formula using the same multiplier? | Excel Worksheet Functions | |||
| Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Linear Mode
