Cell update

B

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.
 
J

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
 
R

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.
 
Top