How To Guides

How to remove duplicates in Microsoft Excel

Updated

May 26, 2020

How to remove duplicates in Microsoft Excel | Gadgets Now

Table of Contents

Microsoft Excel is a really highly effective doc processing instrument particularly in relation to making studies, calculations and storing a database for any explicit mission. However, at instances, whereas creating an excel spreadsheet individuals typically face challenges and make errors because of duplicate values in your information.

Also Read: How to Install & Remove Best Gmail Add-ons

Thankfully, Microsoft Excel comes with a characteristic that permits customers to seek out duplicate values and take away them. Follow our step-by-step information to seek out and take away duplicate values in Excel spreadsheets.

Do be aware that deleting duplicates will completely take away these values.

How to seek out and take away duplicates in Excel

1.

Select the cells for which you wish to search for duplicate values

2.

Click on Home and head to Conditional Formatting possibility

3.

Here, select Duplicate Values possibility beneath Highlight Cells Rules part

4.

Now, decide the formatting you wish to apply for duplicate values and click on on Ok

5.

Also Read: How to Password Protect a Word Document
Once the values are highlighted, choose the vary of cells that has duplicate values

6.

Click on Data and choose Remove Duplicates and examine or uncheck the columns the place you wish to take away the duplicate values.

7.

Click Ok to use the modifications

Source link

Don't forget to connect with REVIEWTECHAUTO on Facebook, Telegram, YouTube, and Instagram.

Up Next

How to verify whether your e-pass is valid or not

Don't Miss

How to apply e-pass using government’s new e-Pass website

Click to comment

How To Guides

How to Clean your Laptop Screen and Keyboard Safely [Updated 2021]

Published

2 months ago

January 5, 2021

Payal

Table of Contents

The laptop has today become a basic necessity, and with its regular usage, you can see dust and dirt sticking to its screen, back panel, keyboard, and base. This not only affects its overall functioning, but it also looks weird. Have you ever thought about how you can clean your laptop screen and keyboard? Well, check out the easy-to-execute and straightforward steps that will help you clean your laptop and remove dust & dirt.

Basic Requirements to Clean Your Laptop

Before moving ahead, you must know the list of required items prior to start cleaning your Laptop and removing the dust/dirt completely. Further, you should shut down your Laptop and remove its adapter before cleaning. Below listed are the cleaning essentials required for outside cleaning process.

A microfiber or lint-free piece of cloth
Water or Colin
Earbuds

Also Read: Clippers vs Nuggets live stream: how to watch game 3 of the NBA playoff series today

Products To Avoid For Laptop Cleaning

Aerosol sprays, solvents, abrasives, or cleaners containing hydrogen peroxide

How to Clean the Exterior of the Laptop

Take a piece of microfibre cloth and dip it slightly into the water. Now, slowly scrub the outer section of your Laptop till it starts shining. Scrub its sides attentively as the side panels have disc-drive, USB/Audio? Ethernet/Charging and a few other ports. Make sure the microfiber cloth isn’t wet much. Also, make sure the water doesn’t enter the Laptop in whatsoever way. Water can damage the port or the motherboard.

How to Clean the Screen of the Laptop

The screen is a delicate component of your Laptop, and hence it needs extra care. I prefer cleaning the screen with a dry cloth and wipe the dirt completely. Take the cloth to its corners to wipe off maximum dust/dirt from the screen. Now, clean the screen with a wet cloth. Remember, no additional chemical/liquid is required to clean the Laptop’s screen.
Just be gentle with the wiping process and don’t overdo it with too much force, as it can cause some damage to the screen.

Also Read: Here’s How to Easily Remove Passwords From PDF Files

How to Clean the Laptop Keyboard

Working regularly on your Laptop has a direct effect on its keyboard. The keyboard is also an essential component of the Laptop that needs a periodic cleaning. However, cleaning the keyboard is tricky. With regular usage, some crumbs get stuck between the keys that restrict the key from functioning correctly.

Start by inverting your Laptop (upside down) and run air spray onto it. Most of the dust/dirt is removed from the keyboard. Still, if you find some crumbs, it’s recommended to clean them manually and remove them as soon as possible.

Don't forget to connect with REVIEWTECHAUTO on Facebook, Telegram, YouTube, and Instagram.

How To Guides

How to Uninstall Adobe Flash Player from Mac, Windows and Browsers

Published

2 months ago

January 5, 2021

Payal

How to uninstal Adobe Flash Player from Mac, Windows and browsers | Gadgets Now

Table of Contents

Adobe Flash is officially discontinued from December 31. However, numerous web browsers, Operating Systems and other associated services are still using Adobe Flash player. Post December 31, Adobe won’t provide any support to Flash related queries.

Also Read: How to create, customise and scan Instagram QR code | Gadgets Now

So, if you are looking to uninstall the outdated Adobe Flash plugin/software from your browser/operating system, follow the steps given below and execute our step-by-step guide:

How to Uninstall Flash Player from Mac

Uninstalling Adobe Flash Player on Mac is a little more complicated compared to any regular software or application because they don’t appear in the Launchpad or Application folder. The only place it can be found is in the System Preferences option of the Mac.

Step 1: Run the Flash Player Uninstaller by double-clicking on the Uninstaller icon

Step 2: On the Uninstaller tool, click on Uninstall button

Step 3: Click on Done button after you see a message “Adobe Flash Player was removed from your system’

Step 4: Clear directories related to Flash Player

/Library/Preferences/Macromedia/Flash Player
/Library/Caches/Adobe/Flash Player 6

Also Read: Clippers vs Nuggets live stream: how to watch game 3 of the NBA playoff series today

At last, verify whether Flash Player Uninstall was successful or not. To do this, restart your computer and head to https://helpx.adobe.com/in/flash-player.html and click on Check Now button.

How to Uninstall Flash Player from Windows/browsers

Flash Player on Windows depends upon the browser you are using and that’s because browsers like Chrome, Edge, Opera and Firefox have their version of Flash and some of them even come built-in with it. All you need to do is disable it from the browser’s settings. Here’s a browser-wise list on how to do it.

Uninstall Flash Player On Chrome:

Uninstall Flash Player On Opera:

Uninstall Flash Player On Chromium-based Edge:

Don't forget to connect with REVIEWTECHAUTO on Facebook, Telegram, YouTube, and Instagram.

How To Guides

Adobe Flash Player support ends December 31, 2020: How to play Flash games in 2021 | Gadgets Now

Published

2 months ago

December 31, 2020

Payal

Today is officially the last day for Adobe Flash Player. The company is pullling the plug on Flash player from midnight today, December 31, 2020. Post this, all popular browsers across platforms will remove Flash. Once the major browsers stop supporting Flash Player, websites that offer Flash-based content including games and animations too will have to remove them.

If you pained that you will no longer be able to play those popular Flash games that you have grown up playing, then you really need not. There are ways to help you continue playing those games. Here’s where and how you can continue playing these games.

Also Read: How to setup and use VLOOKUP formula in Microsoft Excel

Play online on Internet Archives website

The new home for Flash content is Internet Archives website. The website has started collecting Flash games, apps and animations. Interested gamers will be able to use/play these games through emulation.

To start playing, one needs to simply visit the ‘https://archive.org/details/softwarelibrary_flash’. Once there, click on the game you want to play and there you get going.

The offline way: BlueMaxima’s Flashpoint

The offline option is BlueMaxima’s Flashpoint software. This is a web-games preservation project that was started in January 2018. The database now includes 70,000-plus games and over 8,000 animations from 20 different platforms including Flash.

Also Read: How to create, customise and scan Instagram QR code | Gadgets Now

Flashpoint comes in two versions — Flashpoint Ultimate 9.0 and Flashpoint Infinity 9.0. The Ultimate version weighs 478GB as download that goes up to 532GB post installation. The Infinity version is way smaller, it’s download size is 500MB that expands to 2GB after installation.

Users need to download the software from: ‘https://bluemaxima.org/flashpoint/downloads/’

Next step is to install it on their systems. Once done, all the Flash games from the Flashpoint database can be played offline as well

//-- BEGIN Chartbeat CODE -- if(typeof TimesGDPR != 'undefined' && typeof TimesGDPR.common.consentModule.gdprCallback == 'function'){ TimesGDPR.common.consentModule.gdprCallback(function(dataObj){ if((typeof dataObj != 'undefined') && !dataObj.isEUuser){ (function(){ function loadChartbeat() { window._sf_endpt=(new Date()).getTime(); var e = document.createElement('script'); e.setAttribute('language', 'javascript'); e.setAttribute('type', 'text/javascript'); e.setAttribute('src', (("https:" == document.location.protocol) ? "https://s3.amazonaws.com/" : "http://") + "static.chartbeat.com/js/chartbeat.js"); try{document.body.appendChild(e);}catch(e){} } $( window ).load(function() {loadChartbeat();}); })(); } }); }

//--END Chartbeat CODE -- //-- Facebook Pixel Code -- !function(f,b,e,v,n,t,s){if(f.fbq)return;n=f.fbq=function() {n.callMethod? n.callMethod.apply(n,arguments):n.queue.push(arguments)} ;if(!f._fbq)f._fbq=n; n.push=n;n.loaded=!0;n.version='2.0';n.queue=[];t=b.createElement(e);t.async=!0; t.src=v;s=b.getElementsByTagName(e)[0];s.parentNode.insertBefore(t,s)}(window, document,'script','https://connect.facebook.net/en_US/fbevents.js'); fbq('init', '1181341651961954'); // Insert your pixel ID here. fbq('track', 'PageView'); //-- DO NOT MODIFY --> //-- End Facebook Pixel Code -->

Source link