Connect with us


How to Make a Bar Graph in Excel?



If you have been reading our tutorials, you must know that in one of our previous articles, we have provided some of the guides on Excel programs. Probably you would be aware of that. If you have missed out our tutorial on excel program do read out them. You can click here for directly navigating to the excel tutorials.

One of such tutorials was how to create charts in excel. And today the guide we are going to provide is quite similar to that guide. The tutorial we are going to provide today is How to make a bar graph in excel.

If you struggle to create a bar graph in excel, then probably the article is written for you. Since this article is going to describe the complete procedure to make a bar graph in excel. So, let's begin the guide how to make a graph in excel. There are other ways to represent the numerical data in an attractive manner like Charts. Here is how to create a Chart in Excel.

How to Make a Bar Graph in Excel

The today's guide how to make a graph on excel is thoroughly going to describe all the steps that too with screenshots. I am quite, sure after reading the article, there won't be any doubt remain regarding the procedure of creating the bar in excel.

The tutorial on how to make graphs in excel in given below. Let's head over it and learn how to graph on excel. 

The procedure for creating graphs or charts in excel is same in almost all the versions of excel program. But the screenshots we have provided below are taken from the MS excel 2007 program.

Step 1: First of all, launch the excel program to your system and fill out the necessary data you want to make a bar graph of. Check out the below screenshot.

In the image I have mentioned below, I have added some random name and the dates. You will have to feed the entries as per your need and requirements. Check out the screenshot below.


Step 2: After you have entered all the data in the excel program, select them. You have to select the data you want to create the bar graph of. If you want to create the bar graph of all the data entered in the sheet, select all.

Step 3: Once done with the above step, I mean highlighting the area(Row/Column) click on the Insert menu from the menu bar.

If you notice, after clicking on the insert menu, many options has started appearing. Like Columns, pie, bar, area, scatter etc. Here, you have to click on the bar option. As you are here to learn how to make a bar graph. Check out the screenshot I have taken for you. If you are confused, this screenshot will help you in understanding better.


Step 4: Here, simply click on the bar option. After clicking on the bar, a drop down will open up where you will see a list of bar graphs. All you will have to do is select the type you want to create the graph of.

As sooner, you will click on the graph, excel will prepare the bar graph for the selected area. And you are done. Check out the below screenshot I have mentioned.


So this is how we can create graphs in excel. As I said above creating graphs or charts in excel are just a few clicks step. I hope after reading the steps you must have got that, how easy is to create a graph in excel is.

Well, this was about creating the simple bar graph in excel. But if you are not satisfied with the color or type, you can change that too. Yes in the design section, you can change the design and color of the graph as per your choice.

When you click on the design option you will see an image like I have mentioned below. Have a look on that.


Remember you won't be able to see the design option at the menu bar until you select the created bar graph. When you click on the bar graph, then only the option would appear on the menu bar under the chart tools section.

And you can also change the bar style by clicking on the chart style option at the right-hand side of the screen. You can apply any kinda chart type to your bar graph. But I will suggest you to keep it simple to give the even more official look.

Moreover, you can also change the chart type. To do that you will have to click on the change chart type option from the top left side of the screen. When you click on the change chart type option you will see a drop down will pop up. Check the image below.


In the above image,  I have marked the change chart type option with the red rectangle and the types of charts with a yellow rectangle. All you have to do is click on any of them as per your need and the suitability.

You can also switch columns and rows by clicking on the Switch Row/Column option. You will find this option just beside the change chart type optionCheck out the below screenshot if you are unable to find the option.

So this was only about how to make a bar graph in excel. I am expecting you have liked and enjoyed the guide. And have found the purpose for landing on this page.

Excel is indeed a great application program that is being used by many people for maintaining numerical data. You can easily divide numbers in excel, you can find average on Excel and moreover, you can also compare two excel files that also helps in finding the duplicate data.

In the case of any confusion do drop your comment below. Or if you have any suggestion then also you can share with us.

The procedure I mentioned above was about creating the bar graph in excel. But if you want to create a chart or scatter plot in excel, then also you will have to follow all the steps again. But instead of going to bar option you will have to go to the chart or scatter plot options as per the demand.

If you enjoyed our today's tutorial, share it on your social media platforms. We will highly appreciate that.

Sonam is an IT engineer by education and passionate freelance writer/blogger by profession. She is a tech enthusiast and loves to read and write about technology. Her hobbies include reading, watching TV, delving into new things and creating interesting content to help people with all things tech!!

Continue Reading
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *


How to Search For a Word on a Web Page?



Have you have ever felt the need of finding out a particular word or phrase while surfing the web?? If you have ever been using the internet you must have, I'm sure! And needless to say, lack of information regarding finding the words must have tended you to search for the guides such as

And needless to say, lack of information regarding finding the words must have tended you to search for the guides such as how to search for a word on a web page, how to search a page for a word and so on…

Probably there are various ways to find out a word or a page on a web page. We will see the best out of them. Let's figure out how to search words on a web page in very easy steps.

How to Search For a Word on a Web Page

Nearly all the web browsers come with find option which allows users to find an individual word or page on any web page. Finding out any word or phrase over a website is very easy. If you have ever wondered how to search on a web page then probably you have got your destination.

In this article, I will let you know some of the best ways to find out the words over a website. Read out the complete guide and know how one can find out particular pages, words or phrases over the web.

How to Search Within a Website

The best way to search anything within a website is by pressing “CTRL+F”. This option not only lets you search any word within the website or over the web but you can also use this key combination to search even offline windows.

Yes, in order to search for anything, you will need to type CTRL along with the F key. As sooner you will press this combination, a find box will be opened up. Whenever you start typing over, your browser will find matches as you type. Check out the below screenshot.

In the image as you can see, at the top right corner, there is a find tab opened. Whenever typed in any word, the web page will start highlighting the text. In the image above, I have typed word history and the same word has been highlighted with yellow.

Another way to find a word within a website is by using their inbuilt search option. There are many websites that offer a search option to search for the words over the web page. This search option can be found mainly on the home page of the websites.

Type a word in the search bar and hit enter. The search query would start appearing on the screen abruptly. Check out the given screenshot if you are not able to find the search option over the web.

How to Search for Words on a Web Page on Chrome:

If you want to search a single word or line then Find tool I described above can also be used. Moreover, you can also use an extension to find words on a web page. One of the extensions for chrome is Pearls Extension.

This extension gives you the ability for quick search results on any web page. This extension has the ability to store the query you put.

This means whenever you search for any specific queries for a single page or domain, it will remember them for the next time you visit the page. As a result, you will save lots of your time.

How to search for a word on a web page

You can also use the Previous and Next button to jump to the words throughout the whole web page.

You will get more if you use it by yourself. To use this extension on your browser all you will need to do is add this extension to the chrome browser. Here is the direct link to that extension.

Another extension that could be used from Chrome is, efTwo (F2) and MultiHighlighter. These extensions work almost the same as the above-mentioned extension.

How to Search on a Webpage on Firefox:

Just like google chrome, in firefox as well words can be found with the help of find tools. To find this too you can go to the menu of the firefox. The three lines at the top right corner of the page. Once you click on the menu bar you will see some options like the below-mentioned screenshot.

As you can see in the above image I have marked the find option with a red square. When you click on the Find option, at the bottom of the page a find option would go highlighted.

You will need to type a word or line you want to search for. And just similar to google chrome all the words related to your search query would be highlighted.

If you don't want to follow the long procedure to find the find tool, simply press CTRL+F. The find tool will go active. Again type a word and search for the query within a second or so your result would start showing throughout the web page.

Ctrl+F command work on almost all the web pages infect on all the windows. If you working on the system like on MS Excel or MS word then also you can use this command to find out any word.

Another way to find a word on firefox is by pressing the “/” from the keyboard. The Quick Find bar is useful for quick searches and is meant to disappear after a few moments.

It does not have the Next, Previous, or Highlight All buttons like the full Find bar. To use a quick search option simply press “/” and type the word you want to search for.

With this, I have come to the end of the article. I am expecting you have no more queries remain regarding finding out any word or phrase over the web.

Perhaps after reading the guide, you will not have to look for more queries anymore such as how to search for a word on a web page and so.

If there is still any doubt or confusion don't hesitate to ask by dropping the comment in the comment section. If you liked and enjoyed the article or find it worth sharing go ahead!!

Continue Reading


How to Unlock a Locked Phone?




How to Unlock a Locked Phone

Do you want to know how to unlock a phone?

I am not talking about the password, pattern or fingerprint lock on your device. But the lock comes with the device itself called carrier lock.

If you bought a phone exclusively from a telecom operator for a low price, you would know what I am talking about.

In this article, I want to give you complete information on how to unlock a locked phone.

I hope you are ready to get deep into the article now. So, here you go!

How to Unlock a Locked Phone?

Comparing with the pattern or PIN lock, unlocking a carrier lock will need more effort and time for you. And the procedures are different for different carriers as well.

What does an Unlocked Phone Means?

Maybe you are new to this whole locked phone stuff. So let me explain it to you.

Some operators sell expensive phones like iPhones for a cheap price in return for a contract that lasts for a particular period say two years. That means you need to use their telecom service for the next two years after you buy the device from them.

Once you set out to remove their SIM card and try to insert another from the separate network operator, it won’t work until the set contract period gets finished. The fact is that a particular unit contains a secret software code, which is responsible for the lock.

The manufacturer itself does the code integration into the unit upon the request of the network carrier. You can’t do much about it at once.

So, what is an unlocked phone?

A phone with no carrier constraint is called an unlocked phone no matter what it was locked in the past.

Why does a Carrier Lock a Device?

I have already told you the reason. They provide you with an expensive unit for a cheaper price. In return, all they want is you as a customer for a given period. They make up the discount in price for the device from the profit in service.

Is My Phone Unlocked?

You may have a question in your mind now ‘is my phone unlocked?’.

No geeky brain is needed to figure it out. Just pull out the SIM card on your phone and, insert another. If you get signals for the second SIM, you know it is unlocked. In case you don’t, your phone is carrier-locked.

How to Unlock a Phone?

As I said earlier, you need to incorporate different methods to unlock phones from different carriers. You can find how it can be done for a few operators here.

#1. Verizon

According to the company, their 4G LTE devices aren’t locked. So, you don’t need assistance in using other SIM cards on such phones.

what does an unlocked phone mean

They don’t have an online unlock request receiving system. But you can place a request via 1-800-711-8300.

Though most of the 3G devices of Verizon aren’t locked, you will have to enter either 000000 or 123456. Until you do the same, third-party operator compatibility will remain a mirage.

For the special world devices, technical support is needed for the process of unlocking. You can seek help from (800) 922-0204 also.

#2. AT&T

Unlike the previous operator, AT&T offers an online request receiving system.

how to unlock a locked phone

But you must be sure about the following things before you place a request for unlocking the device.

  • The device should be from At&T
  • You must be their subscriber
  • The device should have been active for the last two months
  • You don’t have an unpaid balance or due
  • The device shouldn’t be reported stolen or lost
  • Make sure you made less than five requests last year.

Once you come to the terms, you can fill this form out to place a request. Generally, it would take up to five business days to complete the process.

Even though they don’t provide unlock-over-the-phone service, you can seek their assistance via 1-800-331-0500. If you have a prepaid connection, the period of activity is the whole year.

#3. Sprint

When it comes to unlocking a phone from Sprint, you must follow all the bullet-point guidelines beneath the previous subhead, but with a couple of slight differences. The period of activity is 50 days and the maximum requests per year are two on contrary to two months and five requests of AT&T.

Sprint phones manufactured before 2015 can’t be unlocked according to the company. But those after that year aren’t impossible to unlock. You need to call talk with their customer care executive either via phone ((888) 211-4727) or online chat.

what is an unlocked phone

If you are a person who is about to go abroad and wants to get the phone unlocked, you are eligible to request a short-term unlocking provided you meet the guidelines. First, you need to sign in to your account, then follow My account>> Manage this device>> Unlock device to use int’l SIM.

That’s it.

#4. T-Mobile

T-Mobile too wants you to be a good customer who follows a bunch of guidelines. Everything is similar to that of Sprint. But here T-Mobile has an additional instruction that clients who are on a service contract should have made at least 18 monthly payments.

The prepaid phone should be active at least for a year to request for unlocking. And, you should have done $25 (for feature phones) or $100 (for smartphones) refill within that period to be eligible.

how to unlock a phone

Unlike the other three carriers I have shared, T-Mobile has a dedicated unlocking app, which clears the air. In case you prefer customer support, call 611 from your T-Mobile connection.

Wrapping Up

I hope you now know how to unlock a locked phone.

Obviously, there are third-party offline and online services for the same unlocking purposes. If you know of anything legitimate, you are invited to mention the same in the comment section down below.

In case you get confused, don’t forget to let me know about the issue in the comment section down below.

In the meantime, feel free to share this post on social media.

Continue Reading


How to Extract Audio from Video?




how to extract audio from video

Are you looking for a way to extract audio from video?

We often feel this urge to separate audio from video songs, especially when the mp3 version isn’t available.

If you are a person finds it difficult to get audio from video, you have just found the right spot as I am going to walk you through the same in this article.

Are you ready to dive deep into the core of this post? Here you go!

How to Extract Audio from Video?

There are tons of file format converters available on the web that serves the purpose of extracting audio from video. Here I am going to share a few of the working methods that help you to know how to separate audio from video.

#1. Use Audio-Extractor

Audio-Extractor is a sound separator available online. You can throw any video file at it to get the audio version of the same. It supports eight different audio formats including the popular ones like mp3 and wav.

I have listed down the steps to get audio from the video down below.

Step 1: First, you have to visit the audio-extractor homepage. Use any of your favorite web browsers to visit this URL.

Step 2: Once you reach the target page, you can see a blue button labeled Open video. You can also see a Google Drive link right next to the button. In case you have video files from which you want to know how to remove audio from video on Google Drive, you should click this link.

How to Extract Audio from Video

Step 3: You will then see a video browsing dialogue box. Just navigate to the right directory and choose the file. Press Enter or Open.

Step 4: You have to choose any audio format next. As you saw in the image given above, there are about six formats visible. In case, you don’t see anything you want there, click More and, you will have two additional formats right away.

Step 5: You will see a progress bar on top of the page that implies how much of your video file has been converted to audio.

How to Extract Audio from Video?

Step 6: Once the conversion is completed, you can save the audio file.

#2. Use Format Factory

If you ask me for the best file converter, I can’t help myself from recommending Format Factory. I have been using it for more than half a dozen years.

In this section, you are going to read how to get audio from video using Format Factory.

Step 1: First, you have to install Format Factory. As in any software installation, you need an executable setup file for the same.

Download Format Factory

You can download the setup from the link given above. Then, you must proceed to the installation for like any other software.

Step 2: Once you finish with the installation, you will get a desktop shortcut to open the software. In case you don't get, you need to check the installed directory.

Step 3: On the right side of the interface, you can see a list of different file formats. Just go for audio from there and then, MP3. That doesn’t mean you should also opt for the same format. You can select wav, WMA or any other file extension.

get audio from video

Step 4: You can see a new sub-window. Just click on Add files and browse to the video file from which you want to extract video.

get audio from video

It is possible to set range and change output settings as well. Then, click OK.

Step 5: Finally, you have to hit Start from the main window to convert video to audio.

get audio from video

If you want to change the output directory, you need to click Options there.

That’s it. Format Factory will open the output folder for you on completion.

I hope you now know how to get audio from video.

#3. Use VLC Player

Do you know VLC Player? If you are a computer user for a few years, you might have at least heard of this media player. You can download the same for your Android device as well.

Step 1: As always, you have to install VLC media player.

Download VLC Media Player

The above link will get you to the official VLC download page, where you need to select the appropriate platform.

Step 2: I don’t think you want a guide on how to install a tool using the setup link. So, just install the same. And, open the player using the desktop shortcut or direct application icon from the installed directory.

Step 3: Now you have to follow File>> Advanced File Open or just hit Ctrl+ Shift+ O.

how to remove audio from video

Step 4: You can see a button on the right portion of the screen that says Add. You desperately want to know how to remove audio from video, right?

how to remove audio from video

Then, click on the button and choose a file.

Step 5: Can’t you see small down headed arrow at the bottom of the new window? Click on the same to get a new context menu with a set of options. Select Convert from there.

how to remove audio from video

Step 6: You will now get a new wizard where you have to choose the output folder and format. Click on the Browse button right next to the Destination file field.

how to remove audio from video

As we need to convert video to audio, you have to choose MP3 from the Profile drop-down menu. If you are geeky enough to alter the output format, you can do the same by clicking on the small setup button on the right.

Step 7: Finally, click on Start. There you go. The duration of the process solely depends on the size of the file you have chosen.

Wrapping Up

Don’t you know how to extract audio from video now?

I have given you three different methods to help you convert video to audio. Of course, there are tons of other online and offline methods to serve the very same purpose.

But there’s no point in sharing a lot of solutions for the same problem given all of them are finely working.

If you have any doubts regarding this article, don’t forget to reach out to me using the comment section down below.

I appreciate if you share this with your social media peeps

Continue Reading


How to Make a Hopper in Minecraft?



Hoppers are a very important part of Minecraft as they are highly useful blocks for the gameplay. If you are new to the game, you should know how to make a hopper in Minecraft and this guide will help you learn that.

Hoppers collect things out of an ampule above it and from around it. It holds these items and keeps them in an ampule under it or fixed to its side.

They can be utilized for automatically collecting the dropped things from monsters destroyed in a trap, making auto cooking appliances, or almost anything else that one could think of. In simple words, the hopper is a basic thing in the player’s inventory.

The Hopper block was first added to the Minecraft 1.5 edition. It is similar to a funnel and looks like an anvil. It can be easily crafted using two common ingredients. If you’re using a Minecraft Pocket Edition, hoppers do not exist in it.

Learn How to Make a Hopper in Minecraft

how to craft a hopper

To make a hopper, players will need 5 iron ingots and a chest. Once your hopper is crafted, you can create automatic furnaces, Minecraft delivery systems, and also breweries.

To use these blocks, you will have things to place in it, 2 ampules (example: furnace or chest) and a power line for deactivating it. Follow these steps to know how to make a hopper in Minecraft:

  • Before you start, ensure that you have a crafting table that can give you the 3×3 crafting grid and the needed materials.
  • Let’s assume that you have created a crafting table by now in the game and kept it at someplace on the map. Try to find this table. Now, stand in front of it.

Next, access the crafting menu. To access the menu, open the crafting table and the game control for opening the table depends on the Minecraft edition you are using:

  • For Pocket Edition, click on the table to access the menu.
  • For Mac/PC, right-click on the table to open the menu.
  • For Xbox One and Xbox 360, tap the X button on the game controller to access to crafting menu.
  • For PS4 and PS3, hit the square-shaped button on the play station controller to access the menu.

Once you open the crafting menu, you will find a crafting area made of a 3×3 crafting grid. Keep a chest and five iron ingots in this grid to create a hopper. When creating a hopper, it’s crucial that the chest and the iron ingots are positioned in the right pattern.

The first row should have one iron ingot in the 1st box, and there should be one iron ingot positioned in the 3rd.

For the second row, one ingot should be kept in the 1st box; one chest should be kept in the 2nd box and one ingot in the 3rd box. The third row should have one iron ingot in the 2nd box. If you change the pattern of these boxes, the crafted item will also change.

If you’ve filled the crafting region with the right pattern, you can find the hopper in the box on the right.

Once you’re done with creating a hopper, you have to shift the created item to your inventory. There are two parts to inventory.

The three rows on the top are things in your inventory, though they aren’t directly accessible for use. The fourth row or the bottom row is called the Hotbar. These are nothing but your inventory items, which can be used immediately in the game.

This is the crafting recipe to learn how to make a hopper in Minecraft. If you’ve started playing Minecraft, how to make a hopper is a must-learn technique for you to be successful in the game.

How to Use Hoppers?

Now that you know how to craft a hopper, you should also learn how to use a hopper in Minecraft. Here are some quick steps that can guide you through:

  • Once you’ve crafted the hopper, decide what you wish to create using it and where it has to be placed.
  • Keep it above or near the ampule you wish it to place things into by clicking on that ampule. If you’re keeping it near the ampule and are opening it rather than positioning the hopper, you need to hold on to shift and then click.
  • Keep the ampule you wish the hopper to take things from over it.
  • Keep a lever near the hopper on a block or a Redstone line.
  • Flip the lever or switch on the red stone for deactivating it.
  • Keep things on your machine top.
  • Switch off the lever to get it going.
how to make a hopper in Minecraft

Using a hopper, you can crouch, drop items into it, place it on an ampule, place an ampule over it, set up an auto furnace station, and deactivate it with Redstone.

You can also add more hoppers to Minecraft if needed. You can combine a hopper and Minecraft – pick up items with a hopper and unload them with another.

In some editions, the Hopper shifts things to a chest from its inventory similar to a funnel in several ways (when the chest is kept directly under the Hopper).

 how to use a hopper in Minecraft

It doesn’t need Redstone and is capable of automatically exporting things. Players can access the hopper by right-clicking on it. It has an inventory menu similar to a chest, where items can be removed and stored.

Now that you know how to make hoppers and use them get going and enjoy your Minecraft experience. If you get stuck up anywhere in between the procedure, drop your queries in the comments section below, and we’ll answer them to solve your doubts.

Though, it’s unlikely that you get stuck in between as the process is quite simple and straightforward. You can also share your views with our readers through the comments section.

Stay tuned on this blog for more such informative tech and gaming guides.

Continue Reading


How to Format a Write Protected USB Flash Drive?



Have you ever encountered a situation, when you just inserted your USB Flash drive into your computer and tried to format it but alas, what you see is the error “Your disk is write-protected”? Your landing on this page ensures that you do have gone through such situations and you want a quick solution on how to format a write protected USB flash drive.

Write-protection on disks is the feature that is designed to protect our data on USB flash drive from being modified without authentication.

Many times situation comes when our system get infected by various types of malicious functions and files, stored on our computer system gets modified without our permission. It happens because those files on our computer systems are not write-protected.

If these files were read-only, no virus, malware or any bad program on earth could ruin these files. Well, my point was just to let you know that such protections are meant to prevent users from unexpected data loss.

But we don't all the time want such write-protection on our USB flash drive or pen drive. Sooner or later, we feel the need to format the flash drive or feel like modifying the existing files stored on our pen drive.

But How to erase a write-protected USB drive or SD card?? Well, that's what we will be teaching you today! We will tell you, how to format write protected pen drive in easy steps.

How to Format a Write Protected USB Flash Drive:

Formatting a write-protected USB flash drive might not be a one-step process but it's not a tough process either. In fact, there is more than one method available to Enable or Disable Disk Write Protection on USB flash drive or pen drive.

The first method which we have mentioned below involves the Command Prompt. The second method is using the System Registry and the last method to disable write protection from a pen drive is by using third-party software.

In this guide, we have covered first and the second method as both these methods are sufficient and works in most of the circumstances.

But before we head over to the steps, I would like to confirm if your USB flash drive has a physical button to enable or disable disk protection.

Most of the new pen drives and flash drives are coming with this button and we can simply enable or disable write protection on them by simply switching on or off this little button.

Have a look at the below image to understand how this button looks like. If your USB flash drive has any such button, you no need to go any further and follow any method. Just locate this button on your drive and enable or disable it as per your need.

Okay, so let's get started with the guide.

Method 1. Using Command Prompt:

In this method, we will be using a Windows command prompt utility called Disk part. Here's are the steps.

Step 1. First of all, click on the Start menu, and type cmd in the search bar, right-click on the first result and select Run as administrator from the list of options.

Step 2. As sooner you do this, Command prompt window in the administrator mode will pop up. See the screenshot below.

Step 3. Now you need to type in diskpart in the command line and press enter. Once done, type in list disk command in the command prompt and press enter.

These commands will instruct your computer to list out all the internal and external hard disks associated with your computer. The list will be in a sort of a tabular form.

You can understand this whole step by having a look at the below screenshot.

Step 4. Now you need to identify your USB flash drive out of all the listed drives. Usually, the one with the low storage capacity mostly in MBs is your USB flash drive. As in our case, it is  Disk 1, with 3819 MB capacity.

Step 5. After identifying the USB drive, it's time to select it. So you need to run the command “select Disk 1″. You can replace “Disk 1” with flash drive name on your computer.

On doing that, a pop-up window will appear notifying you about disk 1 selection., exactly like the below screenshot.

Step 6. We are almost done to make the USB drive protection-free. Once you are done following the above steps, it's time to run one more command. Now type in “attributes disk clear read-only” and press enter.

On doing that, you will see a success message that disk attributes are cleared successfully and your drive will become protection free.

Step 7. Now you can format the drive via command prompt running the commands clean, create partition primary, and format fs=ntfs respectively. Or by simply right-clicking the drive in my computer and selecting Format. It's completely your choice.

Method 2. By Using Registry:

If you are not very comfortable with command prompt and want an alternate method, follow the below-given steps.

Step 1. As I said above, this method involves Registry Editor. So, to reach there, press Windows+R keys together and type regedit in the run window's search bar and press enter. Have a look at the below screenshot.

Step 2. In the registry editor, you need to follow the below path.


As you reach there, you will see the Writeprotected written in the left pane. See the below screenshot to understand better.

Step 3. Now double-click on the Writeprotected and another window named Edit DWORD will pop-up.

Undervalue data, you need to change the value from 1 to 0 to disable write protection from the drive. You can understand better if you see the below screenshot.

Once done, just press ok and you are done. Now you can edit the files stored on your pen drive or can format it depending upon your needs.

I guess, you know the process to format the drive, isn't it?

So, that's it for this guide. I'm sure you got all the steps clearly on how to format a write protected USB flash drive. If you have encountered any issues in following the steps, feel free to write to us in the comment section below, we will reach out to you as soon as possible.

Continue Reading