Spreadsheet Security 3 - Passwords & Cell Protection


Image by methodshop from Pixabay



Just a few quick tips on protecting your spreadsheet.


Passwords & Cell Protection

  • There are limits to the security provided by passwords.

  • Worksheet password protection can be removed by software you can find on the internet.

  • Workbook password protection is stronger, but can still be removed, especially if you use short or common passwords.

  • To protect formulas remove cell protection from input cells and protect the sheet with a password.


Password Format

  • Longer passwords, with mixed content are best.

  • Use symbols or numbers instead of letters

  • @ for a

  • 1 for I

  • 8 for B

  • 0 for O

  • 5 for S

  • + for T

  • 2 for Z

  • ! for 1

2 views