Hoping you guys could tell me how to do this...
http://img73.imageshack.us/my.php?im...adsheetqa6.jpg
In the example above, I want to times each Tot. by 2. I don't want to have to go through every single cell one at a time to do so. Is there a way that I can take Column I and make it so that every cell in that column is automatically * by 2?
For example, SP Zach Miller is a 30 Tot. so of course he would be a 60 after being * by 2... I want that... but for every cell. Is that possible without me having to go cell to cell and doing it manually?
Same question... this time for rows.
Yannick Caruso is listed as a 4/3/5... so add that up, and it'd be a 12. Is there a way to do that without doing it manually? Basically the same question as the columns... just flipped it to rows.
Basically I have a very low understanding of Excel, and I'd love any help I can get.
http://img73.imageshack.us/my.php?im...adsheetqa6.jpg
In the example above, I want to times each Tot. by 2. I don't want to have to go through every single cell one at a time to do so. Is there a way that I can take Column I and make it so that every cell in that column is automatically * by 2?
For example, SP Zach Miller is a 30 Tot. so of course he would be a 60 after being * by 2... I want that... but for every cell. Is that possible without me having to go cell to cell and doing it manually?
Same question... this time for rows.
Yannick Caruso is listed as a 4/3/5... so add that up, and it'd be a 12. Is there a way to do that without doing it manually? Basically the same question as the columns... just flipped it to rows.
Basically I have a very low understanding of Excel, and I'd love any help I can get.
Comment