Cómo BLOQUEAR CELDAS en Excel ✅

online

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. 🎯

Transcript

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.

Categoría

Transcripción

Sé la primera persona en añadir un comentario

Recomendada