Web
Analytics
Connect with us

Tech

How to Add Columns in Excel?

Published

on

How-to-add-columns-in-Excel

It is fairly obvious that the usage of Microsoft Excel has been increasing at a rapid pace in the business environment. A lot of people face difficulties in getting their hands on Excel. How to add columns in Excel is one such problem faced by maximal people.

With the modern techniques popping up, doing the same task manually gets a lot more tedious and time consuming. Once you start using Excel, you will realise, what a savior it is to all your problems. Inserting or adding rows or columns in Excel is one of the most basic and commonly performed actions in Microsoft Excel.

A lot of people barely know the basic tricks that ease out the process of working on Excel. We will cover a lot of basic formulas and advanced tricks to help you understand the process of adding columns in Excel. It basically, includes simple formatting and SUM function. Let's dig deeper into the process of same.

Before initiating the process of adding columns in Excel, let’s have a look at how to insert a column in excel:

Inserting a Column

In case you need to add new column to the existing Excel worksheet, rather than going through all the trouble of moving and rearranging several individual cell ranges, you can simply insert new columns or rows via:

  1. Select a cell to the right of where you wish to insert the new column. Let’s take an example that select cell B1 because we want to insert a new column between column A and column B.
    how-to-add-a-column-in-excel
  2. Now, right-click and select “Insert” from the popup menu.
    how-to-insert-a-column-in-excel
  3. When the Insert window appears, click on the “Entire column” selection and click on the OK button.
    how-to-insert-a-column-in-excel

A new column will now be inserted into the spreadsheet. In this example, we have inserted a new column into column B. All of the columns to the right of column B will be shifted to the right. In case you have confidential data and want to hide the columns, here is how to hide columns in Excel.

How to Add Column in Excel

There are multiple ways to sum up the entire column or sum up only the filtered cells. Following are the ways of how to add a column in excel:

  1. Employ the SUM Function- In case you want to use the SUM function for an entire column, without applying an upper or lower bound, simply use the SUM function. The syntax for the SUM function is:

= SUM ( Number1 , Number2 , … Number280 )
In case at later stage, there is modification of data or new data is introduced in the spreadsheet, the total automatically updates to include the new data. This way you can sum the entire column.

  1. Using AutoSum- AutoSum will automatically add up the numbers and will show the total in the cell you select. Following is the process for the same
    a) Click on the first empty cell below the column you need to sum.
    b) Navigate to the Home tab, choose Editing group and click on the AutoSum button.
    How-to-add-columns-in-Excel
    c) Excel will automatically add the =SUM function and pick the range with your numbers.
    How-to-add-columns-in-Excel
    d) Press Enter to see the Sum total.
    How-to-add-columns-in-Excel

This method has an edge over the previous one as it is fast and lets you automatically get the summing result in your table. Also take a closure look at moving columns in Excel. Moving big data was never been that easy.

How to Sum only Filtered Cells

Many times, you only need to calculate the sum of visible cells, i.e. the filtered cells. Let’s have a look at the process of how to add cells in excel:

  1. Click on any cell within your data, go to the Data tab and click on the Filter icon.
    How-to-add-columns-in-Excel
  2. You will notice that arrows will appear in the column headers. Just click on the arrow next to the correct header to narrow down the data.
    How-to-add-columns-in-Excel
  3. Uncheck Select All and tick off only the value to filter by. Click OK to see the results.
    How-to-add-columns-in-Excel
  4. Select the range with the numbers to add up and click AutoSum under the Home tab.

And automatically, cells get summed up and you get the desired result.

How to Sum a Column in Excel at just a Click

In case you are short of time, and need a constructive solution that is fast and easy then this is a perfect fit for you.

Simply, click on the letter of the column with the numbers you want to sum and look at the Excel Status bar to see the total of the selected cells.
How-to-add-columns-in-Excel

However, the main drawback of this method that it does not display numeric digits.

Conversion of Data into Excel Table to Add the Column

Converting the spreadsheet to the Excel table is a great way to save time and even simplifies the calculation process. Let’s have a look at how to add a column in excel via a table:

  1. To begin with, press Ctrl + T on your keyboard to format the range of cells as Excel Table.
  2. A new Design tab pops up. Navigate to this tab and tick the checkbox Total Row.
    How-to-add-columns-in-Excel
  3. A new row will be added at the end of your table.
  4. Now, select the number in the new row and click the small down arrow next to it. Choose the Sum option from the list.
    How-to-add-columns-in-Excel

This particular method enables you to add only the filtered cells and easily displays the total of the columns you wish to calculate.

Conclusion

You can make use of any of the above ways in lieu of How to add columns in Excel, as per your requirement. Whether you need to sum the entire column in Excel or total only visible cells, make sure you choose the right method of doing the same.

Making calculations in Excel not only make your tasks simpler but is an excellent time saver too. In a simple way, it is a quick way to sum up your calculations. A lot of things can be automated with the use of Excel.

If you have hidden Columns in Excel, make sure you know to unhide them also. Here is how you can unhide the columns on Excel.

So, explore the world of Excel and you will be amazed to see how the toughest of calculations are done, with simple formulas, at just a single click.

 

A zealot author, a story teller and a Philocalist who loves to write on various topics trending on social media. She's a work in progress and a budding visual artist.

Continue Reading
Click to comment

Leave a Reply

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

iOS

How to Setup Apple Pay on iPhone?

Published

on

Apple pay is Apple's mobile payment service. In simpler words with Apple Pay, you can make payments via iPhone 6 or iPhone 6 Plus and all the latest versions.

Apple Watch owners can make payments using NFC chip built into their devices. It made its debut on 20 October 2014.

Since the day it has been launched, it has been growing at a spectacular rate. The ease and convenience that it offers are simply unmatchable.

And with all this hype around this amazing feature, a lot of iPhone users have been going gaga about how to use apple pay.

With Apple Pay, it has become much easier for you to pay for your purchases, both physical and online. All you have to do is pay for all those goods and services you have bought from the retail stores or the apparel you shopped from your favorite clothing store via your Apple iPhone.

With Apple Pay, the security of the card is given the main preference. Apple creates a “device-only account number” to operate Apple Pay. It doesn’t store your credit or debit card number and does not even give the number to companies or traders. It is known as Tokenization.

Apple Pay is presently only available in the US, UK,  China, Australia, Canada, Switzerland, France, Hong Kong, Russia, Singapore, Japan, New Zealand, and Spain. However, they are expanding and soon it will be available in other countries as well.

Let’s take a deeper look at what Apple Pay is all about and How to Setup Apple Pay on iPhone:

Setting up Apple Pay on iPhone

For all those purchases through Apple Pay, all you have to do is Set up Apple Pay on your iPhone. Once done, with just a touch of the Home button and a scan of your fingerprint, all your purchases can be made.

Before we proceed with the method, make sure to comply with the following needs in advance:

  1. You should have an iCloud account.
  2. Your iPhone needs to be running iOS 8.3 or above.
  3. You need to have a credit or debit card from any bank that supports Apple Pay. However, Apple Pay currently works with Visa, MasterCard, and American Express.
  4. A Touch ID is compulsory. So make sure your fingerprint is registered with the Touch ID feature. Even though the iPhone 5S has Touch ID, it doesn’t support Apple Pay.
  5. You should have iPhone 6 or iPhone 6 Plus. However, for in-app purchases, iPad Air 2 or iPad mini 3 can work. Apple Pay also works with Apple Watch. Basically, all those devices which contain NFC Controller support Apple Pay.

How to Setup Apple Pay on iPhone by Adding Card

Now, you need to synchronize your debit or credit card with Apple Pay to initiate purchases via Apple Pay. Take a look at the steps:

  1. Tap on the Wallet app from your Home screen.
  2. On the extreme right- hand corner, you can see a + button, tap on it.
  3. The Apple Pay screen will open up. Click on the Next button in the top right corner of your screen.
  4. Here, you can either manually input your card details or take a photo of the front of the card, i.e. scan your card details.
  5. After this, click on Next on the Card Details screen.
  6. You need to manually enter your card information. It will ask for your card's expiration date and the security code. To proceed further, click Next.
  7. You can view all the terms and conditions and tap Agree to accept the terms and conditions.
  8. Tap Agree again for final confirmation.
  9. Select your verification method, i.e. either via an email, text, or call and tap next to continue.
  10. Click on the Enter Code and now enter the verification code that has been sent to you. Click on Next.
  11. Every bank has a different procedure when it comes to the authorization of the added card. In case your bank or issuer asks for more information, you need to provide the same.
  12. As soon as your bank verifies your card, Apple Pay will start functioning. Tap Done to finish.

You can add up to eight cards on any device. Follow the same process to add more cards. So, next time you shop, just hold your iPhone near a contactless reader with your finger on Touch ID.

The wallet will be launched automatically. Your fingerprint and a small beep or vibration will confirm that you made the payment correctly.

Note- In case you experience any hindrance while adding your card, the only solution is to re-enter all the information again.

Removing a Card

It may happen that due to certain reasons you would like to remove your card. Removing a credit or debit card is comparatively simpler than adding it. Take a look at the steps:

  1. Launch the Wallet app from your Home Screen.
  2. Select the credit card that you want to delete.
  3. Scroll down to the option “Remove Card” and tap on it.

And you are done! The card will no longer be available or authorized to be used with Apple Pay on your iPhone. However, if the same card is synced with other Apple devices, you need to remove them manually on each of them.

Conclusion

Precisely speaking, Apple Pay is more or less like Paytm. Though, it may seem to be a difficult process initially, but is a venture that is completely worth it. Apple Pay anyway is more secure and convenient than a traditional card-based transaction.

Usually what you do is while making a payment by card, swipe your card, then wait for few seconds to receive authorization and when the transaction gets cleared, the shopkeeper hands over the receipt and you walk out of the store with the stuff bought.

But in actual, if we look at the backend management before your receipt gets printed, the things aren’t that straightforward.

Apple pay simplifies this task on both the entities, i.e. consumer and the company. Moreover, Apple Pay helps to reduce the associated costs to the issuing bank.

No more digging through the wallet to find credit or debit cards. With How to Setup Apple Pay on iPhone, just install Apple Pay and enjoy shopping like never before!

Continue Reading

Android

How to Unlock a Locked Phone?

Published

on

By

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

iOS

How to Turn off Voice Control on your iPhone?

Published

on

Siri is much more than Apple's virtual digital assistant. Not only, it responses to your questions with the best possible information or answers but it even helps to organize your life to a large extent. Then, there’s another side of the coin too.

From failures of understanding to difficulty with accents to annoying interrupting requests, a lot of users get annoyed with Siri. How to turn off voice over is the most frequently asked question by Apple users in such a situation.

The Voice Control framework was initially presented in iOs 3.2 on the iPhone 3GS. With time and new models, it has been superseded by Siri, a more adaptable framework that uses Apple's servers for voice handling, yet Voice Control is still in wide utilize and has its own focal points.

Voice calling seems good if you are the one who calls out a contact from your address book, but then turning off Siri has its own benefits. Apple iPhone users have always complained about the battery life of the iPhone.

So, turning off Siri prevents the battery drainage. Secondly, it prevents unnecessary actions, like sending a text that you didn’t intend to do.

In case you are having problems with the iPhone inadvertently while dialing phone numbers through Voice Control, you can deactivate the Voice Dial feature on iPhone. Let’s take a look at the ways via which you can turn off voice command Siri:

Turn off Siri's Voice to Text Only

Siri speaking can be distracting at times, or it may not always be feasible to speak to Siri. You may be in a formal meeting or at a place where you cannot converse via speaking to Siri.

In that case, resorting to text is the best option available. Take a look at how do you turn off voice control so its text only:

  1. Go to Settings > General > Siri and tap on Voice Feedback.
    How to turn off voice over
  2. In the resulting window, select Handsfree Only.
    How to turn off voice over

Everything remains the same, it’s just that whenever you ask a question, you'll get the same response as always, but only as text and without Siri's voice.

Note- Don’t start the conversation by saying “Hey Siri”, as in that case, Siri will respond by speaking. Rather initiate by double-pressing the Home button.

Disable “Hey Siri”

Apple’s personal digital assistant service, Siri works by voice alone and without the need to touch your device, in case the “Hey Siri” option is enabled.

In the older versions of iOS, all iPhone, and iPad owners can use Hey Siri only when their devices are plugged into a power connection, and those with the latest Apple devices like the iPhone 6s, iPhone 6s plus, etc. can use Hey Siri at any time, even when not plugged in.

Now in case, you are annoyed by Hey Siri requests or for whatever reasons if you want to disable Siri, you can do it via:

  1. Go to Settings > General > Siri.
  2. You will see an option Hey Siri, which is enabled by default.
  3. Just tap on it and turn it off.
    How to turn off voice over
  4. Save the changes and you are done!

Note- For the latest Apple devices like the iPhone 6s, iPhone 6s Plus, turning off Hey Siri disables the voice-only activation of the feature. Now you need to operate Siri manually.

How to Turn off Voice Over

Voiceover is a function and not an app. You can use Voiceover in most of the iOS apps like Safari, Text messaging and email, etc. By default, this option is disabled on your iPhone and iPad. Now in case you have enabled this option and want to disable it now, take a look at the steps to disable voice control:

  1. Go to Settings App.
  2. Choose General.
  3. Tap Accessibility and select Voiceover.
  4. Double-tap the Voiceover slider to turn it off.
    disable voice control

And you are done! However, there is one easier way to do this. Take a look at how to turn off voiceover:

  1. Just simply tap the Home button three times.
  2. You will hear the “Voiceover off” audio message then it will be turned off.

But many people have reported that this method doesn’t work on their iOs. So, in such a case resort to Method 1 and turn off it manually via the Settings app.

Turn off Siri via Settings

There is no denying that Siri is one of the most useful features in the Apple iPhone. But still for whatever reasons, if you want to turn it off, take a look at the process of how to disable voice control:

  1. Open the Settings app on your iPhone and click on “General.”
  2. There you will see an option “Siri.” Tap on it.
  3. Simply turn the switch “OFF.”
  4. A box pops up. Confirm that you want to disable Siri.
    how to disable voice control
  5. And that’s it! You are done.

Disable Voice Control via Passcode

You can deactivate voice control by setting a lock screen passcode and disabling voice dialing. Take a look at the steps on how to turn voice control off:

  1. Tap the “Settings” icon on the iPhone.
  2. Scroll down to the option “Passcode Lock.” Switch on the Passcode Lock.
  3. The passcode screen will appear. Type a four-digit passcode in the Passcode fields.
  4. Now, slide the “Voice Dial” switch to the “Off” position.
    how to disable voice control

Voice Control is now disabled when the phone is locked, and voice dialing is disabled, too. In crux, this will still allow Voice Control to be activated, but will not inadvertently dial any phone numbers.

Conclusion

It completely depends on the usage and preference. While some find the feature of voice control useful, others find this as a hindrance.

Voice Control can be incredible until it begins pocket dialing your contacts while you're strolling. For all those, who find this feature annoying can follow these simple steps listed above on how to turn off voice over.

However, the voice control feature is integrated into the iOs and cannot be disabled in the phone preferences. You can, however, deactivate voice control and enjoy the uninterrupted usage of your iPhone.

Continue Reading

Microsoft Office

How to Set the Default Font in Word?

Published

on

Without any doubt, fonts are one of those elements which can create a spectacular impact on the reader. So, in order to make your document super impactful, you would like to use good fonts in a document.

But how can you set your favorite font as the default one in Microsoft Word? If you are going through this query then this article has all the answers.

So, in this article, we will tell you How to set the default font in Word? After going through this article you will be capable of changing the default font in Microsoft Word. So, let's get started:

How to Set the Default Font in Word?

Step #1: In this very first step of this method, you are first required to open Word application on your system. For that, you can consider going this way. First, go to the start section and type  “Word.” After getting the relevant result, click on that and this will open the Word application for you.

changing the default font in Microsoft word

Now, after this, you are required to open any word document which has some content in it. Alternatively, you can open a blank document and enter some random text on it. Go for whatever suits you best.

Once you have done this then, you are required to look out for our next steps.

Step #2: In this step, you will have to select some part of the text so that we can select the font and then set it as the default one. So, for this, you can place the cursor and drag it till the point you want to select the text.

changing the default font in Microsoft Word

Step #3: After you have selected the text then now you are required to make a click on the “font” icon at the home tab. It looks very similar to a diagonal arrow placed in an inset.

changing the default font in Microsoft Word

Clicking on it will open a dialog box as shown below.

changing the default font in Microsoft word

Step #4: Now, click on the down arrow button at the font field. This will open a list of the available fonts.  Now, you need to select the appropriate font which you want to set as default. You can also see the preview of the font in the font section.

changing the dafault font in Microsoft word

Once you have selected the font and other fields according to your needs, then you are now required to move on to the final step.

Step #5: Now, in this final step all you need to do is to click on “Set as default.” This will open a dialog box that will ask you whether you want to set the default font for the current document only or all other documents as well.

Since you require setting the selected font as the default one so, you need to choose the checkbox next to which “All documents bases on Normal.dotm template” is written.

Just confirm your action and click on OK.

changing the default font in Microsoft word
changing the default font in Microsoft word

This will set the default font in Word. See, how easy it is.

[Additional Information]: How to add fonts in Microsoft Word?

Many times, you would find the pre available fonts in Microsoft word not appropriate for your needs. So, in that case, you would like to install other fonts. If you want to know how you can do that, then you are certainly in the right place.

In this additional section, we will walk you through all the steps that are required to add a font in Microsoft Word.

So, let's get started with the same.

Step #1: First of all, you are required to download the desired font. For this you can make a search on your favorite search engine or visit some good free fonts sites like “dafont.com” or “1001fonts.com”.

How to Set the Default Font in Word

You can visit any of those and download the fonts which suit your requirements. Once you have downloaded the font, then you can indeed proceed with the next steps to look into the proceedings.

Step #2: In the most general cases, the font will be downloaded in zipping or RAR format. So, after downloading the font in step #1, you now need to extract that font.

For this, you should have any good zip or RAR file extractor. WinRAR is one such good software to do the needful. However, if the font comes as a sole otf or ttf file then you can skip this step.

In order to extract the font, all that you need to do is to make a right-click on the downloaded folder and then select “Extract here” or “Extract files”.

The latter one will open a window to which you have to specify the path of where you want to extract the font while the former one will extract the font to the current folder.

We recommend you to extract the font at the current folder and then copy it to the desired folder of which we will be telling you in the next step.

Step #3: After you have extracted the font from its folder then you are now required to copy the font to the following location “C:\Windows\Fonts“. Now, you will have to navigate to this folder and look out for your desired font.

Been there, you now need to double click on that font in order to install it. The font will now be installed once you click on the install button.

How to Set the Default Font in Word

Step #4: Now, you will be able to see the font on your Word application. You can now set it as the default font in Word by using the method provided above (if only you wish).

Wrapping Up.

So, this wrapping up section brings us to the end of this article on “How to Set the Default Font in Word“. We hope that after going through this article, you will be able to know ” How to set and keep your preferred default font in MSC Word“.

If this article has helped you in any manner, then do not forget to share it with your peers. Additionally, if you have any other method, suggestion or query regarding this topic then do let us know through the comments section below. We would love to hear from you.

Thank you for passing by and giving it a read.

Stay tuned and keep visiting.

Continue Reading

Computers

How to Manually Update Drivers in Windows 7?

Published

on

When system peripherals create a problem, the simplest workaround we come to know while troubleshooting those errors is to learn how to manually update drivers in windows 7, and that's what we will be teaching you today!

System drivers are the set of instructions that helps your computer interact with the specific hardware associated with it. If drivers wouldn't be there, your windows wouldn't have any idea on how to deal with those hardware and your computer starts creating the problems.

When the manufacturers tweak the software associated with that particular hardware, the drivers need to get updated to its latest version available. Keeping the windows drivers up to date is a must for flawless and smooth system experiences.

If you have upgraded windows to the latest version, chances are your system audio has stopped working or the audio is not of that quality it used to be. If anything such happens, probably your sound drivers have got outdated and it's an alarm that you need to update it.

Similarly, if windows upgradations, system format or any similar activity has caused you a problem in watching videos, playing games and doing other system tasks, probably it's time for you to upgrade your windows drivers.

If you detect any such issues in your computer, learning How To Update Drivers windows 7 is the only option you are left with. This guide is dedicated to teaching you windows 7 driver updates including how to update graphics driver, driver update software and everything important.

How to Manually Update Drivers in Windows 7

There are more than one way that you can update your system drivers. You can do it by following the system updates, using the manufacturer's software and manually, of course.

This guide is compiled to teaching you how to update drivers manually in windows 7 but we will give you a quick overview of other methods too. Also, all the steps mentioned are applicable in all the above versions of windows including windows 8, 8.1, windows vista and windows 10. So let's get started.

Step 1. The process of updating the drivers starts with the device manager so the first step is to reach out to the device manager window.

To begin the process, click on the start menu and go to Control panel and click the Device Manager. See the screenshot below.

How to Manually Update Drivers in Windows 7

Alternatively, right-click My Computer and select Manage. 

How To Update Drivers windows 7

On doing that, Computer Management windows will open up. Now click Device Manager in the left pane.

How To Update Drivers windows 7

Step 2. In the device manager window, a list of all the hardware attached to your computer is given. See the below screenshot to understand the options.

How To Update Drivers windows 7

To update the driver for any hardware, double-click the hardware option and a hierarchy of the driver option will be loaded. Now double click the driver you want to update.

For instance, we want to update sound drivers for this system. Double-click the Sound, video, and game controllers and the list of audio drivers in your windows will load. Now double click driver option you want to update and another properties window for that driver will pop-up.

Have a look at the below screenshot to understand the options.

how to update graphics driver

Step 3. Now go to the Driver tab and click the Update Driver button in order to update the drivers.  

 windows 7 driver updates

Step 4. On doing that, the Update Driver Software window will pop-up. The window looks like the below screen.

 windows 7 driver updates

Alternatively, you can also reach out to this window by right-clicking the driver option and selecting Update Driver Software. 

intel graphics driver update

Step 5. In the Update Driver Software window, select the second option i.e. “Browse my computer for driver software” if you have the latest driver file downloaded on your computer.

Else, select the option Search automatically for updated driver software. When given this command, Windows will start searching for the latest driver updated for your windows on the web and you will see the following message.

nvidia driver update

Step 6. If there is an updated driver available, windows will start downloading it on your computer automatically and you will see a success message saying Windows has successfully updated your driver software. Just click the Close button and you are done.

So these are instructions for updating the drivers manually. By following these instructions you can update intel graphics driver update, sound driver, and every other driver except Nvidia driver update.

If you are using the Nvidia graphics card, here's how to update the drivers to its latest version.

Step 1. The first step is to detect the graphics card model and OS type on your computer. Once both of them are found, you can update the Nvidia driver from its official website. For this, press windows+R keys, type in dxdiag in the Run window and press enter.

Step 2. In the DirectX Diagnostic Tool, see the OS type under System Information. See the screen below.

nvidia driver update

Now go to the Display tab and check for the graphics type of your windows next to the chip type.

driver update software

Once yo have successfully found both of them, head over to the next step.

Step 3. Now go to the official website of Nvidia i.e. Nvidia.com and hover your cursor over Drivers. Fill all the details required and search for the latest driver available.

If there are any latest drivers available suiting your requirements, download it on your computer and run the installer file. The driver would be downloaded soon after.

So that's all you need to know about Howto manually update drivers in Windows 7. 

As promised above, it's time to give you a quick overview of the other two methods to update drivers in the windows.

The first method by checking for the windows updates. Type in Windows Update in the search bar and press enter. You will see the following screen.

driver update software

If there are updates available, click Install now and you are done. The third way you can do that is by going to the manufacturer's website and updating the drivers and installing them. Or you can also do that by the software CD you get from the manufacturer.

That's it for this tutorial. For any doubts or queries, you can drop us a comment below. And if you found the guide helpful, feel free to share it with your friends.

Continue Reading

Trending