Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

How to quickly generate random password in Excel?

Sometimes, we may want to create random passwords to protect some important thing. But do you have any tricks to quickly generate random password in Excel? Here, I have some methods that can handle it in Excel worksheet.

Generate random password with formula

Generate random password with Insert Random Datagood idea3

Easily Insert Random Data without duplicates in a range of cells

If you want to insert random and no duplicate integer numbers, or dates, or times or strings, even custom lists into a range of cells, the forumula maybe hard to remember. But Kutools for Excel's Inser Random Data can quickly handle these jobs as easily as possible. Click for 60 days free trial!
excel addin tool for generate random integers dates times strings custom lits
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.
 

 


Generate random password with formula

Here I introduce three formulas to generate a different random password for you.

Alphanumeric random password

Select the cell you want to place the random password, type this formula =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99), and press Enter key. Then you will get a string with 4 digits, the first two are alpha characters, and the last two are numbers.
doc random password 1

Tip: In the formula, CHAR(RANDBETWEEN(65,90)) can get one alpha character, RANDBETWEEN(10,99) can get a two-digit number, you can change the formula combination to your need. For instance, 6 digit alphanumeric password, use this formula =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,999)&CHAR(RANDBETWEEN(65,90)).
doc random password 2

Alpha character random password

Select a cell to type this formula =CHAR(RANDBETWEEN(65,90)), then drag fill handle to right or down to fill the cells you need, for instance, fill other three cells if you need 4-digit alpha character. See screenshot:
doc random password 3

Numeric character random password

Select a cell to type this formula =RANDBETWEEN(100000,999999),and press Enter key. A 6-digit number string has been displayed.
doc random password 4

Note: With above formulas to get the random password, the password will be changed while refreshing the sheet each time.


Generate random password with Insert Random Data

If you want to keep the random password no change, you can apply Kutools for Excel’s Insert Random Data utility, which can insert any random data as you need.

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Select a range you want to insert random data, click Kutools > Insert > Insert Random Data.
doc random password 5

2. In the Insert Random Data dialog, under String tab, check the character types you want to use in the password, and check String length and type the length number you want into the textbox. See screenshot:
doc random password 6

3. Click Ok, and the random passwords have been inserted without changing while refresh.
doc random password 7

With Insert Random Data utility, you also can insert random whole numbers, random dates and time, random custom list.

 

Easily Combine multiple sheets/Workbook into one Single sheet or Workbook

To combinne multiples sheets or workbooks into one sheet or workbook may be edious in Excel, but with the Combine function in Kutools for Excel, you can combine merge dozens of sheets/workbooks into one sheet or workbook, also, you can consolidate the sheets into one by several clicks only.  Click for 60 days free trial!
combine sheets
 
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.

Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.