I am trying to set up and excel sheet. I need to divide several row
separately by one number and I am having a hard time.

I know if I have the number in i.e, d5 and my column is c, then I will need
to do the formula as this: c?/d$5. Is this correct and if so, how do I make
this formula enter into the entire "c" column without having to type it over
and over?