Dorky spreadsheet question

[Pulitzer Wannabe]

OK, I'm working in Google spreadsheets (yes, it's a fantasy basketball thing).

I'm trying to run a simple formula on every number in a column to convert them.

Do I have to do each one separately? Or is there a way to run a formula on every cell in the column?

 

[Big Buckin' agate_monkey]

Instead of the abstract, give us an example.

 

[Pulitzer Wannabe]

OK.

I have a long column of assists per game for each of the top 150 players in the NBA.

I want to highlight every one of them and divide them all by 4 at one time - so that instead of a raw number, I have their number in comparison to the league average.

How do I do this without going through 150 separate cells and retyping the entire formula in either Excel or Google?

 

[2muchcoffeeman]

OK, I'm working in Google spreadsheets (yes, it's a fantasy basketball thing).

I'm trying to run a simple formula on every number in a column to convert them.

Do I have to do each one separately? Or is there a way to run a formula on every cell in the column?

Definitely need an example.

And why the hell are you using Google Docs? Don't you have OpenOffice or MS Office or 1-2-3 or something similar?

 

[Big Buckin' agate_monkey]

In a cell next to it, put this formula =(cell letter/number)/4

Then copy it, highlight down to the end of the list and paste it. That should work.

 

[Pulitzer Wannabe]

Not working. Nothing seems to.

 

[Pulitzer Wannabe]

OK, I figured it out.

Thanks!

 

[Big Buckin' agate_monkey]

It's how I roll.

 

[Captain_Kirk]

you sure you're at the right website? perhaps you were looking for greeneyeshades.com