En este vídeo te enseño paso a paso cómo bloquear celdas específicas en Excel para proteger tus datos y evitar modificaciones no deseadas. Además, si en algún momento necesitas cambiar algo, también aprenderás a desbloquear celdas fácilmente. 🎯
Categoría
📚
AprendizajeTranscripción
00:00Today I'm going to show you how to lock cells in Excel. Is it easy to do? Yes, Excel makes it easy
00:05for you to do it intuitively, right? That's why you're here, but don't worry, I'll explain it to
00:10you. I'm going to give the cells I want to lock a yellow background color. First step, select the
00:17entire sheet in the upper left corner, right click, format cells. In the protect tab, disable the
00:25locked option that is enabled by default. Accept and return to the sheet. Now select all the cells
00:32you want to protect and lock by pressing the control key. Once you have them selected, right
00:39click again, format cells, and in protect, enable the locked option. Accept. Right now, we can edit
00:47those cells. What you need to do is lock the sheet. In the review tab, select the protect sheet option
00:55and enter your password in this area. Accept. It asks for the password again. Accept. And
01:06now let's see. It tells us that the cell is protected and we can't make any changes. In
01:12order to do this, we need to unprotect the sheet. It's that simple. If you want to make changes
01:17to any other cell, that wouldn't be a problem, but we can't do it in these cells that we've
01:22blocked. To be able to edit them, all you have to do is unprotect the sheet. Then, go back
01:28to reviewing and protecting the sheet, enter the password, and accept. And now you can change
01:33the content of these cells. If you've managed to block these cells so that your colleague
01:38can't mess with them, leave me this icon in the comments. Give it a like if you found
01:43it useful, and if you want to see more videos like this, subscribe to our channel and don't
01:47forget to activate notifications by clicking the bell icon so you don't miss anything. See
01:51you in the next video.