Archive for the ‘Others’ category

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

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).
Next, right-click on the “Explorer” subkey and select New -> DWORD (32-bit) Value. Name it ShowRunAsDifferentUserInStart.
Double-click the created value, set its value data to 1, then click OK.
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: run as different user windows 10

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

Use the Windows key + R keyboard shortcut to open the Run command. Type regedit and hit Enter.
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.
Right-click the “Powershell” key in the left pane and then select New -> String Value.
Name the new string “ProgrammaticAccessOnly“, and leave its value data empty.
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: open powershell window here remove open powershell here context menu

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

Open the Control Panel and change the View by setting to Large icons, then click on Network and Sharing Center.
Click on the “Change advanced sharing settings” link on the left side.
Click on the downward arrow to expand the All Networks section.
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:

Press the Windows key + R together to open the Run box, type lusrmgr.msc and press Enter to open Local Users and Groups.
Click Users in the left pane, then right-click on Guest and select Set Password.
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: disable password protected sharing turn off password protected sharing

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?

Open your Microsoft Word 2016 or 2013. Click the File tab at the top-left corner of the window.
Click the Options button at the bottom of the left bar.
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“.
Click OK to save your changes and close the Word Options window.
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: word paste text only word paste without 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?

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.
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.
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.
At this point, the values in the new column (C) should be selected. Right-click to copy them into the Clipboard.
Right-click on the first cell in the original column (B). Click on the Values icon under “Paste Options” in the context menu.
You can then delete the new column (C), since it is no longer needed.
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: change case in excel 2016 change 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?

Open your Excel spreadsheet in Excel 2016.
Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu.
On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box.
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 text in excel cells how to unhide text in excel show hidden text in excel

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

Open the spreadsheet in Excel 2016.
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.
Right-click the selected row or column, and then click the Hide option.
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: hide columns in excel hide rows in excel unhide column in excel 2016 unhide rows in excel 2016

How to Remove License / Product Key for Office 2019 / 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 2019 / 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 / 2019: 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!

Comments Off on How to Remove License / Product Key for Office 2019 / 2016 / 2013 »

Posted in Others, Tips & Tricks

Tags: remove office 2013 product key remove office 2016 product key

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 11 / 10 / 8 / 7.

Method 1: Delete Custom Power Plan Using Control Panel

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.
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.
In the next window, click on Delete this plan link at the bottom.
Click OK to confirm the operation.
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:

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
Now, you can delete the desired power plan using the following command.
powercfg -delete GUID
When it’s done, the selected power plan is deleted and you cannot use it anymore.

Comments Off on How to Delete Custom or Built-in Power Plan in Windows »

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

Tags: delete custom power plan windows 7 delete power plan in windows 10 delete power plan windows 11

How to Create a Power Plan in Windows 11 / 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 11 / 10 / 8 / 7 to customize how your computer uses power.

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

Press the Windows key + R to bring up the Run dialog, type powercfg.cpl and press Enter to open the Power Options window.
Click the “Create a power plan” link in the left navigational menu.
Select an existing power plan as the base for your new plan, type in a plan name you want and click Next.
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.
When you come back to the Power Options window, you can see that new power plan is automatically set as active.