Say we have numbers in column A from A1 thru A100. In column B we want the
value in column A divided by 5.

Select cells B1 thru B100 and enter:

=A1/5

Instead of using the ENTER key to complete the entry, use
CNTRL-ENTER

this will put the correct formula in all the B column cells.
--
Gary''s Student - gsnu200727


"Tristan" wrote:

i have these set of values in a column, how do i apply the same formula to
all of the values in the column? sorry please help.