Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging Down a Formula
Now my actually case is more complicated than this, but I think if someone
explains this to me, I'll be fine. say i have a formula in cell b1 that is =a1*2 now in b2 i would have =a6*2 and in b3 i would have =a11*2 and continue to increase the cell value by five. Can i do this be just dragging down the corner rather than entering them manually? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging formula | Excel Discussion (Misc queries) | |||
Dragging a formula correctly? | Excel Worksheet Functions | |||
dragging a formula down a column | Excel Worksheet Functions | |||
when dragging formula how do i avoid #DIV/0! | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) |