How do you copy an Excel 2016 formula without changing the cell references?- Have you copied a range of cells in Excel and wanted them to reference the same cells as before? Have you happily copied them, pasted them and realized that Excel dynamically updates the cell references? There are two ways around this. Either you lock the cell references with the dollar ($) sign or use a small Notepad hack which I will show you below. (more…)