How to Create Partial Absolute Cell References in Excel

In this two-minute video, Nicky explains how to create Partial Absolute Cell References in Microsoft Excel. Using Partial, or Mixed, Absolute Cell References, you can fix certain elements of a formula — either the row or the column reference, or both. This quick tip will save you lots of time when creating formulas in future!

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.