Information and Communication Technology

5.4.9 Copying a Cell Formula

1. Type the formula in a cell and select the cell by clicking
2. Press Ctrl C or select Copy option in Edit menu
3. Move the pointer to the destination cell or block the cells
4. Press Ctrl V or select Paste option in Edit menu

Note: Cell addresses in a formula will be automatically changed corresponding to the destination cell. $ symbol is used to make a cell address as absolute. An absolute address will not change relatively.