Same Formula, multiple columns, worksheets

[Madham]

I have a tariff document with pricing in it. It is 21 worksheets in the same
workbook. I want to increase columns D-I, rows 2 - 52 in each column, on
every single worksheet, by 20%.

Worksheet 1 is for Asia, cell D2 is minimum $290. Cell E2 is Asia-Europe at
$4.19.
Worksheet 2 is for USA, cell D2 is minimum @340. Cell E2 is US-Africa at
$6.32.

Can I get WRKSHT 1, cell D2 to change to $348, and E2 to $5.03, and get
WKRSHT 2, cell D2 to $408, E2 to $7.58 in one command?

How can I do this? Thanks.

 

[Pete_UK]

Increasing a cell value by 20% is the same as multiplying by 1.2. To
do this in one operation over a number of cells, enter the value 1.2
in a blank cell somewhere, and then <copy> that cell. Highlight all
the cells that you want to increase and click on Edit | Paste Special
| Values (check) | Multiply (check) | OK then <Esc>. Then you can
remove the 1.2 from the original cell.

Hope this helps.

Pete