I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.


--
Lynne Mawson
Manchester

One way:

Put 1.06 in an empty cell. Copy the cell. Select the values in the three
columns. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons. Click OK.


In article ,
Lynne Mawson wrote:

I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.

GE McGimpsey - you are a star! Saved me hours of messing around. Thanks.
--
Lynne Mawson
Manchester


"JE McGimpsey" wrote:

One way:

Put 1.06 in an empty cell. Copy the cell. Select the values in the three
columns. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons. Click OK.


In article ,
Lynne Mawson wrote:

I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the
6% to all 3 columns.