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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Autonumber field in Excel that behaves the same as Access 0
Cumulative formula for word table 0
Word macro that can call cells out of Excel for a find and replace 0
Setting column width in a table with a macro is not working 0
Calculate the median value before a specified list 0
Copy addition formula of non-consecutive horizontal cells 2
Consolidation Table from Different Excel Tabs with Different Format 1

Top