In this article we’ll break down how you can find and remove the duplicates in a couple of different ways. How to highlight duplicates in Google Sheets Google Sheets does offer a way to identify and remove duplicate data contained in your spreadsheets, but when working through large data it is a good idea to start by highlighting the data you want to review to easily identify where duplicates are....

Once you do eventually get your device up and running again, it’s important to know what actually caused the issue in the first place. This helps you to prevent something similar from happening in the future. There are two tools we recommend for finding out why your PC crashed or froze, both of which are free and easy to use. Check the reliability history All recent versions of Windows have a reliability monitor built directly into the OS, which helps identify any recent issues on your device....

If you’re looking to speed up your Windows 10 then look no further than our quick guide, and if you’re looking to keep yourself safe online then make sure you get yourself a VPN too. How to fix a black screen in Windows 10 during installation If you run across a black screen during the installation process of Windows 10, then depending on your hardware, this could still mean that the installation is progressing in the background....

That isn’t to say it’s everyone’s experience, though. The OS has had its fair share of teething troubles and problems with dodgy updates, causing system crashes and more. Unfortunately, one issue which persists on some PCs and laptops is a locked-up Start screen. When you first boot up your computer, the Start menu will open, but then everything freezes and you can’t click on apps or even the Start button....

Resolution If you’re converting video from an 4K source, such as a GoPro, you’ll start with a big, high-quality file. Let’s say you want to watch that video on your smartphone. There’s little point in retaining the video’s full resolution of 3096×2160, even if your phone can play it. In your video converter, enter the resolution of your phone’s screen. This will reduce the size of the resulting video file, and it should also make it look better on your phone, as well as saving the phone from having to downscale the video to fit....

“I’ve some fantastic, earth-shattering-saving news: we’re announcing the global launch of Kaspersky Free, which, as you may have guessed by the title, is completely free-of-charge! Oh my giveaway!” said the official blog. Make sure you read our guide on the best antivirus for 2017. Kaspersky Free release date and rollout The new free edition of Kaspersky antivirus has already been launch, on the firm’s 20th birthday which falls on 25 July....

So if you have some shameful songs in your playlists (don’t we all?) and would rather not let everybody know you listen to the Macarena every morning, here’s how to hide what you’re listening to on Spotify. Private Session on Spotify Spotify gives you several options to hide what you’re listening to. The first thing you can do to make sure no one can mock your terrible taste (be it a random song you’re browsing or an embarrassing playlist) is to make your session private....

This is why you will see budget monitors being shipped out with a refresh rate of 75Hz.There are gaming-specific monitors which cost more and come with an impressive 120Hz, 144Hz, 160Hz, 165Hz and even at the ridiculously high 200Hz refresh rate. A full list of capable monitors can be found here. In this guide we’ll explain how you can overclock your monitor, specifically for Nvidia and AMD graphics cards. Read our: display reviews....

Should you wish to disable it completely, then you’ll need to follow the steps below. It’s unwise to have no security software though, as we discuss in Do you need Antivirus on a new Windows PC or laptop? The process involved making changes to the Registry in Windows, so it’s essential that you make a backup of your system. Disabling Windows Defender is straightforward and safe, as you’ll be interacting with the structural elements of your PC’s operating system but it’s always wise to ensure that you have an up-to-date backup to hand....

How to play Oculus Rift games on HTC Vive: Why can’t I play Oculus Rift games on the HTC Vive? In the race to become the ultimate virtual reality headset, Oculus and HTC have kicked off a hardware (and software) showdown rivalled only by the PS4 and Xbox One, with each platform producing unique content and essentially fragmenting the market. While this is a fairly standard process for competing companies, there’s something we don’t quite understand: Oculus Rift users can easily access the HTC Vive software hub, SteamVR, and all its content but HTC Vive owners can’t access the Rift platform, Oculus Home....

If someone is determined enough the chances are they can guess your password using brute force. Here’s how to lock down Windows following several failed login attempts. Complex passwords can be a pain to remember and prone to mistyping, but shorter passwords can be much easier to guess by brute force – trying huge numbers of passwords until the correct one is guessed. You can reduce the effectiveness of a brute force attack by limiting the number of ‘guesses’ available before the system locks the account, requiring an administrator to reset it before the user can sign in again....

Deleting an email address from Apple Mail is incredibly easy, all you need to do is go in to the settings, locate the account and click remove. That’s it, all existing data from that email account will be removed from Apple Mail. Follow this step-by-step guide and you will be able to delete accounts from Apple Mail willy-nilly. How to remove Apple Mail accounts permanently from your Mac: Step one The first thing you’re going to need to do is open Apple Mail, then go to the Menu bar and open Mail > Accounts....

QUESTION My installation of Microsoft Office 2013 has become corrupted and I want to re-install it. However, the uninstaller program refuses to work. How can I remove Office and start again without having to reinstall Windows? HELPROOM ANSWER Microsoft has a ‘Fix it’ that you can download to solve this problem. Go to support.microsoft.com/kb/2739501 and then click the Fix it button to download a small utility which will hopefully uninstall Office 2013 for you....

Can other devices in the house get online? Can you load websites via a different web browser? If the answer to both is no, chances are your broadband connection is down, or the router needs resetting. Try powering off your router and restarting it a minute later. Alternatively, it could be a software or hardware problem with your computer’s network adaptor. Often, restarting your computer will fix this, but you can also make sure Windows is fully up to date by searching for ‘Windows Update’ at the bottom of the screen....

How to Root Moto G5s Plus and Install TWRP Recovery In our today’s guide, we’ll be discussing some easy steps on how to root and install the latest TWRP v3.1.1-0 custom recovery on Moto G5s Plus (sanders) smartphone. By rooting and flashing a custom recovery like Clockworkmod (CWM) or TWRP, you can easily install custom firmware, custom kernels, mods, remove bloatware, take Nandroid backups or restore, wipe out data, do a factory reset, increase internal memory and do much more on your Moto G5s Plus....

If you find your email program doesn’t allow you to create contact groups, there may be a workaround. For example, you can’t create groups on an iPhone or iPad, but you can do so via the iCloud website. You might also find that, while you can create a group of contacts (as with iCloud) but you can’t then select the group when sending an email. For small numbers of people, it might be faster to type the first few characters of their name and use your email application’s auto-complete function to select their address....

Tablets designed specifically for children have become more and more common over the last couple of years, but the same isn’t true of smartphones. While our tutorial here applies to tablets running Android Lollipop (the screenshots were taken on a Nexus 9, reviewed) we wrote it primarily because it’s a new feature for smartphones running Google’s latetst version of Android. You can read more about Lollipop in our full review....

See also: Best routers to buy right now How to stop an Asus router being hacked: the problem Like many router manufacturers (but by no means all) Asus uses some basic default credentials so you can easily set up the router when you unbox it. The problem is that a lot of people don’t bother or don’t realise the risks, so leave the username and password both set to admin....

How to sync Gmail, Google Contacts and Google Calendar with Windows Phone 8 When adding a Google account to your Windows Phone, you can simply go to Settings, email+accounts, add an account, but we’ve always found it easier to deal with contacts and Gmail separately, allowing you to get the People, Google Mail and Calendar apps working exactly how you want them. First, open the People app on your Windows Phone....

Lithium-ion batteries simply aren’t capable of maintaining the out-of-the-box performance over an extended period of time. However, this process has been accelerated by planned obsolescence, where companies deliberately limit the lifespan of a device to encourage you to upgrade. While it might be obvious to you that your battery life is not what it once was, it might be worth getting some official information on how bad it’s really good....