Cómo bloquear celdas en Excel

Descargar el PDF
Descargar el PDF

Bloquear celdas en una hoja de cálculo de Excel puede ayudarte a evitar cambios en la información o fórmulas de esas celdas. Las celdas bloqueadas y protegidas con contraseña pueden desbloquearse en cualquier momento por el usuario que las bloqueó en primer lugar. Sigue los pasos a continuación para aprender a bloquear y proteger las celdas en Microsoft Excel versiones 2010, 2007 y 2003.

Método 1
Método 1 de 2:

Bloquear y proteger celdas en Excel 2007 y 2010

Descargar el PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Las celdas que hayas seleccionado ya estarán bloqueadas y protegidas, y sólo podrás desbloquearlas seleccionándolas de nuevo e introduciendo la contraseña que seleccionaste.
    Anuncio
Método 2
Método 2 de 2:

Bloquear y proteger celdas en Excel 2003

Descargar el PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    en el menú desplegable.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Todas las celdas que hayas seleccionado estarán bloqueadas y protegidas con contraseña, y sólo podrán desbloquearse al seleccionarse todas y al introducir la contraseña que tecleaste anteriormente.
    Anuncio

Consejos

  • Si múltiples usuarios tienen acceso a tu documento de Excel, bloquea todas las celdas que contengan información importante o fórmulas complejas para evitar cambios accidentales en ellas.
  • Si la mayoría de las celdas en tu documento de Excel contienen información importante, considera bloquear y proteger el documento entero, luego desbloquea las pocas celdas que se pueden modificar.
Anuncio

wikiHows relacionados

Cómo
cambiar minúsculas por mayúsculas en Excel
Cómo
recuperar un archivo Excel corrupto
Cómo
cambiar una coma por un punto en Excel
Cómo
calcular el coeficiente de variación en Excel
Cómo
desbloquear una hoja protegida de Excel
Cómo
eliminar espacios entre caracteres y números en Excel
Cómo
tachar texto en Excel
Cómo combinar columnas en Excel sin perder datos
Cómo
abrir un archivo de Excel protegido con contraseña
Cómo
insertar imágenes en Excel que se ajusten automáticamente al tamaño de las celdas
Cómo
combinar celdas en Excel
Cómo
usar el número pi en Excel
Anuncio

Referencias

  1. http://www.dummies.com/how-to/content/how-to-protect-cell-data-in-excel-2010.html

Acerca de este wikiHow

Resumen del artículo X

1. Selecciona las celdas.
2. Haz clic derecho en ellas y selecciona Formato de celdas .
3. Haz clic en Proteger .
4. Marca la casilla "Bloqueada" y haz clic en Aceptar .
5. Haz clic en Revisar .
6. Haz clic en Proteger hoja .
7. Marca "Proteger hoja y contenido de celdas bloqueadas".
8. Ingresa una contraseña y haz clic en Aceptar .

En otros idiomas
Esta página ha recibido 392 273 visitas.

¿Te ayudó este artículo?

Anuncio