Want to change current prices in a column by a percentage

[Guest]

Hi

I currently have a spreadsheet that contains cost prices in columns. I want
to increase these prices by say 35% but don't want to have to insert columns
and formulae to recalcuate each column. I know that there is a quick way of
doinf this by highlighting the column but can't remember how.

Thanks


Sharon

 

[Guest]

Enter 1.35 in a blank cell and COPY. Highlight columns to be updated,
Edit==>paste special==>Operation==>Multiply. Delete "helper" cell.

Test before committing!

 

[Guest]

Thanks for the advices - excellent worked first time.