Furaha sirta ah ee adag ayaa loo baahan yahay si looga ilaaliyo akoonnada elektaroonigga ah weerarrada xoogga ah iyo weerarrada kale ee internetka ee ay isku dayaan tuugtu. Maqaalkan, waxaan ku tusi doonaa sida aad u abuuri karto furaha sirta ah ee xooggan^{(generate a random strong password )} ee Microsoft Excel .

Excel waxay la socotaa qaabab badan oo la dhisay si loo xisaabiyo qiimaha unugyada. Waxa kale oo ay ku siinaysaa qaacidada Nambarka Random Number^{(Random Number Generator)} si aad si dhakhso ah u soo saarto tiro aan toos ahayn oo kala duwan. Laakin, sidee u isticmaali kartaa qaacidadan si aad u abuurto furaha sirta ah^{(generate a strong password)} ? Aan ku ogaano casharkan.

Samee furaha sirta ah ee xooggan^{(Generate Random Strong Password)} adigoo isticmaalaya Excel

Waxaad ku abuuri kartaa erayga sirta ah ee xooggan gudaha Excel adoo raacaya labadan tillaabo ee muhiimka ah:

1. U samee qaab -dhismeedka xaashida^{(Sheet Structure)} furaha sirta ah ee random^{(Random Password Generator)}
2. Ku dar foomamka^{(Add Formulas)} si aad u abuurto kelmad adag oo random random^{(Random Strong Password)}

Aynu hadda faahfaahin ka bixinno tillaabooyinkan!

U samee qaab -dhismeedka xaashida^{(Sheet Structure)} furaha sirta ah ee random^{(Random Password Generator)}

Marka hore, waxaad u baahan tahay inaad abuurto qaab-dhismeedka aasaasiga ah ee xaashida si aad u abuurto furaha sirta ah ee xooggan. Tan waxaa ka mid ah ku dhawaaqida dhererka erayga sirta ah, xarfaha waaweyn, xarfaha yaryar, nambarada,^{(password length, uppercases, lowercases, numbers,)} iyo xarfaha gaarka ah ee^{(special characters)} aad ka rabto erayga sirta ah ee wax soo saarka.

Ka bilow inaad qeexdo magacyada goobaha aasaasiga ah ee unugga A3 oo ay ku jiraan ^(A3)Dhererka Sirta ah, Farsamooyinka Sare, Farsamooyinka Hoose, Nambarada, Calaamadaha Gaarka ah^{(Password Length, Uppercasess, Lowercases, Digits, Special Characters)} . Ka tag unugga A8 faaruq ka dibna geli meelaha ay ku jiraan Press Shift+F9 to Regenerate iyo erayga sirta^(Password) ah.

Shift+F9 hotkey waxaa loo isticmaalaa in lagu cusboonaysiiyo qiimaha unugga ee Microsoft Excel . Sidaa darteed^(Hence) , si aad dib ugu soo ceshato furaha sirta ah ee random, waxaad riixi kartaa hotkey-gan oo waxaad arki kartaa erayga sirta ah ee la beddelay.

U imaatinka ku dhawaaqida qiyamka meelaha sare lagu soo sheegay, ka bilow unugga C3 . Geli^(Enter) dhererka erayga sirta ah marka hore, ka bacdi ' Haa^(Yes) ' dhammaan qaybaha kale oo ay ku jiraan far waaweyn, far yar, lambaro,^{(uppercase, lowercase, digits,)} iyo xarfo gaar ah^{(special characters)} . Markaan rabno inaan abuurno furaha sirta ah ee xooggan, waa inaan ku darnaa isku darka dhammaan qiimayaashan. Markaa^(Hence) , waxaanu galnay Haa^(Yes) meelahan.

Marka xigta, tiirka D, ku caddee dhammaan qiimayaasha xarfaha waaweyn, farmaajo yaryar, lambaro, iyo xarfo gaar ah oo safafkoodu yahay. Waxaad ku dari kartaa jilayaasha gaarka ah ee aad rabto erayga sirta ah ee soo saarista random.

Tusaale ahaan, goobta xarafka sare, ku qor dhammaan xarfaha waaweyn sida ^{(ABCDEFGHIJKLMNOPQRSTUVWXYZ)}ABCDEFGHIJKLMNOPQRSTUVWXYZ^(Uppercase) .

Sidoo kale, lambarrada, geli 9876543210 . Dhammaan qiimayaasha la cayimay ayaa loo isticmaali doonaa si loo soo saaro erayga sirta ah ee xooggan.

TALO^(TIP) :  Abuur furaha sirta ah iyo weedhaha sirta ah adoo isticmaalaya xarfaha ASCII

Ku dar foomamka^{(Add Formulas)} si aad u abuurto kelmad adag oo random random^{(Random Strong Password)}

Ka dib markii la abuuro qaab-dhismeedka aasaasiga ah ee xaashida loogu talagalay curiyaha sirta ah random, yimaado hawsha ugu muhiimsan. Waa inaad isticmaashaa qaacidooyin si aad u abuurto furaha sirta ah ee xooggan.

Marka hore, soo saar xadhig adoo isticmaalaya dhammaan qiyamka far waaweyn, far yar, lambar, iyo xarfo gaar ah adoo isticmaalaya qaacidada soo socota ee unugga D8 :

=IF(C4="Yes",D4,"") &IF(C5="Yes",D5,"") &IF(C6="Yes",D6,"") &IF(C7="Yes",D7,"")

Qaaciddada sare waxay abuuri doontaa xarfo xarfo ah oo ka yimid dhammaan goobaha la qeexay, sida ka muuqata sawirka hoose.

Hadda, si aad u abuurto qiime random ah dhammaan jilayaasha, geli qaacidada hoose ee unugga C10 :

=MID(D8,RANDBETWEEN(1,LEN(D8)),1)

Habkani waxa uu dhalin doonaa kaliya hal qiime sida ka muuqata sawirka hoose.

Marka xigta, si aad u abuurto xadhig dheer oo kelmad xoog leh, waa inaad ku celisaa xadhkaha qaacidada sare ee dhawr jeer adigoo " & " socda. Tusaale ahaan, haddii aad rabto inaad abuurto qiime random ah oo leh 3 xaraf, waa inaad u isticmaashaa saddex jeer si isdaba joog ah "&" inta u dhaxaysa qaacido kasta. Qaaciddadaadu waxay u ekaan doontaa sida tan hoose:

=MID(D8,RANDBETWEEN(1,LEN(D8)),1)&MID(D8,RANDBETWEEN(1,LEN(D8)),1)&MID(D8,RANDBETWEEN(1,LEN(D8)),1)

Markaa, koobi ka bixi caanaha nambarka random nambarka, ku dar "&" ka bacdi xarriiqda kowaad, ka dibna dhowr jeer ku dheji^(Function) bar-hawleedka. Xusuusnow in calaamadda siman (=) ay imaan doonto oo keliya bilowga qaacidada.

Ugu dambeyntii, taabo badhanka Gelida^(Enter) oo waxay ka soo saari doontaa furaha sirta ah ee xooggan unugga C10 .

Hadda waxaad dooran kartaa C10 (password) unugga oo taabo furaha gaaban ee Shift+F9 si aad mar kale dib ugu soo celiso furaha sirta ah ee xooggan. Oo, samee inta jeer ee aad rabto.

Casharradan, waxaan ku wadaagay tillaabooyinka lagu soo saarayo erayga sirta ah ee xooggan gudaha Excel anigoo isticmaalaya maktabadda caanaha ee la dhisay. Waxaad raaci kartaa tillaabooyinkan oo aad abuuri kartaa inta ugu badan ee furaha sirta ah ee xooggan ee aad rabto gudaha Excel , adoon u baahnayn adeeg dibadda ah oo dheeraad ah.

Hadda akhri^{(Now read)} : Sida loo isticmaalo sifada Nooca Xogta Tooska ah ee Microsoft Excel^{(Automatic Data Type feature in Microsoft Excel)} .

How to Generate a Random Strong Password in Excel

Strong passwords are needed to protect your electronic accounts from brutе force аttаcks and other cyberаttacks attempted by hackers. In thіs artiсle, I am going to show you how you can generate a random strong password in Microsoft Excel.

Excel comes with several inbuilt formulas to calculate cell values. It also provides you a Random Number Generator formula to quickly generate a random number from a range. But, how you can use this formula to generate a strong password? Let us find out in this tutorial.

Generate Random Strong Password using Excel

You can create a random strong password in Excel by following these two main steps:

1. Create a Sheet Structure for Random Password Generator
2. Add Formulas to Generate a Random Strong Password

Let’s elaborate on these steps now!

Create a Sheet Structure for Random Password Generator

At first, you need to create a basic structure of your sheet to generate a random strong password. This includes declaring password length, uppercases, lowercases, numbers, and the special characters you want in the output password.

Start with defining the basic fields’ names from the A3 cell that include Password Length, Uppercasess, Lowercases, Digits, Special Characters. Leave the A8 cell empty and then enter fields including Press Shift+F9 to Regenerate and Password.

Shift+F9 hotkey is used to refresh a cell value in Microsoft Excel. Hence, to regenerate a random password, you can press this hotkey and see the changed random password.

Coming to declaring values for the above-mentioned fields, start from the C3 cell. Enter the password length first, then ‘Yes‘ for all other fields including uppercase, lowercase, digits, and special characters. As we want to generate a strong password, we must include a combination of all these values. Hence, we have entered a Yes to these fields.

Next, in the D column, specify all values of uppercases, lowercases, digits, and special characters to respective rows. You can add custom special characters that you want in the random output password.

For example, in the Uppercase field, type all letters in capitals like ABCDEFGHIJKLMNOPQRSTUVWXYZ.

Similarly, for digits, enter 9876543210. All the specified values will be used to generate a random strong password.

TIP: Create stronger passwords and passphrases using ASCII characters.

Add Formulas to Generate a Random Strong Password

After creating the basic structure of the sheet for random password generator, comes the main task. You have to use formulas in order to generate a random strong password.

Firstly, generate a string using all values of uppercase, lowercase, digits, and special characters using the following formula in the D8 cell:

=IF(C4="Yes",D4,"") &IF(C5="Yes",D5,"") &IF(C6="Yes",D6,"") &IF(C7="Yes",D7,"")

The above formula will create a string of all characters from all defined fields, as shown in the below screenshot.

Now, to generate a random value from all characters, enter the below formula in the C10 cell:

=MID(D8,RANDBETWEEN(1,LEN(D8)),1)

This formula will only generate a single value as shown in the below screenshot.

Next, to generate a long string of a strong password, you will have to repeat the above formula string multiple times with “&” in a go. For example, if you want to generate a random value with 3 characters, you will have to use it three times repeatedly with “&” between each formula. Your formula will look something like the below one:

=MID(D8,RANDBETWEEN(1,LEN(D8)),1)&MID(D8,RANDBETWEEN(1,LEN(D8)),1)&MID(D8,RANDBETWEEN(1,LEN(D8)),1)

So, just copy the random number generator formula, add a “&” after the first string, and then paste it multiple times in the Function bar. Do remember that the equal (=) sign will come only at the start of the formula.

Finally, press the Enter button and it will generate a random strong password in the C10 cell.

You can now select C10 (password) cell and press the Shift+F9 shortcut key to regenerate a new random strong password again. And, do it as many times as you want.

In this tutorial, I have shared steps to generate a random strong password in Excel using its inbuilt formula library. You can follow these steps and generate as many strong passwords as you want in Excel, without needing an external add-on service.

Now read: How to use Automatic Data Type feature in Microsoft Excel.

Related posts

• 3 siyood oo erayga sirta ah loo ilaaliyo File Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida looga saaro erayga sirta ah ee Excel File

• Sida loo saaro, loo jebiyo, ama loo jebiyo erayga sirta ah ee Excel XLS ee la iloobay

• Sida Looga Saaro Password-ka Waraaqaha Ilaaliya ee Excel

• Habkani waxa uu u baahan yahay warbaahin meesha laga saari karo - Qaladka dib u dejinta erayga sirta ah

• F-Secure FEY: Maamulaha sirta ah ee bilaashka ah ee Windows 10

• Enpass Manager Password ee Windows 10

• Sida loo abuuro erayga sirta ah ee Google Chrome adoo isticmaalaya Password Generator

• Sida loo damiyo maamulaha sirta ah ee ku dhex jira Chrome, Edge, Firefox

• Scanner Security Password: Falanqee oo hubi xoogga eraygaaga sirta ah

• Deji taariikhda uu dhacayo erayga sirta ah ee Koontada Microsoft iyo Koontada Maxaliga ah

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Ilowdey Windows Administrator Password Offline NT Password

• LessPass waa furaha furaha iyo maareeye bilaasha ah

• Sida loo sameeyo Browser tuso erayga sirta ah ee qoraalka ah halkii dhibco

• Ku soo kabso erayga lumay ama la illoobay Outlook PST Password qalab kabashada bilaashka ah

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo