Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to use a formula to calculate values into a column and they
require the values directly to the left of them to be divided by a single cell. So the numerator will be a new number each row down, but the denominator needs to be the same cell. I was wondering how to tell all the cells in the column to use that same reference cell instead of having each successive row use the next row down under the reference. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you turn off the Autofill Options box when dragging cells. | Excel Discussion (Misc queries) | |||
copying/dragging a formula to adjacent cells in Excel | Excel Discussion (Misc queries) | |||
Odd behaviour in dragging data across and up and down cells | Excel Discussion (Misc queries) | |||
How do I keep a formula constant in dragging cells below the rows | Excel Discussion (Misc queries) | |||
Copy and dragging cells | Excel Worksheet Functions |