Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

A cell address formatted as an absolute reference doesn't change when you copy and paste it to other parts of your worksheet, enabling you to easily apply it to the entire column.

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