How do i apply the same formula for different cells in excel?

T

Tristan

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.
 
G

Gary''s Student

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.
 
Top