Cell update

[Bob]

Is there a way to update the values in cells on a
worksheet all at once? To multiply the values by a
percentage and display the result in the cells.

 

[Jason Morin]

1. Type your % into an open cell (for example 15%).
2. Copy the cell.
3. Select all the cells with which you want to multiply
the %.
4. Edit > Paste Special > Multiply.

HTH
Jason
Atlanta, GA

 

[Robert Christie]

Hi Bob
Assuming values are in columnA in a helper column enter
=A1+(A1*10%) filldown then Copy helper column, select
column A and PasteSpecial --> Values. Then delete helper
column.

HTH
Bob C.