Each cell in a worksheet has a unique reference that describes its position – for example A1. In a spreadsheet, there are two types of cell reference – 'relative cell reference' and 'absolute ...

One of the best features in Excel is the ability to plug in a formula and then easily drag it into new cells and have it automatically shift to the corresponding cell values. But sometimes this ...