How to Copy Formulas in Excel Using Absolute Cell References

When copying formulas in Excel, you’ll find that sometimes it works and sometimes it doesn’t. The key to making sure your formulas work every time is Absolute Cell References. This makes sure that your formula uses the same cell reference each time — wherever it is copied to.

Learn how to create an Absolute Cell Reference in this video with Senior Facilitator Gill — understanding how to use Absolute Cell References will allow you to confidently and efficiently expand on your Excel skills!

The Happy Manifesto

Outline the 10 core principles for a happy workplace. It has since helped thousands of leaders build trust-driven, empowered teams.

Thanks for your enquiry.

We've received your message and will get back to you soon. In the meantime, you may find this of interest:

The Happy Manifesto

The Happy Manifesto features ten core principles for creating happier, more engaging places to work. We offer all of Henry's books as free downloads.