Archive for the ‘Tips & Tricks’ category

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.

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.

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.

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.

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.

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.

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.

How to Remove License / Product Key for Office 2016 / 2013

August 24th, 2018 by Admin

How to update / replace Office license key before the expiration date? Is there a way to change the product key without reinstalling Office suite? Do you have an old PC you want to sell, but also want to transfer your Office license to your new PC? In this tutorial we’ll show you an easy way to remove the existing product key registered with your Microsoft Office 2016 / 2013 application.

Part 1: Check the Office License Status

To get started, open the Command Prompt as administrator. Navigate to the Microsoft Office program folder using the cd command. The subfolder varies depending on your Office version:

  • Office 2016: C:\Program Files\Microsoft Office\Office16 or C:\Program Files (x86)\Microsoft Office\Office16
  • Office 2013: C:\Program Files\Microsoft Office\Office15 or C:\Program Files (x86)\Microsoft Office\Office15

Now you can check the license status by running the script called ospp.vbs, which is located in your Office program folder.
cscript ospp.vbs /dstatus

You’ll see some license details such as the license type (a retail copy, a volume licensed copy, or Office subscriptions copy) and the last 5 characters of the product key.

Part 2: Remove Existing Office Product Key

To remove your Office product key, you need to use the /unpkeyswitch, along with the last 5 characters of the product key.
cscript ospp.vbs /unpkey:{last five characters of product key}

You will be told that your Office product key has been uninstalled. Now, Open any Office application like Word and it’ll ask you to enter new product key.

That’s it!

How to Delete Custom or Built-in Power Plan in Windows

August 23rd, 2018 by Admin

How do I delete a power plan that I no longer need? Windows allows you to use the built-in power plans (Balanced, Power Saver, and High Performance) or create a new power plan from scratch. This tutorial will show you 2 methods to delete custom or built-in power plan in Windows 10 / 8 / 7.

Method 1: Delete Custom Power Plan Using Control Panel

  1. Press the Windows and R keys together to open the Run dialog box. Type powercfg.cpl and press Enter to access one of the Control Panel applets – Power Options.

  2. To delete a custom power plan, you first have to choose another power plan as the active one. Then click on the link “Change plan settings” next to the custom power plan you want to delete.

  3. In the next window, click on Delete this plan link at the bottom.

  4. Click OK to confirm the operation.

  5. After deleting the power plan, it will disappear from the Power Options window.

Method 2: Delete Custom or Built-in Power Plan Using Command Prompt

In addition to deleting custom power plan, this method also allows you to delete built-in power plans in Windows 10 / 8 / 7. Follow these steps:

  1. Open the Command Prompt as administrator. Run the powercfg /list command and it will list all existing power plans in your system along with their GUIDs.

    If the power plan you want to delete is active, then you have to set another plan as active by running this command:
    powercfg -setactive GUID

  2. Now, you can delete the desired power plan using the following command.
    powercfg -delete GUID

  3. When it’s done, the selected power plan is deleted and you cannot use it anymore.

How to Create a Power Plan in Windows 10 / 8 / 7

August 22nd, 2018 by Admin

A power plan lets you customize how long it takes your computer to turn off monitor / hard drive, or go into sleep after your computer is idle. In this tutorial we’ll walk you through the steps to create a power plan in Windows 10 / 8 / 7 to customize how your computer uses power.

How to Create a Power Plan in Windows 10 / 8 / 7?

  1. Press the Windows key + R to bring up the Run dialog, type powercfg.cpl and press Enter to open the Power Options window.

  2. Click the “Create a power plan” link in the left navigational menu.

  3. Select an existing power plan as the base for your new plan, type in a plan name you want and click Next.

  4. Choose how long before your monitor turns off and how long before your computer goes to sleep. You can either set a certain amount of time, or set it to never. Finally click on Create.

  5. When you come back to the Power Options window, you can see that new power plan is automatically set as active.

That’s it!