Monday 21 December 2020

How to remove password from Word and Excel files

How to remove password from Word and Excel files
In our daily work routine, we all use Word and Excel files and most of the people spend their time working on these files. But sometimes, we are provided with some files which are password protected or restricted and making any modifications in those files is not possible without the password. But what if you have created any file and password protected it but later you forgot what was the password to allow editing the file? For these scenarios, I am going to tell you the easiest and fastest way to remove passwords and restrictions from any Word or Excel file. Follow the steps below:

  1. At first, make sure that you have turned off your antivirus software or windows defender.
  2. Now download any office password remover from this link : Download Link 1 OR Download Link 2 (Make sure to click SKIP AD to be redirected to the download site)
  3. Now install the software and once the installation is completed, run registration.reg file to register the program.
  4. After the program is registered, open the software and click "Add Files" and select the password protected file which you want to crack.
  5. Now click on "Start" and the unprotected file would be ready at the same source just in a few seconds.
  6. That's it, you can remove restrictions from any Word/Excel file using the software.

The method is demonstrated in the video given below. You may watch it for further clarity.

Keep visiting PC Tricks Guru for more tips and tricks.

Share:

Sunday 29 November 2020

How to remove extra spaces from Microsoft Word document

MS Word
While creating a document, we all make mistakes which we correct either immediately or during the proof-reading. A common mistake most of the people make is adding two spaces between two words and later on, they struggle to correct it.

I would tell you about the easiest and fastest way to remove extra spaces from any Word document. But this method works only with Microsoft Word desktop application, not with Google docs or Word online. Let's see what are the steps to remove the extra spaces from any Word document:

How to remove extra spaces from Microsoft Word

How to remove extra spaces from Microsoft Word:

1. Open your Word document and click on "Replace" which is at the rightmost of the Home tab.
2. Now click on "More" in the Find and Replace dialog box and check mark "Use Wildcards".
3. In the "Find What" section, type ( ){2,} and in the "Replace with" section, type \1
4. Now click on "Replace All".
5. That's it, all the extra spaces from the documents would be removed.

Isn't it simple? Keep visiting PC Tricks Guru for more tips and tricks.

Share:

Tuesday 29 September 2020

Windows 10 Lock Screen Dimming : Fix

Windows 10 Lock Screen Dimming : Fix
Recently, several users of Windows 10 complaint about a strange issue, which is causing the Windows 10 lock screen go dimmer. There was no such setting in Windows 10 which could do it so it was completely strange that why is it happening. So after a lot of research and tests, I finally found the real cause of the issue.

The problem persists only in Lenovo devices and it is happening because of an "Enhancement" which its OEM software is applying to the device. Follow these steps to fix the issue:

  • Open Lenovo Vantage software which is pre-installed in your Lenovo device.
  • Click on "Hardware Settings".
  • Click on "Audio/Visual" and then turn off "Enable Dynamic Brightness Control".
That's it. The issue would be resolved and you would no longer notice dimming of lock screen wallpaper.

Share:

Sunday 26 July 2020

How to increase size limit for PST and OST files

How to increase size limit for PST and OST files
Microsoft Outlook is one of the most popular email clients which is used by millions of users. It is simple to use and has very powerful options to manage your emails which are not available on the webmail of the email service providers. But most of the people don't delete the unwanted emails and the garbage emails keep getting collected in Outlook. This increases the size of the Outlook data file (PST/OST) and once the data file becomes too large in size, Outlook refuses to open it and it starts showing an error that data file is too big, delete some you the old emails to be able to see the contents of the data file.
In this situation, Outlook doesn't allow you to see any of the emails and that's why you get stuck in a situation where you can't delete any of your emails and end up losing data. But to overcome this situation, you can make a simple registry modification to be able to see your emails and even, you can store more emails in the same data file.
Follow the steps given below to do the modification in Windows registry to increase the size limit for an Outlook data file:
1. Open windows registry by running the command regedit.
2. Now, navigate to the following path in Windows registry:
Outlook 2003
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\PST
Outlook 2007 
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\PST
Outlook 2010 
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\PST
Outlook 2013
HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\PST
Outlook 2016/2019/365
HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\PST
3. Now create a 32-bit DWORD by right-clicking in the right pane of the registry window and clicking on New > DWORD (32-bit) Value
4. Rename this DWORD to WarnLargeFileSize and double click on it.
5. Now set it's decimal value to 95000 (which is 95GB). Don’t set its value higher than 4090445042.
6. Now create another 32-bit DWORD and name it as MaxLargeFileSize and set its decimal value to 100000 (which is 100GB). Don’t set its value higher than 4294967295.
How to increase size limit for PST and OST files
7. Now close the registry editor and restart your machine.
8. After restarting the machine, if you launch Outlook, you would be able to see all your emails and now the data file would be able to store up to 100GB of emails in it. More details: Click Here

Keep visiting for more tips and tricks.
Share:

Monday 20 July 2020

How to rollback Microsoft Office to a previous build

How to rollback Microsoft Office to a previous build
Microsoft Office is the most popular software package which is used by millions of user worldwide. Usually, it works fine and security updates and bug fixes are installed for Microsoft Office automatically, but sometimes any auto-installation of any update with any bug creates a lot of problems and there is no simple way to roll back Office to the previous build once an update is installed. But in this article, I would tell you about the easiest way to rollback to the previous build of Microsoft Office without any hassles. Follow the steps below:
  • Open command prompt with admin rights (in elevated mode).
  • Type the following command and press enter.
    cd "\Program Files\Common Files\microsoft shared\ClickToRun"
  • Now type the following command and press enter.
    officec2rclient.exe /update user updatetoversion=16.012827.20470 (Replace the build number which you want to install in your machine. You can check the build numbers from here: https://docs.microsoft.com/en-us/officeupdates/update-history-office-2019)
  • Now Office updated would be downloaded and installed.
  • That's it. Now if you want to stop the auto-update fir Office, click on File > Account > Update Options > Disable Updates
Isn't it so simple? Keep visiting PC Tricks Guru for more tips and tricks.
Share:

Sunday 12 July 2020

How to activate Pre-installed Microsoft Office in Dell/Lenovo/HP and other OEM devices

How to activate Pre-installed Microsoft Office in Dell/Lenovo/HP and other OEM devices
Most of the computers these days are shipped with Microsoft Office pre-installed license. Some of the manufacturers offer Microsoft 365 Home or Personal 1-year subscription and some of them offer Microsoft Office 2019 Home and Student, Home and Business and Pro versions. For most of the users, the activation process is hassle-free. They just have to launch Word in the machine and right after launching, they see the banner which shows that the machine came with pre-installed Office license and after clicking on Activate button, they are asked to log in with their Microsoft account and after signing in, the license gets redeemed with their Microsoft account and Office gets activated on the device.
But there is a big confusion among the users and the OEM technicians about the activation process of Microsoft Office in the OEM devices. These devices are shipped with pre-installed Office 365 applications which are usually MS Store apps or installed with Office Deployment Tool. Now, this is where the confusion begins, the devices which are shipped with Office 2019 licenses, they also have Office 365 applications installed in them and to redeem the license of Office 2019 also, we have to use the Word application which is already installed with the package of Office 365. But out of the confusion, users uninstall Office 365 from the computer and I have seen that not only users, even the OEM support technicians also ask the users to uninstall Office 365 from the machine which is completely wrong. If you uninstall Office 365 from the machine, you might lose your Office 2019 pre-installed license also which is bound in the machine through the Windows registry.
How to activate Pre-installed Microsoft Office in Dell/Lenovo/HP and other OEM devices
So no matter what license you've got with the device, never uninstall the pre-installed Office 365 applications. Redeem your pre-install license with the Word app which got installed with the Office 365 suite and you would be able to redeem your license for Office 2019 successfully. Once the redemption process is completed, you can install the latest updates of Office and the pre-installed Office 365 would be changed into Office 2019 automatically after updates are installed. If the installation doesn't get changed automatically, you can uninstall Office 365 and installed your redeemed product through https://account.microsoft.com/services
Now some times, it happens that most of the users miss to redeem the license after launching Word and then the banner disappears from the machine. When they relaunch Word or any Office application, the pre-installed offer banner doesn't come up. To fix this issue, you would need to run the OEM Office Activation Troubleshooter from the link https://aka.ms/diag_97275 and running this troubleshooter would reset the pre-installed license to its default state. After running the troubleshooter, if you would launch Word, the activation offer banner would again pop-up on the screen which you can use to redeem your pre-installed license.
I hope this article clears your doubts about the activation of the pre-installed Office in OEM devices. Keep visiting for more tips and tricks.
Share:

Tuesday 7 July 2020

Unable to print envelopes in Word in Office for Mac : Fix it

Unable to print envelopes in Word in Office for Mac : Fix it
In recent days, I have noticed that several users of Microsoft Office on Mac are not able to print envelopes using Word. The envelopes don't get printed even after uninstalling and reinstalling Office. When I checked on of the devices, I found that the issue is not actually with Mac OS or the printer, it was with a small setting in Microsoft Word which was causing this issue. Let's see how to fix this issue just in minutes:
1. Launch MS Word and then click on Word > Preferences, as shown in the image.
Word > Preferences
2. Now under "Output and Sharing", click on "Print" option.
print options
3. Now check-mark "Drawing Objects" and click OK.
drawing objects
4. That's it, try printing an envelope and you would be able to print it without any issues.

For more tips and tricks, keep visiting PC Tricks Guru.
Share:

Monday 1 June 2020

How to uninstall Cortana from Windows 10 May 2020 Update (v2004)


How to uninstall Cortana from Windows 10 May 2020 Update (v2004)
Cortana is Microsoft's virtual digital assistant and most of the Windows 10 users don't like it. The popularity of Cortana is very low if we compare it with Siri, Alexa or Google. Microsoft has not given the users to uninstall Cortana and the non-techy users have no option other than to live with Cortana installed on their computer.
With the rollout of Windows 10 May 2020 update, Microsoft has separated Cortana as a completely separate app but again, there is no option to uninstall it. But no need to worry, if you want to uninstall it from your computer, I am sharing the easiest and quickest way to uninstall Cortana from Windows 10 May 2020 update. Follow the steps given below:
1. Click on the start button and search for Windows PowerShell and open it as administrator.
2. Now copy and paste the following command in PowerShell and press enter key.
Get-AppxPackage -allusers Microsoft.549981C3F5F10 | Remove-AppxPackage
3. That's it, you would see that Cortana would be uninstalled from your device in a few seconds.
4. You can now use your Windows without Cortana.

I have created a short video to demonstrate this method, you may check it below:
Keep visiting for more tips and tricks.
Share:

Wednesday 13 May 2020

Word and Excel crash after opening through Outlook attachment : Fix It

Word and Excel crash after opening through Outlook attachment : Fix It
There is a sudden increase in the number of incidents where users are reporting that their Word and Excel crashes and then stops working after they try to open Outlook attachments. After the first crash, if they are trying to launch Word and Excel, the splash screen flashes, and then Word and Excel close immediately. This issue has been reported on Reddit and Microsoft forums as well and users are confused that why is it happening.
SAntivirus Scam
Let me tell you the reason behind it. The issue is being caused by a potentially unwanted program, or in simple words, you can say, by a Virus and the name of the virus is "SAntivirus", how funny, a virus with the word antivirus in it's name. S stands for Segurazo in "SAntivirus" and this virus is so clever that it is not being detected by most of the antiviruses and if you uninstall it through the control panel, it comes back automatically.
So I tested this virus in my own PC and found that it was the actual cause of the Word and Excel crash and to remove this virus, I would tell you the easiest way.
  1. Install MalwareBytes free version from https://www.malwarebytes.com/ and run it.
  2. After running the malwarebytes, perform a full system scan.
  3. It would show several threats hidden in the machine and most of them would be created by SAntivirus malware.
  4. Once the scan is completed, click on Quarantine or Remove and wait for malwarebytes to delete the virus completely.
  5. Once done, it would ask you to restart the computer. Allow malwarebytes to restart the computer and after the restart, open C:\Program Files OR C:\Program Files(x86) and delete the folder "Digital Communications"
  6. That's it, launch Outlook and check if the Word and Excel crash while opening any attachment. The issue would be resolved for sure.
For more tips and tricks, keep visiting PC Tricks Guru.
Share:

Monday 11 May 2020

Fix Microsoft Office installation and other common errors easily by manual removal

Fix Microsoft Office installation and other common errors easily by manual removal
Microsoft Office is the most popular productivity suite used to create documents, spreadsheets, presentations, etc. You can find it installed on the computer of almost every user who uses PCs for Office work. Working on Office applications efficiently is not an easy task and when it comes to troubleshooting the issues with Office applications (launching issues, error codes and error messages, activation issues, etc), it really becomes a nightmare. Most of the people dial the Microsoft support's number and wait in a long call queue and then spend several hours to get their issues resolved with the help of Microsoft technicians. So, to make it easy for you, I am sharing the best troubleshooting method to fix most of the common issues with Microsoft Office. This method is called "Manual Removal" of Office which includes some advance steps which normal uninstallation doesn't include.
Disclaimer: If you are an Outlook user, make sure to keep a backup of your data because this method would reset your Outlook and you would have to reconfigure your emails in Outlook.
So let's start:
  1. Download and run the Office uninstall fixit from http://tinyurl.com/oldofficefixitdirect
  2. When you are done with the fixit, it is time to remove the Office leftover files to completely remove Office from the machine. To do so, press Windows and R keys together and then type %appdata% in the Run box and click OK.
  3. Now the "Roaming" folder would open. From this folder, open "Microsoft" and then delete Word, Excel, PowerPoint, Outlook, Publisher, Office folders and then close this folder.
  4. Now open the run box again and type %programdata% and then again open "Microsoft" folder from it and delete "Office" folder.
  5. Now open run box and type regedit and click OK. It would open the registry editor. Now expand "HKEY_CURRENT_USER" folder and then expand "SOFTWARE", then expand "MICROSOFT" and then delete "Office" registry key from there (Right click on it and delete). If there is any other registry key which starts with the word "Office", delete that as well.
  6. Now expand the other hive, "HKEY_LOCAL_MACHINE" and follow the same path to find the Office registry entries and delete them. If you get any error while deleting the keys, right click on the Office entry and then click on "Permissions". Now click on "Advanced" button and then tick the checkbox for the option "Replace all child object.....from this object" and click OK. Now you would be back to the permission window, tick the allow checkbox for "Full Control" and click OK. Then delete the Office registry keys, you won't get any error.
  7. Now expand the HKEY_USERS registry hive and follow the same path to get to the Office registry entry and delete that as well. To make sure you won't get any activation issues, right click on the "S-1-5-20" registry entry under the HKEY_USERS hive and right click on it and click on "Permissions". Now allow the full control to this entry and click OK.
  8. Restart the machine now.
  9. After the machine is restarted, open "C:\Program Files" and "C:\Program Files (x86)" folders and delete the Microsoft Office folders from there.
  10. Now run the Office setup as administrator by right-clicking on the installer and clicking on "Run as Administrator".
  11. Once the installation is completed, check your office applications, they should be working fine.

For more tips and tricks, keep visiting PC Tricks Guru.
Share:

Monday 23 March 2020

Download Offline Installer for Microsoft Edge Chromium

Download Offline Installer for Microsoft Edge Chromium
Microsoft has recently introduced the faster and better Edge browser which is based on Google's chromium source code. The new Edge browser supports all the extensions downloaded through Google store and it is very smooth and fast, even better than Google's own Chrome browser because the new Edge consumes fewer resources than the Google Chrome browser.
To install Edge, you can download the click to run the installer for the edge but if you don't want to perform an online installation and want to use the complete standalone installer instead, I'll guide you the steps to download the complete installation package of Edge Chromium browser.

1. Open this link: https://www.microsoft.com/en-us/edge/business/download
2. Now select the Channel/Build (select the most recent stable build), select the system architecture and then click on the "Download" option.
Download Offline Installer for Microsoft Edge Chromium
3. Now accept the license agreement and your download would begin.
4. Once the download gets completed, run the setup to install the Edge Chromium browser and enjoy the best web browser by Microsoft.
Share:

Activate Windows 10 For Free Using KMS Client Keys

Activate Windows 10 For Free Using KMS Client Keys
Windows 10 is the latest and final Windows OS by Microsoft. Microsoft offered a free upgrade to Windows 10 for one year after its launch but luckily if you are using the genuine license of Windows 7 or 8.1, you can still upgrade to Windows 10 for free without paying a single penny (Using Windows media creation tool). But if you don't have a genuine Windows 7/8.1 license and you still want to use Windows 10 or if your device came with Linux and if you want to use Windows 10 then you can activate your copy of Windows 10 just by using a few commands. Microsoft offers KMS Client keys to install Windows OS as a volume license to try it and using the same keys, you can keep your copy of Windows activated forever. Following is the list of Windows 10 KMS Client keys which you can use with your machine:
  • Windows 10 Home: TX9XD-98N7V-6WMQ6-BX7FG-H8Q99
  • Windows 10 Home N: 3KHY7-WNT83-DGQKR-F7HPR-844BM
  • Windows 10 Home Single Language: 7HNRX-D7KGG-3K4RQ-4WPJ4-YTDFH
  • Windows 10 Home Country Specific: PVMJN-6DFY6-9CCP6-7BKTT-D3WVR
  • Windows 10 Professional: W269N-WFGWX-YVC9B-4J6C9-T83GX
  • Windows 10 Professional N: MH37W-N47XK-V7XM9-C7227-GCQG9
  • Windows 10 Education: NW6C2-QMPVW-D7KKK-3GKT6-VCFB2
  • Windows 10 Education N: 2WH4N-8QGBV-H22JP-CT43Q-MDWWJ
  • Windows 10 Enterprise: NPPR9-FWDCX-D2C8J-H872K-2YT43
  • Windows 10 Enterprise N: DPH2V-TTNVB-4X9Q3-TJR4H-KHJW4
Note: These keys are not pirated or stolen keys. They are officially shared by Microsoft in the KMS Client Setup documentation which can be accessed from this link.

Now let's see how can you activate your Windows 10 copy using these keys for free. First of all, you need to check which Windows version have you installed. In this article, I'll take an example of Windows 10 Home. So now as we know we have installed Windows 10 Home, we would need to install the KMS Client key for Windows 10 Home in our machine. To do so, follow the steps below:

1. Open command prompt in elevated mode (Search for cmd in Start and right-click over it and click on Run As Administrator)
run cmd as admin
2. Now run the following command as per your Windows edition to install the KMS Client Key:
slmgr /ipk TX9XD-98N7V-6WMQ6-BX7FG-H8Q99

install Windows 10 product key
Note: I have assumed we are using Windows 10 Home so I used the key for Windows 10 Home. You may use the key as per your Windows edition. Running this command will install Windows key in your machine.
3. Now we need to connect to KMS server. If you already have set-up your own KMS Server, you may use your own url for KMS Server. If you don't have it, then use the following command to connect to KMS Server provided by msguides:
slmgr /skms kms8.msguides.com

connect to KMS server
4. After running this command, we need to activate Windows. To do so, run the following command:
slmgr /ato

activate Windows 10 for free
5. That's it. Your Windows 10 copy is now activated and you can use it without any issues.

Keep visiting for more tips and tricks.
Share:

Custom Search Box

Earn Money With Crypto

WazirX

Offers and Deals

Blog Archive

Contact Form

Name

Email *

Message *