Excel Password Generator


Many websites require passwords 🔑. And, it’s not a good idea to use the same password on each site.
Some suggest changing your passwords every month – that’s fine if you’ve only got a few passwords to change.
Some also suggest password phrases which is fine if that website allows password phrases. And there are pins and facial recognition and fingerprint and iris recognition – but we’ve all seen the movie where they stole the President’s eye.

On to more pleasant thoughts!

Create a new Excel Spreadsheet. In the first cell type =CHAR(RANDBETWEEN(65,90)). This gives you a capital/uppercase letter.
In the second =RANDBETWEEN(1,9). This gives you a number.
In the third =CHAR(RANDBETWEEN(35,37)). This gives you a special character – #, $, %. Some websites allow other special characters in the password.
In the fourth =CHAR(RANDBETWEEN(97,122)). This gives you a lowercase letter.
You can choose any pattern of password you want using any number of characters. If you want an uppercase letter last, place that equation last. Just keep entering these formulas from left to right until you have the number of characters you want in your password.
In the second row type =A1&B1&C1&D1&E1&F1&G1&H1 keep adding &x1 until you get to the last cell in the first row where you entered formulas.

The second row will contain your password. To generate a new one press Ctrl+Alt+Shift+F9. Or simply type anything in another cell and press Tab.

Consider storing your passwords in an encrypted password protected Excel file. (File, Info, Protect Workbook, Encrypt with Password)
Speaking of Excel, I created a random password generator in Excel.