Channel: Leila Gharani

Category: Education

Tags: excel tips and tricksmicrosoft excel tutorialsprotectionlock unlock cellsexcel for analystsmicrosoft excelxelplusvisleila gharaniadvanced excel tricksexcel 2016excel 2019xelpluslock cells excelexcel lock formulasmicrosoft 365excel 2013excel online courseprotect cells excellock cells from changingexcel 365excel how to beginnerlock sheetunprotect cells

Description: Ever created this perfect shared Excel template only to come back to a total disaster? Collaborating on shared spreadsheets can be painful. But it doesn't have to be that way! In this video I'll show you how you can lock and unlock any cell, or a whole range of cells, to keep your work protected. This way you'd be able to protect your formula cells and allow people to only input in specific ranges or cells. I'll also show you a cool Excel trick which allows you to multi-select cells based on their color and then lock those cells only. 🌍 My Online Excel Courses ► xelplus.com/courses 00:00 How to protect cells in Excel 03:20 How to Multi-Select cells based on Color 05:29 Wrap Up ⯆ Read the blog post and download the file here: xelplus.com/lock-and-unlock-cells-excel 🎬 LINKS to more Excel Basic videos: youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani 👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel