Using relative copy, you can easily create number sequences or apply formulas to a series of numbers.[br][b]Note:[/b] If you relative copy formulas to other cells, by default all references are changed according to the target position. 

Create a number sequence in column A and relative copy a formula that contains cell references.

[table][tr][td][size=100]1.[/size][/td][td][size=100][b]A1[/b][/size][/td][td]Enter [code]1[/code] into cell [b]A1[/b] and [code]2[/code] into cell [b]A2[/b].[/td][/tr][tr][td][size=100]2.[/size][/td][td][size=100][icon]/images/ggb/toolbar/mode_move.png[/icon][br][/size][/td][td][size=100]Highlight both cells [b]A1[/b] and [b]A2[/b] and drag the little square in the lower right corner of the highlighted area down to cell [b]A10[/b].[br][/size][/td][/tr][tr][td][br][/td][td][br][/td][td][b]Note:[/b] You just used relative copy to create the integers from 1 to 10 in cells [b]A1[/b] to [b]A10[/b]. [br][/td][/tr][tr][td]3.[/td][td][b]A2[/b][/td][td]Change the number in cell [b]A2[/b] to 3.[br][/td][/tr][tr][td]4.[/td][td][icon]/images/ggb/toolbar/mode_move.png[/icon][br][/td][td]Highlight both cells [b]A1[/b] and [b]A2[/b] again and relative copy the new values to the other cells to update the number sequence.[/td][/tr][/table][size=100][table][tr][td][size=100]5.[/size][/td][td][size=100][b]B1[/b][/size][/td][td][size=100]Enter the formula [code]=A1/2[/code] into cell [/size][size=100][b]B1[/b][/size][size=100]. [/size][/td][/tr][tr][td][size=100]6.[br][/size][/td][td][icon]/images/ggb/toolbar/mode_move.png[/icon][br][/td][td][size=100]Relative copy the formula from cell [/size][size=100][b]B1[/b][/size][size=100] down to cell [/size][size=100][b]B10[/b][/size][size=100].[br][b]Hint:[/b] Only select cell [/size][size=100][b]B1[/b][/size][size=100] and drag the lower right corner of the highlighted area to relative copy its formula to the other cells. [br][/size][/td][/tr][tr][td][size=100]7.[br][/size][/td][td][icon]/images/ggb/toolbar/mode_move.png[/icon][br][/td][td][size=100]Double click on any cell in column [i]B[/i] to check which formula calculated the number value.[/size][/td][/tr][tr][td][size=100]8.[br][/size][/td][td][b]A2[/b][/td][td]Change the number in cell [b]A2[/b] to 5 and update the number sequence by using relative copy.[br][b]Note:[/b] All numbers in column [i]B[/i] will adapt to your changes.[br][/td][/tr][/table][/size]

If you want to refer to a specific cell while using relative copy, add the [code]$[/code] symbol to the cell name (e.g. [code]$C$1[/code]).

[table][tr][td]9.[/td][td][b]C1[/b][/td][td]Enter the number [code]4[/code] into cell [b]C1[/b] and confirm your input.[/td][/tr][tr][td]10.[/td][td][b]B1[/b][/td][td]Change the formula in cell [b]B1[/b] to [code]=A1*$C$1[/code].[/td][/tr][tr][td]11.[/td][td][icon]https://www.geogebra.org/images/ggb/toolbar/mode_move.png[/icon][br][/td][td]Relative copy the new formula of cell [b]B1[/b] down to cell [b]B10[/b].[br][b]Note:[/b] You just multiplied each value of column [i]A[/i] by 4.[/td][/tr][tr][td]12.[/td][td][b]C1[/b][/td][td]Change the number in cell [b]C1[/b] to [code]10[/code].[br][b]Note:[/b] All values in column [b]B[/b] will automatically adapt to your change.[br][/td][/tr][/table]