Author Archive

« Older Entries
Newer Entries »

How to View Installed Certificates in Windows 10 / 8 / 7

September 12th, 2018 by Admin

How can I get a list of installed certificates on Windows? Is there a way to check if my certificate has the private key attached? In this tutorial we’ll show you easy ways to view all certificates installed on your Windows 10 / 8 / 7 computer, so you can check the certificate status, export, import, delete or request new certificates.

Method 1: View Installed Certificates for Current User

  1. Press the Windows key + R to bring up the Run command, type certmgr.msc and press Enter.

  2. When the Certificate Manager console opens, expand any certificates folder on the left. In the right pane, you’ll see details about your certificates. Right-click on them and you can export or delete it.

    By default, the EFS certificate could be found under the “Personal” -> “Certificates” folder. Double-click on the EFS certificate and you can know if it has the private key attached. Without the private key, you’re unable to decrypt your EFS files.

Method 2: View Installed Certificates for Local Computer

  1. Press the Windows key + R to bring up the Run command, type mmc and press Enter to open Microsoft Management Console.

  2. Click the File menu and then select Add/Remove Snap-in.

  3. Select Certificates from the list of snap-ins, and click Add.

  4. In the next dialog box, select Computer account and click Next.

  5. Select Local computer and click Finish.

  6. Now you’ll back at the “Add or Remove Snap-ins” window, just click OK.

  7. When you open any certificates folder, you will see that the certificates are displayed in the right pane.

Comments Off on How to View Installed Certificates in Windows 10 / 8 / 7 »

Posted in Others, Tips & Tricks, Windows 10, Windows 7, Windows 8

Tags:

Configure File Explorer to Automatically Open Previous Folder at Logon

September 11th, 2018 by Admin

In this tutorial we’ll show you how to configure Windows 10 to remember your currently opened folder windows, and automatically restore them at the next logon. This feature lets you quickly get back to the previous files you’re working after logging off or restart the computer.

Method 1: Configure Windows 10 to Restore Previous Folder Windows via Folder Options

  1. To get started, you need to open the Folder Options in Windows 10.

  2. Go to the View tab. In the list of Advanced settings, scroll down to check the option labelled “Restore previous folder windows at logon” and click OK.

  3. Now when you log off, restart or shutdown, Windows 10 will automatically open the previously opened folder windows at the next logon.

Method 2: Configure Windows 10 to Restore Previous Folder Windows via Registry

The “Restore previous folder windows at logon” option can also be configured with a registry tweak. Follow these steps:

  1. Open the Registry Editor and navigate to the following location:
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced

    Double-click the 32-bit DWORD entry PersistBrowsers on the right pane. If PersistBrowsers is missing, you need to create it manually.

  2. Enter 1 into the Value data box and click OK.

  3. Sign out or restart Windows 10 for your registry settings to take effect.

Comments Off on Configure File Explorer to Automatically Open Previous Folder at Logon »

Posted in Others, Tips & Tricks, Windows 10

Tags:

How to Restore “Close All Tabs” Warning in Microsoft Edge

September 9th, 2018 by Admin

How to get back closing all tabs warning in Microsoft Edge? To avoid accidentally closing multiple tabs at once, Microsoft Edge will show a warning prompt “Do you want to close all tabs” when you try to close the browser.

If you’ve checked the “Always close all tabs” option, Edge will no longer show you the prompt from the next time. This tutorial will walk you through the steps to restore the “close all tabs” warning in Microsoft Edge for your Windows 10 account.

How to Restore “Close All Tabs” Warning in Microsoft Edge

  1. Open the Registry Editor. Copy and paste the following path into the Registry Editor’s address bar to quickly jump to the “Main” key. Then double-click the DWORD AskToCloseAllTabs on the right pane.

    HKEY_CURRENT_USER\Software\Classes\Local Settings\Software\Microsoft\Windows\CurrentVersion\AppContainer\Storage\microsoft.microsoftedge_8wekyb3d8bbwe\MicrosoftEdge\Main

    If the AskToCloseAllTabs value doesn’t exist, right-click on an empty spot and select New -> DWORD (32-bit) Value. Name it AskToCloseAllTabs.

  2. Change its value data to 1 if you want to enable “Do you want to close all tabs” prompt in Microsoft Edge.

  3. Once you’ve completed the steps, re-launch Microsoft Edge. The next time you try to close Edge with multiple tabs, you will get “Do you want to close all tabs?” prompt for confirmation.

Comments Off on How to Restore “Close All Tabs” Warning in Microsoft Edge »

Posted in Others, Tips & Tricks, Windows 10

Tags:

How to Show “Run as different user” on Windows 10 Start Menu

September 6th, 2018 by Admin

How can I run an application (such as SQL Server Management Studio) as a different user? Run as different user is a hidden feature in the depth of Windows. Previously we’ve covered 3 ways to run program as different user. Here we’ll show you a simple way to add “Run as different user” command to the Start Menu in Windows 10.

How to Show “Run as different user” on Windows 10 Start Menu

  1. Open the Registry Editor. Navigate to the following key:
    HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows\Explorer

    If the “Explorer” subkey is missing, right-click on the “Windows” key and select New -> Key. Name it “Explorer” (without the quotes).

  2. Next, right-click on the “Explorer” subkey and select New -> DWORD (32-bit) Value. Name it ShowRunAsDifferentUserInStart.

  3. Double-click the created value, set its value data to 1, then click OK.

  4. Close the Registry Editor. After restarting Windows 10, the next time you right-click any app on the Start Menu, the “Run as a different user” command will appear on the context menu that appears.

Comments Off on How to Show “Run as different user” on Windows 10 Start Menu »

Posted in Others, Tips & Tricks, Windows 10

Tags:

How to Remove “Open PowerShell window here” Context Menu in Windows 10

September 5th, 2018 by Admin

On Windows 10, you can access the “Open PowerShell window here” context menu by holding down the SHIFT key and then right-clicking a folder. This lets you quickly open PowerShell in the current folder without having to change the working directory.

If you’re a fan of using Command Prompt rather than Windows PowerShell, let’s see how to remove “Open PowerShell window here” context menu in Windows 10.

How to Remove “Open PowerShell window here” Context Menu in Windows 10

  1. Use the Windows key + R keyboard shortcut to open the Run command. Type regedit and hit Enter.

  2. Go to the following location in the Registry Editor window that appears:
    HKEY_CLASSES_ROOT\Directory\shell\Powershell

    By default, the “Powershell” key is protected and none of its values can be modified. You have to take ownership of this registry key and assign full permissions to your account.

  3. Right-click the “Powershell” key in the left pane and then select New -> String Value.

  4. Name the new string “ProgrammaticAccessOnly“, and leave its value data empty.

  5. Now you’ve successfully removed “Open PowerShell window here” in the context menu when you press SHIFT and then right-click any folder.

If you want to continue removing “Open PowerShell window here” from the right-click menu for Drives and Directory background, repeat the steps above for the following registry keys:

HKEY_CLASSES_ROOT\Directory\Background\shell\Powershell
HKEY_CLASSES_ROOT\Drive\Background\shell\Powershell

Whenever you need to restore the “Open PowerShell window here” context menu, just delete the ProgrammaticAccessOnly entry from the above registry locations and you’re done.

Comments Off on How to Remove “Open PowerShell window here” Context Menu in Windows 10 »

Posted in Others, Tips & Tricks, Video Converter, Windows 10

Tags:

How to Turn off Password Protected Sharing in Windows 10

September 4th, 2018 by Admin

In Windows 10, password protected sharing is turned on by default, so your shared files could be accessed by only network users who have the login credentials of your computer. If you want to allow others to access the shared files on your PC without any username/password, follow the below step-by-step tutorial to turn off password protected sharing in Windows 10.

Steps to Disable Password Protected Sharing in Windows 10

  1. Open the Control Panel and change the View by setting to Large icons, then click on Network and Sharing Center.

  2. Click on the “Change advanced sharing settings” link on the left side.

  3. Click on the downward arrow to expand the All Networks section.

  4. Under Password protected sharing, check the option “Turn off password protected sharing” and click Save changes.

Can’t Turn off Password Protected Sharing?

After you’ve followed the above steps to disable password protected sharing, go back to the Advanced sharing settings and sometimes you may find the password protected sharing is still turned on. This issue usually happens when your Guest account is protected with a password. To fix this issue, you have to remove the Guest password:

  1. Press the Windows key + R together to open the Run box, type lusrmgr.msc and press Enter to open Local Users and Groups.

  2. Click Users in the left pane, then right-click on Guest and select Set Password.

  3. Leave the New password and Confirm password fields blank, then click OK.

If you’re unable to run the lusrmgr.msc (Local Users and Groups snap-in), you can use other methods described in the following article to remove the Guest account password.

5 Ways to Remove the Administrator Password in Windows 10

After removing the Guest password, you should now be able to turn off password protected sharing successfully.

Comments Off on How to Turn off Password Protected Sharing in Windows 10 »

Posted in Others

Tags:

How to Paste Text into Word 2016 / 2013 Document without Formatting

September 3rd, 2018 by Admin

“When I paste text into a Word document from a website, there appears to be a color background to the text that I cannot remove. How can I strip the formatting away?”

By default, Microsoft Word will preserve the look and formatting of your source text every time you paste. In this tutorial we will show you how to configure Microsoft Word 2016 / 2013 to make any text copied from other programs always being pasted as plain text only.

How to Paste Text into Word 2016 / 2013 Document without Formatting?

  1. Open your Microsoft Word 2016 or 2013. Click the File tab at the top-left corner of the window.

  2. Click the Options button at the bottom of the left bar.

  3. When the Word Options window opens, click Advanced in the left menu. Scroll down to the “Cut, copy, and paste” section in the right side, then click the “Pasting from other programs” drop-down menu and choose “Keep Text Only“.

  4. Click OK to save your changes and close the Word Options window.
  5. Now, when you copy and paste text into Word from other programs like web browsers, your pasted text will be shown as plain-text only, without extra formatting.

Comments Off on How to Paste Text into Word 2016 / 2013 Document without Formatting »

Posted in Others, Tips & Tricks

Tags:

How to Change Text to Uppercase or Lowercase in Excel 2016

September 2nd, 2018 by Admin

How can I change the case of selected cells (to lower or upper or whatever) in Excel? Unlike Microsoft Word, Microsoft Excel doesn’t have a keyboard shortcut for changing the capitalization, or case of selected text. Fortunately you can use a formula to accomplish such a specific task. This tutorial will walk you through the steps of changing text from lowercase to uppercase in Excel 2016.

How to Change Text from Lowercase to Uppercase in Excel 2016?

  1. First of all, open your Excel spreadsheet. Insert a new column next to the one that contains the text you want to convert text case.

  2. Click inside the adjacent cell (C2) of the new column and enter the formula “=UPPER(B2)“, replacing B2 with the original cell containing the text that you want to make uppercase.

    If you want to convert the text to lowercase, type =LOWER(B2) instead.

  3. Select the cell that includes the formula you just entered, then move your cursor to the lower-right corner of the cell until you see a small cross. Drag it down to other cells you wish to convert.

  4. At this point, the values in the new column (C) should be selected. Right-click to copy them into the Clipboard.

  5. Right-click on the first cell in the original column (B). Click on the Values icon under “Paste Options” in the context menu.

  6. You can then delete the new column (C), since it is no longer needed.

  7. Now you’ve successfully converted the text from lowercase to uppercase in Excel 2016.

Comments Off on How to Change Text to Uppercase or Lowercase in Excel 2016 »

Posted in Others, Tips & Tricks

Tags:

Excel 2016: How to Hide Data or Text in a Cell

August 27th, 2018 by Admin

How can I hide the data in an individual cell I want to keep private? Hiding the confidential content of a cell is a useful trick most Excel users probably don’t know. In this tutorial we’ll walk you through the procedure to hide data or text in a cell in Excel 2016.

How to Hide Data or Text in an Excel Cell?

  1. Open your Excel spreadsheet in Excel 2016.
  2. Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu.

  3. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box.

  4. Click OK and now the data in your selected cells is hidden.

This method only hides the cell contents from being seen. The contents are still there and accessible for formulas, charts as such. If you want to display the hidden cell values, right-click the cells and select “Format Cells“. But this time choose “General” as the format of the cells.

Now, the hidden text in your cells will be visible again.

Comments Off on Excel 2016: How to Hide Data or Text in a Cell »

Posted in Others, Tips & Tricks

Tags:

How to Hide / Unhide Entire Row or Column in Excel 2016

August 26th, 2018 by Admin

How can I hide a full column in Excel worksheet without deleting it? If you don’t want others to see a specific row or avoid printing a certain column, you can hide the entire row or column in Excel 2016.

Part 1: Hide a Whole Row or Column in Excel 2016

  1. Open the spreadsheet in Excel 2016.
  2. Select the whole row you want to hide by clicking the row number. If you wish to hide an entire column, click the column letter to select it.
  3. Right-click the selected row or column, and then click the Hide option.

  4. The selected row or column will be hidden from view straight away. But you’ll see double lines at column or row headers, which indicates a column or row is hidden.

Part 2: Unhide a Whole Row or Column in Excel 2016

To unhide a row, just select the row above and the row below the hidden row. Since row 3 is hidden, we want to select rows 2 to 4. Then, right-click on the selection and click Unhide from the popup menu.

To unhide a column, select the columns before and after the hidden columns. Right-click the selected column headers and pick Unhide.

Part 3: Quickly Unhide All Hidden Rows or Columns

If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected.

Then press Ctrl + Shift + 9 keyboard combination to unhide all rows, or press Ctrl + Shift + 0 to show all hidden columns.

Comments Off on How to Hide / Unhide Entire Row or Column in Excel 2016 »

Posted in Others, Tips & Tricks

Tags: