| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do i apply the same formula for different cells in excel?
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do i apply the same formula for different cells in excel?
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I apply a formula to all cells even those with < signs? | Excel Worksheet Functions | |||
| How to apply a formula to all cells in a column | Excel Worksheet Functions | |||
| apply a formula to multiple cells | Excel Discussion (Misc queries) | |||
| How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
| How do I apply a combo box to multiple cells in Excel so that it . | Excel Discussion (Misc queries) | |||
Linear Mode
