How to copy/paste a formula down an entire column in Excel 2011? I have a formula that references A1:B5 for instance, the result lives in any arbitrary cell, say D1. How do I copy and paste the same formula, referencing the same values as in D1, through the entire column D? For some reason, I can't find this answer anywhere.

If I select D1 for instance, and click the bottom right, and drag to use auto-fill, it seems to increment the A1:B5 values which ruins the results.
You need to use an absolute reference with $.

So that the cell references never changes when doing a copy and paste or fill change it from A1:B5 to $A$1:$B$5.

If you want you can even make a reference that is half absolute. The reference $D1 means that when you copy and paste the D will stay the same but the row number will change.