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!

Want more ideas for creating happy, productive workplaces?

Sign up for our Happy Manifesto newsletter and discover fresh ways to ignite joy and productivity at work. Get expert tips, insights, and ideas that challenge the norm—straight to your inbox. Join our movement and start your journey for a trust-based, values-led organisation.

Want more ideas for creating happy, productive workplaces?

Sign up for our Happy Manifesto newsletter and discover fresh ways to ignite joy and productivity at work. Get expert tips, insights, and ideas that challenge the norm—straight to your inbox. Join our movement and start your journey for a trust-based, values-led organisation.