Forum Discussion
Dragging formulas
Can anyone help with this, I am trying to drag formulas horizontally from different workbook tabs. However when I drag formula it changes the cell rather than the workbook. i.e. following on...
Copy a formula by dragging the fill handle
Select the cell that has the formula you want to fill into adjacent cells.
Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:
Drag the fill handle down, up, or across the cells that you want to fill. ...
When you let go, the formula gets automatically filled to the other cells:
Select the cell that has the formula you want to fill into adjacent cells.
Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:
Drag the fill handle down, up, or across the cells that you want to fill. ...
When you let go, the formula gets automatically filled to the other cells: