Want to change current prices in a column by a percentage

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

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!

"Sharon43" wrote:

> 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

Thanks for the advices - excellent worked first time.

"Sharon43" wrote:

> 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