Author Archive

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.

That’s it!

Comments Off on How to Create a Power Plan in Windows 11 / 10 / 8 / 7 »

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

Tags: create a power plan create a power plan in windows 10 create a power plan windows 11

How to Prevent Users from Removing Printers in Windows 10 / 8 / 7

August 21st, 2018 by Admin

Is there a way to block users from deleting the printers in a public computer? This tutorial will show you how to use group policy or registry trick to prevent users from removing local and network printers in Windows 10 / 8 / 7.

Method 1: Use GPO to Prevent Users from Removing Printers

Press the Windows key + R to launch the Run dialog box, type in gpedit.msc and press Enter. This will open the Local Group Policy Editor.
Navigate to User Configuration –> Administrative Templates –> Control Panel –> Printers, and then double-click “Prevent deletion of printers” from the right pane.
Select Enabled and click OK.
If a user tries to delete any printers from your computer, a message will appear saying “This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator“.

Method 2: Use Registry Editor to Prevent Users from Removing Printers

If you have the standard or home edition of Windows, you can modify the registry instead to prevent the deletion of existing printers on your computer.

Press the Windows key + R to launch the Run dialog box, type in regedit and press Enter. This will open the Registry Editor.
Go to the following registry location:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer

Double-click the DWORD entry “NoDeletePrinter” from the right panel, change the Value Data field to 1, then click OK.
Now close the Registry Editor and reboot your computer. If you don’t want to prevent users from deleting printers any longer, just change the NoDeletePrinter value to 0 and you’re done!

Comments Off on How to Prevent Users from Removing Printers in Windows 10 / 8 / 7 »

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

Tags: prevent deletion of printers prevent users from deleting printers

How to Crack Passowrd-Protected ZIPX Archive with GPU

August 15th, 2018 by Admin

Forgot the password to your encrypted zipx file? How can I break the zipx password and recover its contents? If you can’t find any passwords or hints as to what it could be, a password cracker program can be of help – Password Recovery Bundle. This program lets you quickly recover ZIPX password with GPU acceleration. Here we’ll walk you through the steps to crack password-protected ZIPX archive with brute-force search.

How to Crack Passowrd-Protected ZIPX Archive with GPU?

If your computer has a dedicated graphic card (such as an NVIDIA or AMD GPU), then Password Recovery Bundle will automatically combine the power of GPU to accelerate the password cracking.

When you open up Password Recovery Bundle, click on the “Recover From File” button and select “ZIP Password” from the drop-down list.
This will open the browser dialog box. Locate your password-protected zipx file and click on Open.
The next window will prompt you to select the password search method: brute-force attack, mask attack or dictionary attack.
If you’ve chosen brute-force attack, enter the minimum and maximum length of the password, as you remember, so that it will search the password only within that range.
Once you click Next, the program will try every possible password. Assuming the character set consists of all lowercase and uppercase letters and digits, and it should be able to find a 4-character password in minutes.
After successfully cracking your forgotten password, you can use it to unpack all encrypted files in the ZIPX archive. That’s it!

Comments Off on How to Crack Passowrd-Protected ZIPX Archive with GPU »

Posted in Others, Tips & Tricks

Tags: crack zipx password forgot zipx archive password recover zipx password

How to Stop OneDrive from Automatically Starting in Windows 10

August 13th, 2018 by Admin

How do I stop OneDrive from opening at startup? By default, OneDrive is set to start automatically when you sign in to Windows 10. However, OneDrive will sync the files in the background and this can waster your limited bandwidth. In this tutorial we’ll show you 2 simple ways to stop OneDrive from automatically starting at startup in Windows 10.

Method 1: Stop OneDrive from Starting at Startup via OneDrive Settings

Right-click on the OneDrive icon in the taskbar notification area, and then click Settings.

If the OneDrive icon is missing from the taskbar, just click the Cortana Search box and type OneDrive. Click the app from the search result and the OneDrive icon will appear in the taskbar.

Under the Settings tab, uncheck the “Start OneDrive automatically when I sign in to Windows” box and click OK.

Now, OneDrive should not start automatically every time your computer restarts.

Method 2: Stop OneDrive from Starting at Startup via Registry Trick

Open the Command Prompt. Run the following command to make a little change with the registry:
reg delete "HKCU\Software\Microsoft\Windows\CurrentVersion\Run" /f /v "OneDrive"

This will stop OneDrive from automatically starts when you sign in to Windows next time.

If you want to enable OneDrive to automatically start at startup, then run this command instead:
reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Run" /f /v "OneDrive" /t REG_SZ /d "\"%LOCALAPPDATA%\Microsoft\OneDrive\OneDrive.exe\" /background"

That’s it!

Comments Off on How to Stop OneDrive from Automatically Starting in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags: start OneDrive automatically when I sign in to Windows stop onedrive from automatically starting