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.