In this example, I want to subtract the values in ... However, doing this would result in an untidy spreadsheet with lots of empty calculations. What's more, if I used whole-column references ...

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 ...