Data manipulation in spreadsheet

[Packer]

I need to adjust values in columns by a fixed percentage for a range of data in an Excel spreadsheet. Is there a simple(ish) way to do this rather than changing every entry manually?

 

[richie]

one way of many, add a column

then =a1*10%

a1 presuming that a1 is the cell that needs changing

then double click bottom right hand corner and it will fill all the rest in all the way down.

This is not the only way, or the best way BTW

 

[richie]

Video here

http://www.motomunster.com/flash/addpercentage.swf

 

[Packer]

one way of many, add a column

then =a1*10%

a1 presuming that a1 is the cell that needs changing

then double click bottom right hand corner and it will fill all the rest in all the way down.

This is not the only way, or the best way BTW

Ah, but if I do that and then delete the original column my new column loses its data source. That's why I want to change the existing column data

 

[richie]

Ah, but if I do that and then delete the original column my new column loses its data source. That's why I want to change the existing column data

Select column, edit/copy

then make another column

edit/paste special, paste as values....

Thank me later

 

[ianf]

or put your scaling factor in a cell, copy the value, then select the range you want to change and do paste-special selecting multiply.

This changes the cell values, the better way as suggested is to put =<ref>*factor in a new cell at the top, next to the one you want to change <ref> and then drag the result down next to your originals.

 

[Grey Beard]

If you don't want to see one of the columns, use Data/Group to collapse that column.

Grey Beard

 

[Packer]

Thanks guys, I'll try those options tomorrow.