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!
Join 20,000+ professionals receiving workplace tips, leadership insights, and exclusive offers.
Since 1987, Happy has been igniting possibilities in people and organisations through great learning experiences. Be the first to hear about free resources, events, and training opportunities that make work more joyful and productive.
3rd Floor
Robert Dolan House, 9 Alie Street
London E1 8DE
United Kingdom
Save the date for the next conference Wednesday, 12th November 2025
Build your Excel skills from beginner to expert. Perfect for mastering data analysis and visualisation.
Outline the 10 core principles for a happy workplace. It has since helped thousands of leaders build trust-driven, empowered teams.
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.
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.
