Alright it's going to be very hard for me to explain this.
I have a column. Column J
I need the entire column to have the function =Product(H?:I?)
I need to know how I can do this since i'm messing with almost 3,000 rows.
The question marks refer to the row intersecting at column J. I need Excel to input this function all the way down to line 2835 so I don't have to keep typing in =product(H51:i51) [enter] every time I want the Product of cells H51 and J51.
is there a quick way to do this? or am I stuck typing it in every cell?
~Helio
Bookmarks