Trying to get a function for a whole column...

  • Thread starter Thread starter floyd605
  • Start date Start date
F

floyd605

Hi. I am very new to Excel. I am trying to get the each cell in colum
L to be the answer to each cell in column K divided by 30. Hel
please! I know this is probably elementary for everyone here
 
One way

in L1 (or whatever the address is to the first adjacent cell in K)

=K1/30

copy down
 
Floyd,
A quick way to perform the copy down is to double click on the black square in the lower right corner of the selected cell.

Good Luck,
Mark Graesser
(e-mail address removed)

----- floyd605 > wrote: -----

Hi. I am very new to Excel. I am trying to get the each cell in column
L to be the answer to each cell in column K divided by 30. Help
please! I know this is probably elementary for everyone here.
 
Back
Top