• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel question

OutHouse

OutHouse

Lifer
ok this one is an easy one but i cant remember how to do it and the help isnt providing any "help"

Im building a materials pricelist. I want to multiply column A and Column C and put the results in column E. Ok I know how to do that, but how do I apply that formula all the way down column E for each row without typing it in each time?
a6*c6, a7*c7,a8*c8...
 
go to E1, do a copy, then select everything passed E1. and do a paste special.


or what you can do is, copy and paste in like 3 cells, then highlight them, and then go to the corner of that highlighted ares and drag down.





dam()
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top