Cómo proteger con contraseña una hoja de cálculo de Excel

PDF download Descargar el PDF
Coescrito por Personal de wikiHow

PDF download Descargar el PDF

¡Puedes añadir fácilmente una contraseña a una hoja de cálculo de Excel desde la configuración del documento! Si no tienes la última versión de Excel, no te preocupes porque puedes proteger los documentos con contraseña en la mayoría de las versiones de Excel.

Método 1
Método 1 de 2:

Usar Excel 2010/2013/2016

PDF download Descargar el PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5c\/Password-Protect-an-Excel-Spreadsheet-Step-1.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Password-Protect-an-Excel-Spreadsheet-Step-1.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-1.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/de\/Password-Protect-an-Excel-Spreadsheet-Step-2.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/de\/Password-Protect-an-Excel-Spreadsheet-Step-2.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Está en la esquina superior izquierda de la pantalla.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/43\/Password-Protect-an-Excel-Spreadsheet-Step-3.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/43\/Password-Protect-an-Excel-Spreadsheet-Step-3.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    [1]
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/80\/Password-Protect-an-Excel-Spreadsheet-Step-4.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/80\/Password-Protect-an-Excel-Spreadsheet-Step-4.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-4.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\/e\/e9\/Password-Protect-an-Excel-Spreadsheet-Step-5.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e9\/Password-Protect-an-Excel-Spreadsheet-Step-5.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ten cuidado de no olvidar esta contraseña. Si la pierdes, no podrás abrir el archivo.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Password-Protect-an-Excel-Spreadsheet-Step-6.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Password-Protect-an-Excel-Spreadsheet-Step-6.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Password-Protect-an-Excel-Spreadsheet-Step-7.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Password-Protect-an-Excel-Spreadsheet-Step-7.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-7.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d1\/Password-Protect-an-Excel-Spreadsheet-Step-8.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Password-Protect-an-Excel-Spreadsheet-Step-8.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-8.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Password-Protect-an-Excel-Spreadsheet-Step-9.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Password-Protect-an-Excel-Spreadsheet-Step-9.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Si se te pide, primero haz clic en Guardar cambios .
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/aa\/Password-Protect-an-Excel-Spreadsheet-Step-10.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Password-Protect-an-Excel-Spreadsheet-Step-10.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Deberás ver un campo que dice "(TuArchivo).xlsx está protegido".
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/35\/Password-Protect-an-Excel-Spreadsheet-Step-11.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Password-Protect-an-Excel-Spreadsheet-Step-11.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-11.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\/f\/f5\/Password-Protect-an-Excel-Spreadsheet-Step-12.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Password-Protect-an-Excel-Spreadsheet-Step-12.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Si escribiste la contraseña correctamente, ¡ahora debes tener acceso al documento!
    Anuncio
Método 2
Método 2 de 2:

Usar Excel 2007

PDF download Descargar el PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Password-Protect-an-Excel-Spreadsheet-Step-13.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Password-Protect-an-Excel-Spreadsheet-Step-13.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-13.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ab\/Password-Protect-an-Excel-Spreadsheet-Step-14.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ab\/Password-Protect-an-Excel-Spreadsheet-Step-14.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    [2]
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/77\/Password-Protect-an-Excel-Spreadsheet-Step-15.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/77\/Password-Protect-an-Excel-Spreadsheet-Step-15.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Está en la sección "Cambios".
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e2\/Password-Protect-an-Excel-Spreadsheet-Step-16.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/Password-Protect-an-Excel-Spreadsheet-Step-16.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-16.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Si has configurado también ventanas específicas dentro del archivo, marca la casilla correspondiente.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4e\/Password-Protect-an-Excel-Spreadsheet-Step-17.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4e\/Password-Protect-an-Excel-Spreadsheet-Step-17.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-17.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Quizás tengas que hacerlo dos veces.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/75\/Password-Protect-an-Excel-Spreadsheet-Step-18.jpg\/v4-460px-Password-Protect-an-Excel-Spreadsheet-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/Password-Protect-an-Excel-Spreadsheet-Step-18.jpg\/v4-728px-Password-Protect-an-Excel-Spreadsheet-Step-18.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    ¡El archivo de Excel ahora está protegido con contraseña! Cuando lo abras, se te pedirá introducir la contraseña.
    Anuncio

Consejos

  • Proteger la hoja de Excel con contraseña evitará que el usuario promedio manipule tus archivos, pero un usuario decidido puede comprar un software de descifrado de contraseñas para ver las hojas.
Anuncio

Advertencias

  • Anota la contraseña en algún lugar para que no la olvides.
Anuncio

wikiHows relacionados

Cómo
mostrar filas ocultas en Excel
Cómo
agregar enlaces en Excel
Cómo
numerar celdas automáticamente en Excel
Cómo
agregar una columna en una tabla dinámica
Cómo
agregar una nueva hoja en un libro de Excel
Cómo
hacer un gráfico lineal en Microsoft Excel
Cómo
calcular la incertidumbre en Excel en PC o Mac
Cómo
convertir medidas fácilmente en Microsoft Excel
Cómo
crear un gráfico en Excel
Cómo
hacer un gráfico de barras en Excel
Cómo mostrar columnas ocultas en Microsoft Excel: guía rápida
Cómo
agregar datos a una tabla dinámica
Cómo
imprimir parcialmente una hoja de cálculo de excel
Cómo
crear una planilla de calificaciones en Microsoft Excel
Anuncio

Referencias

  1. ↑ https://support.office.com/en-us/article/Password-protect-documents-workbooks-and-presentations-ef163677-3195-40ba-885a-d50fa2bb6b68?ui=en-US&rs=en-US&ad=US&fromAR=1
  2. ↑ http://www.techrepublic.com/blog/microsoft-office/use-a-password-to-secure-access-to-an-excel-workbook/

Acerca de este wikiHow

En otros idiomas
Esta página ha recibido 14 124 visitas.

¿Te ayudó este artículo?

Anuncio