How To Generate Random Strings In Excel

In Microsoft Excel, sometimes you need to generate tons of random strings of characters. It may be different passwords, unique ID's and alphanumeric combinations. May these tutorial help you ease the burden using Excel's RANDBETWEEN function. There could be several ways to do this:

1. Generate Random Number String

To generate a 1-digit random number, simply use a formula like this:


This will randomly display a number between 0 and 9 each time the worksheet is refreshed or when you press F9.

To generate a 4-digit random number string, simply use a formula like this:


This will randomly display 4-digit numbers between 1000 to 9999 each time the worksheet is refreshed or when you press F9.

2. Generate Random Character String

To generate random uppercase character, simply use a formula like this:


This will randomly display character between A to Z.

To generate random lowercase  character, simply use a formula like this:


This will randomly display a character between a to z.

To generate 4 random uppercase character string, simply use a formula like this:

This will randomly display a 4 uppercase character string.

Note: You need to use ampersand (&) in between each formula.  

To generate 4 random lowercase character string, simply use a formula like this:

This will randomly display a 4 lowercase character string.

3. Generate Random Symbol String

To generate random symbol, simply use a formula like this:


This will randomly generate one of the following symbols !”#$%&'()*+,-./

4. Generate Random Alphanumeric String:

To generate 8 random alphanumeric strings with 4 numbers and 4 characters, simply use a formula like this:


Note: You can also use the CHAR() function in Excel to generate a lot of other symbols.

5. Generate a Random Password

Good passwords tend to have at least eight characters and are a mix of uppercase letters, lowercase letters, numbers, and symbols. To do this, simply combine the above formulas into one formula by simply adding an ampersand (&) in between each formula, like this:


This would create something like 0Zt+4Uh" or 6Pv.3Ri%

You can have any combination of letters, numbers or symbols that you want. just play around with these formulas.

Download: Random String Examples

If this helped you then please give a thumbs up, or leave a comment, or link back to this blog.



Aldub Mcdo TV Commercial

Alden Richards and Maine Mendoza, known as “AlDub,” with their first TV commercial as a love team and it’s for McDonalds.

Many are waiting for the first TV commercial of Alden Richards and Maine Mendoza for a fast food restaurant.

Because of their popularity even their ongoing shooting for the commercial has gone viral on Twitter and Facebook.


Why Mabini is Seated the Whole Time

The "why Mabini is seated the whole time" in Heneral Luna is making rounds on social media. The Historical Commission is grateful for the discovery of this rare photo of Mabini by the U.S.-based Kevin Soriano Perez in an auction and did not hesitate to bid for it, even it cost him much. A reproduction of the photo is one of the highlights of the Commission's Mabini Shrine Tanauan. Soriano, who was also from the same barangay where Mabini was born, in Talaga, Tanauan City, Batangas, will "repatriate" this rare Mabini photo and will deposit at the Commission for posterity purposes.

Mabini fell ill sometime in January 1895, at the height of his youth and passion for reform movement in Manila. Until one day, the year after, he was paralyzed, and his physicians--all were fellow patriots--were clueless of his illness. He was already 31 then.

His detractors who envied his power and influence in the revolutionary government circulated a tsismis that his paralysis was actually caused by syphilis. He died in 1903, still clueless what caused his paralysis. 80 years later, in 1981, the Philippine Orthopedic Center and the National Historical Institute (forerunner of the Commission) exhumed his remains at Mabini Shrine Tanauan for post mortem examination. The physicians, driven by patriotism and inspired by Mabini, found out that Mabini's paralysis was caused by polio.

In a letter dated 9 November 1900, Mabini recounted: "Since January 1896, I cannot stand because of weakness in my waist and legs. I do not suffer any other ache and I look as if I were not sick. The physicians however say that I will never recover my health; but I do not despair because I am still able to do something good for my country." Indeed, Mabini was "still able to do something good" for the country, for he guided Aguinaldo in his decisions, served the people by contributing his knowledge on jurisprudence by designing a democratic government befitting for his people, and penned orders and laws needed by the country. He was indeed even more powerful than Aguinaldo, but used his power for the sake of bayan. 

Here is an excerpt from an undated resignation letter (ca. December 1898) of Mabini. He felt Aguinaldo no longer needs him, as the latter had been listening to and being controlled by those whom Mabini called "viruses"--the likes of Pedro Paterno and Felipe Buencamino:

"Although I acknowledge that you have reasons to get tired of me because I only tell you things that may cause you trouble, I hope you will have the patience to read through what I am going to tell you, as I promise never to trouble you again...

"Neither did I expect that you would grant the rich people these guarantees. We worked without any pay; but the rich people will not put up their money without having a voice in the Treasury. It is probable that the members of the Board would ask for salaries. In this case, the rich people will get all the benefit and the soldiers will remain hungry. The rich would press the collection from the tenants. The administrators will pocket part of the money, and only a little will go to the government safe... In the end, the tenants and the employees will blame you, and the rich will have a big laugh.

"Would to heaven that their plans would not prosper!... I am calling your attention to this so that you would carefully choose the persons whom you may appoint as members, and would to heaven that you do not choose persons who would be bribed and who would be subservient!

"Inasmuch as you now count with many helpers, please allow me to resign. When you had no one, I worked by your side despite my ailment; now that you do not need me anymore, it is but fair that I should think of my health... That is why I said at the beginning that this will be the last time I shall trouble you... May God enlighten you, inasmuch as in your hands lies the welfare or the misfortune of the Philippines."

Aguinaldo did not approve Mabini's resignation. From being a mere political adviser pro bono, Aguinaldo made Mabini the president of his cabinet with concurrent position as Foreign Affairs secretary on 2 January 1899. Mabini finally resigned from Aguinaldo's government on 5 May 1899, out of digust to the people surrounding and controlling Aguinaldo, i.e. Paterno, Buencamino. Together with Antonio Luna, Mabini was against the U.S. autonomy. A month later, Luna was assassinated and it is said if Mabini did not resign he would be assassinated as well. 

Mabini was more than just the "brains of the revolution" but the "light that guided the Filipino nation."
Please do visit Museo ni Apolinario Mabini both at the Mabini Shrine in Tanauan City, Batangas and at PUP Sta. Mesa, Manila (Mabini's Nagtahan House). These are free to public. The Historical Commission has also produced a documentary on Mabini this year.

* * * * *

After his resignation, Mabini became a journalist and had written critical articles about the government. In his article “La Verdad en su Lugar” (“The Truth in its Place,”) published in La Independencia (Luna's newspaper) on 15 October 1899, he said "Sincere, honest, and loyal politics are, in truth, very hard to find these days, because, unfortunately, self interest and ambition take control over individuals and blind governments..."

From the post of Ian Alfonso, founder and executive director of Project Saysay.

How to Easily Heal Cavities At Home

If you are like most people chances are you have went to the dentist only to get the dreaded news that you have a cavity.

It is common to believe that the only way that you can fix the cavity is to have the dentist drill it out and fill it with some type of synthetic material. Many people do not realize that there are ways to naturally fix a cavity without going to the dentist.

Causes of Cavities

Cavities are caused by the decay of a tooth. This decay can damage both the interior and exterior of the tooth. One of the main causes of cavities is your diet.

You may not even notice that you have a cavity until you visit your dentist. However, some people develop tooth aches after they drink a hot or cold beverage or when they eat something sweet. At times you may even be able to see holes in your teeth.

Many grains are thought to cause cavities because when grains are eaten and then allowed to sit on your teeth, they naturally turn to acid. This acid can break down the enamel of your teeth, which starts the decaying process. Once the tooth starts to decay it is more likely that a cavity will develop.

Naturally Repairing Tooth Damage

One of the biggest reasons that our teeth begin to decay, which leads to cavities, is because we do not have enough minerals in our diet. Naturally, the best way to heal a cavity is to make sure that you start getting the minerals that your body needs. This includes minerals that your teeth need.

There are several foods that you should focus on adding to your diet. These include:

    Coconut oil
    Organic dairy
    Grass fed meats
    Bone broths
    Cooked vegetables
    Organ meats such as liver

Some of the foods that you should avoid eating when trying to heal a cavity naturally are those that are high in phytic acid. This includes things such as seeds, beans, nuts, and grains. It is also a good idea to limit the number of processed foods that you eat as these commonly upset the balance of your blood sugar levels.

As you can see from the list of foods that you should add to your body, soluble fats are great for your teeth. Try cooking your vegetables in a bone broth to increase the benefits.

There are also supplements that you can take to help heal your cavity. Some of the supplements that you may want to consider include gelatin, magnesium, and fermented cod liver oil.

Simply changing your diet to limit grains and add in good fats can do a lot to help heal any cavity that you may have. Your dental health can affect your entire body, which is why it is important to take care of any tooth issue that you may have right away.


How to Compare Data in Two Columns to Find Duplicates in Excel

When we use a worksheet, sometimes we need to compare two columns and find the duplicate values. 

For example, I have two long columns of student names, and now, I want to compare them and find out the same names. If I compare them cell by cell, it will be tiresome and waste a lot of time.

So... for those of you who have ever needed to find the difference between two columns, this is for you.

Look at the following screenshot, I have column A (A2:A15) and column C (C2:C15) which contain some duplicate names.

The are 2 methods that can be used to compare two columns and display the duplicate values.

METHOD 1: (Use of a Worksheet Formula) Please do with the following steps:

1. In cell B2, input this formula: =IF(ISERROR(MATCH(A2,$C$2:$C$15,0)),"",A2).

Note: In the above formula: A2 is the column which you want to be compared. $C$2:$C$15 is the range that you want to be compared with. You can change the variables for what you are using.

2. Press the ENTER key. Select cell B2, and then drag the fill handle over cell B15. And all of the duplicate names will be displayed in column B. See screenshot:

Download: Sample (Method 1) 2 Column Duplicate Sheet

METHOD 2: (Use of a Visual Basic Macro) Please do with the following steps:

1. Start Excel with your data in it.

2. Press ALT+F11 to start the Visual Basic Editor (see image below).

3. On the Insert menu, click Module.

4. Enter the following code in a module sheet:
Sub Find_Matches()
    Dim CompareRange As Variant, x As Variant, y As Variant
    ' Set CompareRange equal to the range to which you will
    ' compare the selection.
    Set CompareRange = Range("C2:C15")
    ' NOTE: If the compare range is located on another workbook
    ' or worksheet, use the following syntax.
    ' Set CompareRange = Workbooks("Simpleng Tips"). _
    '   Worksheets("Sheet2").Range("C2:C15")
    ' Loop through each cell in the selection and compare it to
    ' each cell in CompareRange.
    For Each x In Selection
        For Each y In CompareRange
            If x = y Then x.Offset(0, 1) = x
        Next y
    Next x
End Sub
5. Press ALT+F11 to return to Excel.

6. Using our data above, select the range A2:A15.

7. In Excel 2003 and in earlier versions of Excel, point to Macro on the Tools menu, and then click Macros.

In Excel 2007, click the Developer tab, and then click Macro in the Code group.


8. Click Find_Matches, and then click Run

The duplicate numbers are displayed in Column B. The matching data will be put next to the first column.

Download: Sample (Method 2) 2 Column Duplicate Sheet

If this helped you then please give a thumbs up, or leave a comment, or link back to this blog.


Export All or Part of the Registry to a Text File

  1. Open Registry Editor.
  2. On the File menu, click Export.
  3. In File name, enter a name for the registry file.
  4. Under Export range, do one of the following:
    • To back up the entire registry, click All.
    • To back up only a particular branch of the registry tree, click Selected branch and enter the name of the branch you want to export.
  5. Click Save.
  • Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on your computer.
  • To open Registry Editor, click Start, click Run, type regedit, and then click OK.
  • You must have appropriate permissions to make changes to a registry key. To maintain security when making changes to a registry key for which you need administrative credentials, log in as a member of the Users group and run Regedit as an administrator by right-clicking the Regedit icon, clicking Run as, and clicking an account in the local Administrators group. The Regedit icon does not appear by default from the Start menu. To access the icon, open the Windows or WINNT folder on your computer.
  • You can use a text editor like Notepad to work with the registry files you create by exporting.
  • You can save registry files in the Windows format, in the format used in Windows 95, Windows 98, and Windows NT 4.0, as binary hive files, or as text files. Registry files are saved with .reg extensions, and text files are saved with .txt extensions.
  • In Windows Explorer, double-clicking a file with the .reg extension imports the file into the computer's registry.

Disabling APIPA – Automatic Private IP Addressing

Automatic Private IP Addressing (APIPA), is a feature of Windows (except Windows NT) operating systems. 

With APIPA, DHCP clients can automatically self-configure their IP configuration with an IP address and subnet mask when a DHCP server isn’t available. 

When a DHCP client boots up, it first looks for a DHCP server in order to obtain an IP configuration. If the client is unable to successfully negotiate a DHCP lease, it uses APIPA to automatically configure itself with an IP address from a range that has been reserved especially for Microsoft. 

The IP address range is through The client also configures itself with a default class B subnet mask of A client uses the self-configured IP address until a DHCP server becomes available. 

The APIPA service also checks every five minutes for the presence of a DHCP server. If it detects a DHCP server on the network, APIPA stops, and the DHCP server replaces the APIPA networking addresses with dynamically assigned addresses.

Step-by-step procedure to disable APIPA:

1. Access the Registry Editor

- Click START > RUN. Alternatively, you could press the Windows Key + R keys on the keyboard to open the Run prompt. Note that you will need to have administrative rights to open the Registry Editor. Type regedit.exe (or simply regedit) to bring up the Registry Editor.

- You should see the Registry Editor application similar to image below.

2. Backup the Registry

- Click Computer to highlight it, click File > Export. This will bring up the Export Registry File window.        In the File name field type in the name of the registry backup, for example regbackup and click Save. By default, this will save the entire registry. (now you can work confidently knowing that you have a full backup just in case. As an added protective measure you could create a system restore point)

3. Navigate to the appropriate network adapter within the registry. 

- This can be done by navigating the following path:


- Then, locate the proper network adapter; each is labeled as a different hexadecimal subkey. 

4. Disable APIPA

- Right-click anywhere in the right window pane and select New > DWORD value.

- Create the following entry: IPAutoconfigurationEnabled: REG_DWORD.

- Assign a value of 0 to disable Automatic Private IP Addressing (APIPA) support for the selected network adapter.

5. Close the registry and restart the computer.

6. Test the new configuration and verify network connectivity.

- Type ipconfig /all in the command-line to see if the correct IP address is being obtained from the DHCP server. You can also test whether your registry entry was applied correctly by viewing the Autoconfiguration Enabled field within the results of the ipconfig. It should say No.

- Connect to LAN servers, domain controllers, and to the Internet to verify network connectivity. Of course, the IP address you obtain will most likely be different than the one in the scenario; also, it might be a different IP than the computer was using previously.

You can just DOWNLOAD and simply add this to registry: disableAPIPA.reg

Autoconfiguration Ipv4 Address IP Problem

When I connect my laptop to LAN it wasn't getting the IP from my DHCP server. Instead it gives me some weird IP like 169.254.x.x . while my wifi was working fine, I searched Alot to get to know until i found a great piece of code on a blog. so I am going to share with you guys. (see image below with the problem)

 Please follow the procedure:

1. If you are using any FIREWALL disable it (like me, I use comodo so I disable it temporarily)

2. Click on START and click on RUN (or simple press Windows Key + R ) type CMD
3. Now type the following code below:

         netsh interface ipv4 show inter 

4. My connected LAN here is Local Area Connection and its Idx = 14 (we will use this idx number in next code)

5. Now type the following code below and replace your Idx number, as mine is 14

         netsh interface ipv4 set interface 14 dadtransmits=0 store=persistent 

6. If it says OK. Congratulations you have done the difficult part.

7. Next procedure, click on START and RUN again and type services.msc 

8. Services dialog box will appear, search for DHCP Client right click on it and click on Properties then click on Startup Type then select Disable and now click on Stop button and click on OK.

9. UNPLUG your LAN cable and RESTART your system.

10. After restart DON'T PLUGIN YOUR CABLE, go to services.msc and find again DHCP Client right click on it and click on Properties then click on Startup Type now select Automatic lastly click on Start button below and then OK.

11. Now Plugin your LAN cable and enjoy.

By the way you can Enable your Firewall again :)

How to Make a Simple Fork Lock

Poor fork had to sacrifice itself, but it’s for the greater good. Next time you're traveling, you can bet you'll be installing this do-it-yourself security system.

Simple Steps to Make a Fork Lock:

1. Measure - Place fork in latch hole. Use a Sharpie to measure how far it goes in.

2. Bend The Fork - Here you will bend the tongs of the fork at the point where you measured.

3. Cut The Fork - Use a Metal Cutting Saw.

4. Setup the Lock - Close the door. Now get ready to lock it up!

5. Final Step - Insert the handle into the slot of the fork. Genius! 


Keyboard Shortcuts - Windows

Keyboard shortcuts are really helpful to do work speedily with the help of these short keys. They just don’t get the work done quickly, but also improves the efficiency

Below are compiled list of keyboard shortcuts for Windows.

Note: Some of the shortcuts given below may not work for versions below Windows 8. 

General Shortcuts
    F1 - Display Help
    F2 - Rename the selected item
    F3 - Search for a file or folder
    F4 - Display the address bar list in File Explorer
    F5 - Refresh the active window
    F6 - Cycle through screen elements in a window or on the desktop
    F10 - Activate the Menu bar in the active app
    ALT + F4 - Close the active item, or exit the active app
    ALT + ESC - Cycle through items in the order in which they were opened
    ALT + underlined letter in menus and dialog box options - Perform the command for that letter
    ALT + ENTER - Display properties for the selected item
    ALT + SPACEBAR - Open the shortcut menu for the active window
    ALT + LEFT ARROW - Back
    ALT + RIGHT ARROW - Forward
    ALT + PAGE UP - Move up one screen
    ALT + PAGE DOWN - Move down one screen
    ALT + TAB - Switch between open apps (except desktop apps)
    CTRL + F4 - Close the active document (in apps that allow you to have multiple documents open simultaneously)
    CTRL + A - Select all items in a document or window
    CTRL + C or CTRL + INSERT - Copy the selected item
    CTRL + D / DELETE - DELETE the selected item and move it to the Recycle Bin
    CTRL + R or F5 - Refresh the active window
    CTRL + V or SHIFT + INSERT - Paste the selected item
    CTRL + X - Cut the selected item
    CTRL + Y - Redo an action
    CTRL + Z - Undo an action
    CTRL + + or CTRL + – - Zoom in or out of a large NUMBER of items, like apps pinned to the Start screen
    CTRL + mouse scroll wheel - Change the size of desktop icons or zoom in or out of a large NUMBER of items, like apps pinned to the Start screen
    CTRL + RIGHT ARROW - Move the cursor to the beginning of the next word
    CTRL + LEFT ARROW - Move the cursor to the beginning of the previous word
    CTRL + DOWN ARROW - Move the cursor to the beginning of the next paragraph
    CTRL + UP ARROW - Move the cursor to the beginning of the previous paragraph
    CTRL + ALT + TAB - Use the arrow keys to switch between all open apps
    CTRL + ARROW + SPACEBAR - Select multiple individual items in a window or on the desktop
    CTRL + SHIFT + ARROW - Select a block of text
    CTRL + ESC - Open the Start screen
    CTRL + SHIFT + ESC - Open Task Manager
    CTRL + SHIFT - Switch the keyboard layout when multiple keyboard layouts are available
    CTRL + SPACEBAR - Turn the Chinese input method editor (IME) on or off
    SHIFT + F10 - Display the shortcut menu for the selected item
    SHIFT + ARROW - Select more than one item in a window or on the desktop, or select text within a document
    SHIFT + DELETE - Delete the selected item without moving it to the Recycle Bin first
    RIGHT ARROW - Open the next menu to the right, or open a submenu
    LEFT ARROW - Open the next menu to the left, or close a submenu
    ESC - Stop or leave the current task

Windows Key Shortcuts
    Win - Display or hide the Start screen 
    Win + F1 - Open Windows Help and support
    Win + B - Set focus in the notification area
    Win + C - Open Charms
    Win + D - Display and hide the desktop
    Win + E - Open File Explorer
    Win + F - Open the Search charm and search for files
    Win + H - Open the Share charm
    Win + I - Open the Settings charm
    Win + K - Open the Devices charm
    Win + L - Lock your PC or switch people
    Win + M - Minimize all windows
    Win + O - Lock device orientation
    Win + P - Choose a presentation display mode
    Win + Q - Open the Search charm to search everywhere or within the open app (if the app supports app search)
    Win + R - Open the Run dialog box
    Win + S - Open the Search charm to search Windows and the web
    Win + T - Cycle through apps on the taskbar
    Win + U - Open Ease of Access Center
    Win + V - Cycle through notifications
    Win + SHIFT + V - Cycle through notifications in reverse order
    Win + W - Open the Search charm and search for settings
    Win + X - Open the Quick Link menu
    Win + Z - Show the commands available in the app
    Win + , - Temporarily peek at the desktop
    Win + PAUSE - Display the System Properties dialog box
    Win + CTRL + F - Search for PCs (if you’re on a network)
    Win + SHIFT + M - Restore minimized windows on the desktop
    Win + (NUMBER 1-9) - Open the desktop and start the app pinned to the taskbar in the position indicated by the number. If the app is already running, it switches to that app.
    Win + SHIFT + (NUMBER 1-9) - Open the desktop and start a new instance of the app pinned to the taskbar in the position indicated by the number
    Win + CTRL + (NUMBER 1-9) - Open the desktop and switch to the last active window of the app pinned to the taskbar in the position indicated by the number
    Win + ALT + (NUMBER 1-9) - Open the desktop and open the Jump List for the app pinned to the taskbar in the position indicated by the number
    Win + CTRL + SHIFT + (NUMBER 1-9) - Open the desktop and open a new instance of the app located at the given position on the taskbar as an administrator
    Win + TAB - Cycle through recently used apps (except desktop apps)
    Win + CTRL + TAB - Cycle through recently used apps (except desktop apps)
    Win + SHIFT + TAB - Cycle through recently used apps (except desktop apps) in reverse order
    Win + CTRL + B - Switch to the app that displayed a message in the notification area
    Win + UP ARROW - Maximize the window
    Win + DOWN ARROW - Remove current app from screen or minimize the desktop window
    Win + LEFT ARROW - Maximize the app or desktop window to the LEFT side of the screen
    Win + RIGHT ARROW - Maximize the app or desktop window to the RIGHT side of the screen
    Win + HOME - Minimize all but the active desktop window (restores all windows on second stroke)
    Win + SHIFT + UP ARROW - Stretch the desktop window to the top and bottom of the screen
    Win + SHIFT + DOWN ARROW - Restore/minimize active desktop windows vertically, maintaining width
    Win + SHIFT + LEFT ARROW or RIGHT ARROW - Move an app or window in the desktop from one monitor to another
    Win + SPACEBAR - Switch input language and keyboard layout
    Win + CTRL + SPACEBAR - Change to a previously selected input
    Win + ENTER - Open Narrator
    Win + SHIFT + . - Cycle through open apps
    Win + . - Cycle through open apps
    Win + / - Initiate IME reconversion
    Win + ALT + ENTER - Open WindowsMedia Center
    Win + +/- - Zoom in or out using Magnifier
    Win + ESC - Exit Magnifier 

Dialog Box Shortcuts

    F1 - Display Help
    F4 - Display the items in the active list
    CTRL + TAB - Move forward through tabs
    CTRL + SHIFT + TAB - Move back through tabs
    CTRL + (NUMBER 1-9) - Move to nth tab
    TAB - Move forward through options
    SHIFT + TAB - Move back through options
    ALT + underlined letter in menus and dialog box options - Perform the command (or select the option) that goes with that letter
    SPACEBAR - Select or clear the check box if the active option is a check box
    BACKSPACE - Open a folder one level up if a folder is selected in the Save As or Open dialog box
    ARROW Keys - Select a button if the active option is a group of option buttons

File Explorer (Windows Explorer) Shortcuts

    ALT + D - Select the address bar
    CTRL + E - Select the search box
    CTRL + F - Select the search box
    CTRL + N - Open a new window
    CTRL + W - Close the current window
    CTRL + mouse scroll wheel - Change the size and appearance of file and folder icons
    CTRL + SHIFT + E - Display all folders above the selected folder
    CTRL + SHIFT + N - Create a new folder
    NUM LOCK + * - Display all subfolders under the selected folder
    NUM LOCK + + - Display the contents of the selected folder
    NUM LOCK + – - Collapse the selected folder
    ALT + P - Display the preview pane
    ALT + ENTER - Open the Properties dialog box for the selected item
    ALT + RIGHT ARROW - View the next folder
    ALT + UP ARROW - View the folder that the folder was in
    ALT + LEFT ARROW - View the previous folder
    BACKSPACE - View the previous folder
    RIGHT ARROW - Display the current selection (if it’s collapsed), or select the first subfolder
    LEFT ARROW - Collapse the current selection (if it’s expanded), or select the folder that the folder was in
    END - Display the bottom of the active window
    HOME - Display the top of the active window
    F11 - Maximize or minimize the active window

Taskbar Shortcuts

    SHIFT + Click a Taskbar Button - Open an app or quickly open another instance of an app
    CTRL + SHIFT + Click a Taskbar Button - Open an app as an administrator
    SHIFT + Right-Click a Taskbar Button - Show the window menu for the app
    SHIFT + Right-Click a grouped Taskbar Button - Show the window menu for the group
    CTRL + Click a grouped Taskbar Button - Cycle through the windows of the group


Prevent a User from Changing Any Data in Excel 2007

We will show you how to lock a spreadsheet so that nothing can be changed in it.

This is a great feature to use when you want to present data without allowing for it to be potentially corrupted or altered.

The result of this action is that it will prevent a user from doing almost anything with your data unless they know how to unlock it and know your password, if one is used.

Steps to Protect a Worksheet in Excel

1. Go to the Review tab and click the Protect Sheet button:

2. Choose if you want to password protect the data or not.  This is optional.

3. Choose what you want a user to be able to do within the worksheet.  There are many options, but "Select locked cells" and "Select unlocked cells" are selected by default and this is good enough usually.

4. Hit OK and you are DONE.
Now, the user cannot change any data within this worksheet.  If they try to do something that is not allowed, this is the message they see:

This message does tell the user where to go to Unprotect the worksheet though, so, if you did not enter a password in Step 2 above, then it will be really easy for any user to change data on the sheet.

Steps to Unprotect a Worksheet

1. Navigate to the desired worksheet.
2. Go to the Review tab and click the Unprotect Sheet button.  This will only appear if the sheet is protected.

3. If there is a password for the sheet, you will need to enter it now:

4. Now the sheet is unprotected and can be worked on as usual.

Note: This is a very useful feature if you need to send your Excel files out to other people.  Just remember to not forget your password, if you use one. 

We included a sample Excel file for this tutorial with Protected Sheet.  
You can download it and see what it's like to use this feature.

The password is: 123456
(do not ever use this as a password for your files - this was done here to make it easy for you to use)


Password Protect Excel Files - Excel 2007

How to keep an Excel workbook safe by encrypting it with a password.

This will make it so that a user cannot open the Excel file unless they have the correct password.

Steps to Encrypt a Workbook with a Password in Excel 2007

1. Click the Office Button then select New to create a Blank Workbook:

2. Go to the Prepare tab:

3. Click the Encrypt Document button:

 4. Enter the password that you want to use to open the Excel file and hit OK:

5. You will need to re-enter the password and hit OK again:

5. That's it, you're DONE.


We included a sample Excel file for this tutorial that has been password protected.  
You can download it and see what it's like to use this feature.

The password is: 123456
(do not ever use this as a password for your files - this was done here to make it easy for you to use)


Alternate Row Shading Using Conditional Formatting in Excel

One way to make your data legible is to apply cell shading to every other row in a range. Excel's Conditional Formatting feature (available in Excel or later) makes this a simple task.

1. Select the range that you want to shade, then click Home>> Conditional Formatting>> New Rule... See screenshot:

2. Then a New Formatting Rule dialog box will pop out. Select Use a formula to determine which cells to format item. Then Input the formula “=MOD(ROW(),2)” in Format values where this formula is true.

3. Then click the Format… button, another Format Cells dialog box will pop out. Go to Fill tab and choose one colour for shading the background. See screenshot:

3. Click OK to return the New Formatting Rule dialog box, and also you will see the colour in the Preview box.

4. Then click OK. You will get the result you want. See screenshot:

The best part is that the row shading is dynamic. You'll find that the row shading persists even if you insert or delete rows within the original range.
1. Insert or delete a row in the shading range and you will see that the shading persists.
2. If you want to shade alternate columns,using this formula “=MOD(COLUMN(),2)”.


Add “Open with Notepad” to the Context Menu for All Files

The default method of opening unknown files forces you to go through a list of known applications and is generally a pain to deal with. That’s why I like to have a context menu option for “Open with Notepad” so that I can quickly open up files without having to go through a lot of trouble.
This registry hack is nothing new, it’s been around forever… think of this as a refresher course. Also note that you can use this same technique to substitute any other application that you’d like by adjusting the path in the registry to point to the different editor.

Manual Registry Hack
Open regedit.exe through the start menu search or run box, and then browse down to the following key:

Right-click on “shell” and choose to create a new key, calling it “Open with Notepad”. Create a new key below that one called “command”. Double-click on the (Default) value in the right-hand pane and enter in the following:
notepad.exe %1
The change should take effect immediately… just right-click on any file and you’ll see the next menu entry.

Download Registry Hack

Just download, extract and double-click on the OpenWithNotepad.reg file to enter the information into the registry. There’s also an uninstall script included.

Download: OpenWithNotepad registry hack

Disable All Notification Balloons in Windows 7

If you find the popup notification balloons in the Windows system tray to be too annoying, you might be interested to know that you can completely disable them. This would be an extreme option, of course… typically you can just turn them off in any offending applications, but if you want to disable them across the board, this is the solution.
Note: This should work in any version of Windows.
Note: I’m not necessarily recommending that everybody do this… you should only bother with it if you need to solve this particular problem.
Manual Registry Hack
Open up regedit.exe through the start menu search or run box, and then browse down to the following key:

Right-click on the right-hand pane, and create a new 32-bit DWORD with the following values:
  • Name: EnableBalloonTips
  • Value: 0
You’ll have to logoff and back on in order to see the change… or to be more correct, you won’t see any popup balloons anymore.

Downloadable Registry Hack

Simply download, extract, and double-click on the DisableNotificationBalloons.reg file to enter the information into the registry. There’s also an included EnableNotificationBalloons file that will reverse the change.

Download: DisableNotificationBalloons Registry Hack
Copyright © 2015 - 2017. Simpleng Tips - All Rights Reserved