Summing up, subtracting, and manipulation of data is best performed in Microsoft excel program. If you have ever been using MS excel you must be knowing that apart from creating data sheets, result sheet, MS excel is also used to add, subtract, divide and almost all the mathematical task can be performed in MS Excel.
If you don't know how to add in excel, how to sum a column in excel, and how to total a column in excel, then this guide is probably going to solve all your queries today. If you are interested in finding the average in Excel, you can check that too.
If you have a huge amount of data in a column that you want to add, you can easily do that in excel. Here is the guide telling to steps to follow for adding the columns in excel.
Adding values (summing) is an integral part of Microsoft excel program. No matter whether you adding data to any cell, subtotaling data, or making any sheet by summing some running data, excel provides multiple ways that can be used to some data.
To make things done easy, this article provides you the comprehensive guide on how to add numbers in excel. As I said above MS excel provides various ways to sum up data and we will see some of the best ways and most useful excel sum formula here.
How to Add in Excel
In order to learn how to add on excel, you will need to know sum formula in excel. Until you are aware of these formulas, adding data in excel would not seem very easy to you.
In this article, we have provided you with the best formula for summing up the data. Let's head over to it and see how we can add data in excel. Below we have shared the list of formulas which you can use to add values to the data. Here goes the list of formula:
#1: Basic Addition:
This is the most yet useful formula everyone prefers using. To summing up the data all you will need to do is typing an equation into a cell, such as 5+5.
But wait, even though, you have put the query of adding the numbers, isn't the excel smart enough to proceed to that query??? It is!! Confused?? Let me explain.
When you put any query to the excel like if you want two numbers to be added you will need to specify the query with the symbol “=”. If you don't do this and put the query like 5+5, excel will consider those as digits what you have put in the sale and will interpret the symbols there as a label, not as a formula.
So in order to let excel know you want to perform an action, you will need to mention the symbol “=” before the digits and then press Enter. To get it better check out the below screenshot.
#2: Adding By Address
This is another way to sum up the data in the Microsoft excel program. In this method, you will need to mention the address of the cell you want the addition of.
To do so, you will need to enter one cell whether it is row or column and the other one just after the previous cell. Put the symbol + in between both the cell. Again remember, start the formula just by preceding them with an equal sign. See the screenshot.
#3: Adding Columns
Let's try out another example. Imagine if you have a list of numbers placed in a column and you want the sum of all the numbers. In such a situation, what would you do? Well, it's again pretty easy.
There are two methods you can try to sum up the column numbers. One we have already discussed above i.e by putting the cell numbers. This is pretty easy and useful if you have a short list of the numbers.
Yes, if you have a limited number, then typing out the cell names manually could be easy but, if the list is longer then this task seem to be very difficult. So in such case, you will need to try another method which I have described below.
To add any series of cells that are contiguous. All you will need to do is put all the data in a series and use the excel function sum(). In the enclosure, you will need to put the address of the first cell, a colon, and then the address of the last cell. Or, just click and drag the whole column down and it will automatically add the values. See Screenshot
Once you are done filling the cell numbers press Enter.
As you can see in the image, all the data between the first cell to the last cell, including everything in between have been added. This method is mostly used when the list of the data is higher.
#4: Adding manually by shortcuts:
Last but not the least. This is the last method to summing up the data. If you don't remember any formula, or have no idea about the cell or in case if the list is too large to check the first cell and the last cell then you can add the data manually by dragging the cells.
Let me explain it briefly! If you have put the digits in the excel cells and want to add them up, select that cell and the address will be added automatically. Now you will need to put the column after the cell is selected and then select the last cell by clicking on it. Make sure you don't use any space between the first cell, colon, and the last cell. Now simply press enter and you would see the result right there.
This is one of the most used methods. Even I prefer using this since you don't have to enter any cell number, any data or any other formality is required.
So this is how we can easily add up the data in MS Excel. These were the most useful and easy to use methods that are used for calculating the data, adding up the digits and creating the result sheets. Excel can also be used to calculate other mathematical problems. You can also divide in excel. Along with that, you can represent numerical data in an impressive way by creating charts on Excel.
I hope after following the complete guide you don't have any doubt regarding the how to add in excel. If you liked the article do share it on the social media platforms!!
How to Get Kik For PC
The last few years have seen a tremendous increase in the number of smartphone users. As a smartphone user, you know how important it is to have good communication apps to interact with others!
But, sometimes we don't get a chance to check our phones while we are working on our computers. What can be done if you get an urgent message during that time? It might be impossible to reply.
That’s why we need to convert our PCs to smartphones sometimes. (The irony is that we are working hard to make our smartphones more like computers).
If you are a Kik messenger user and want to use it on your PC also, you are reading the right stuff. This is a guide to get Kik for PC.
How to Get Kik for PC?
Messengers are a weakness for smartphone users. There are many like WhatsApp, Hike, BBM, WeChat, etc. Today, I am talking about Kik messenger.
The company was started in 2008. But they launched the app only after two years. It got fabulous acceptance from people all over the world.
Kik messenger got downloaded a million times within the first 15 days. In this post, I will be sharing a method to use the app on a PC also.
Before knowing that, do check out these prerequisites.
Requirements to Get Kik for PC
- At least 2 GB RAM. (The performance will be awesome if you have 4 GB or more).
- The processor clocked at 1.5 GHz or above.
If you are sure that your computer has these requirements, proceed further to read on.
Method to Download Kik for PC
Step 1: The very first thing we need is an Android emulator to get Kik for PC. Don’t worry if are unaware of the term. We are going to download one such tool.
Click here to download the BlueStacks Android emulator.
Step 2: Open the downloaded executable file. You will see an installation wizard.
Step 3: Follow all the steps to complete the installation. It may take a few minutes to complete the process. You will be asked to do something after the installation also. Do it.
Step 4: Now, you can see a Bluestacks icon on the desktop. If you don’t see it, don’t panic. The software is already on your system. So open Windows Explorer and search for Blustacks.
You will get one application. Open it.
Step 5: You will see a window like an image given below. You can see many options there along with the names of some recommended and popular apps.
Move your mouse pointer to the top left portion and click on the magnifying glass icon with an orange background.
Step 6: Another empty window will be opened which is the search page. The suggestions will be displayed when you type something. Type Kik in that field to get Kik for PC.
Step 7: Then click Search on Play store, so that Bluestacks can find the app on Google’s app marketplace.
Step 8: The results will not confuse you because only one is exact. Click on Kik (the result) to get you to the download page.
Step 9: Whoa!! This screen (see image) is very familiar to you, isn’t it? It is very similar to an app download page on the play store. Click on Install.
Step 10: The Kik messenger is 14 Mb in size. So, you have to wait sometime. The waiting time may vary according to the speed of your internet connection. When it is over, click on Open.
That’s all. Now, you have got Kik Messenger on your PC. When you want, use the app, open Bluestacks and then, Kik messenger.
The interface of the app is very similar as you see on a smartphone. The only difference is in the screen size.
N.B.: Bluestacks is not the only Android emulator. There are many like Droid4x, GenyMotion, and Andyroid. The working is the same as we see in Blustacks.
What the emulators do is creating an Android platform that can run on personal computers. The functions may vary from software to software. But the working principle is the same.
Haven’t You Downloaded Kik for PC Yet?
Kik is one of the widely used messengers for Android. If you check the Google Play Store Page, you will get an idea of its popularity.
It offers an unbreakable safety barrier by utilizing username instead of the phone number for identification, unlike WhatsApp. And, you can send unlimited memes, gifs and funny pics provided by the app itself.
So, the chances are great that you will feel the necessity of Kik for PC. That’s why I have come up with this post. If you feel any difficulties in installing Bluestacks or running Kik for PC inside it, won’t hesitate to let me know your issue via comment.
I will be more than happy to help you out. After successfully installing Kik for PC, share this trick with your friends on social media. For other similar tricks to get WhatsApp on your PC read this article!
How To Remove Write Protection From SD Card?
When using a newly bought SD card, we often confront the term write protection, isn't it??
Imagine the scenario when you just bought an SD card for your phone or computer to backup your data and to increase the storage capacity of your phone! You insert it into your computer via the card reader, copied your fav music and images from the computer and tried to paste it into the SD card and heck, what you see is the following error message.
If your SD card is write-protected, you can't copy your data into it, can't delete its data and can't use it the way it is meant to be! If an SD card doesn't allow you to write your data on it, then what's the point of buying an SD card??
Well, write protection in SD cards is not permanent and neither it is designed to annoy you! In fact, it is a very useful feature of SD cards and helps us protect our data from being overwritten.
We won't go in-depth about what this feature is designed for! In fact, we are here to teach you just the opposite of that. The purpose of today's guide is to teach you How to remove write protection from SD card, and that's what we will guide you through!
Removing write protection from SD cards is extremely easy, and there are multiple methods to do that. Let's figure out what are they!
How To Remove Write Protection From SD Card:
There are more than one way to remove write protection on an SD card. Let's see what are the different methods.
#Removing Write Protection From the card Itself:
Most of the new SD cards now come with a lock on it to remove and apply for write protection. Using this notch to remove the write-protection from an SD card is the easiest way you can do that. Here's how to do that.
Step 1. Take the SD card in your hand facing the label up and try to find the lock button. It's a little slider kinda button on the top left of your SD card. You can take the idea of the lock button from the image below.
Step 2. When the lock button is located, slide it to the upper direction to unlock your card for lock protection. Simple enough, isn't it?? Let's check out the second method for doing the same.
#By Formatting the Card:
If your card doesn't have a lock button, no worries. You can still unlock your SD card and remove write protection from it by simply formatting it. Wondering How to Format A Write-protected SD Card??? Check out the steps below.
Step 1. The first step is to insert your SD card to your Windows computer. You can do that by inserting the SD card into the card reader or using the card adapter. Or you can also use the USB for the same.
Step 2. When the card is connected to the computer, click on the start menu and move your cursor to my computer. Now right-click on it and select the option Manage. See the below screenshot to locate the option more easily.
Step 3. On clicking the Manage option, a new Computer Management window will pop-up which looks like the below image.
Now you need to double click the options Storage in the left pane and select Disk Management.
Step 4. As sooner you click on the Disk Management, Windows will load the list of storage devices you are currently using on your computer. One of these options will be the SD card connected to your computer.
Right-click on it and select Format.
Step 5. Once you click Format, a new format window will pop-up. You don't need to do anything here, just click Ok and your SD card would be formatted. Have a look at the screenshot below to see how the format window looks like.
And needless to say, when the format is complete, your SD card would be free from write-protection.
#From the Diskpart Utility:
The next method in the list is using the Diskpart utility of windows. Try this method when the above method doesn't work. To make your windows free from write-protection using this method, follow the steps below.
Step 1. Click on the start menu, type in CMD in the search bar and type in CMD there. Right-click on the first search result and select Run as Administrator.
Step 2. When the command prompt is open, you need to run the following commands one by one. First, start with Diskpart. Write Dispart in the command prompt and press enter.
Step 3. When done, type again the command list disk and press enter. When done, move ahead to the next step.
Step 4. Now type in Select disk x, this is the SD card which is supposed to be free from write-protection. When done, press enter.
Step 5. After the above command, you need to run the attributes disk clear read-only. This is the last command we need to run. When you are done doing that, type exit and press enter and come out of the command prompt.
Now check your SD card to see if it has become write-protection free.
#From the System Registry:
The fourth method to remove write protection from an SD card is in the system registry. Let's check out how to erase a write-protected SD card using the system registry. Here's what to do.
- Open the Run window by pressing the windows+R key.
- Now type in Regedit in the search field and press enter.
- In the Registry Editor, follow the path HKEY_LOCAL_MACHINE/SYSTEM/CurrentConrolSet/Control/StorageDevicePoi. Doing that will lead you to the option write protection in the right pane.
- click write protection and set its value to 0.
And the write protection from your SD card would be removed. Now you can use it normally for storing different photos, videos and whatever you would like to. When the card is full, you can keep it safe by putting the write protection again.
If you have even more queries or doubts on how to remove write protection from the sd card, drop us the comment below.
How to Extend Wifi Range?
In this technology epoch, every next person is using WIFI. As you are here today, I can understand how used to you are of WIFI.
Nothing is more annoying and irritating than a slow internet connection. Slow Wifi not only discomfit, but also reduces the workability and creativity.
So in order to enhance our workability and efficiency, it is more than essential for every wifi user to learn How to extend wifi range. No matter how fast our wifi runs, we always try new things to extend wifi signal strength.
If you are also one of those who are struggling with wifi speed and want to increase it, then reading out our guide on how to increase wifi signal can be a life-changer for you.
How to Extend Wifi Range
Certainly, there are various ways available which we can use to increase the wifi signals. But all of the tricks are not always working one. So in order to let you know the best working tips that will help you to boost your wifi signal I have come up with this article.
Let's figure out what are those working tactics that can do revelation and help you to increase your wifi signals.
1. Find the Right Spot for Your Router:
This is the most useful and easy to follow a tip that can help you with increasing wifi signals. In order to increase the wifi speed consider placing it in the right place. Now a question might have stricken through your brain is what place? Let me tell you, Your router should be always kept in the front.
No matter how ugly our router look, it should never be kept behind anything. Always try to keep the router out in the open. Keeping the router behind the TV or wall can reduce the strength of the signals.
2. Find the Right Wireless Channel
In order to avoid conflicting with other router's channel, always keep your router at the place where other's router doesn't get interfering with yours. The interference of signals can cause the signal to degrade.
To find out the right channel for the router you can consider tools like Wi-Fi Stumbler or Wi-Fi Analyzer.
3. Control Bandwidth-Hogging Applications
Watching out videos, movies, playing large games or using services such as Netflix can also be a reason to slow down the signal strength. So to extend the wifi signals you can use something called QoS. QoS stands for Quality of Service.
With QoS, you can prioritize some useful applications such as video chat over some less important applications like video games. So that the most important applications get the bandwidth they deserve.
4. Set Your Router to Reboot
Setting up the router to reboot on schedule can also help you to increase the signal strength. Sometimes due to overuses of the router, excess of downloading, old firmware can cause the slow wifi signals. So to avoid it, make sure you timely reboot the router.
You can also run tests to make sure the problem isn’t caused by overuses of router or heat.
5. Password Protect the Network:
Wifi or home network's speed is most often dependent on the number of devices used. Your network will go slow down if there are too many people using the same wifi connection. So to avoid this to happen, keep your network password protected.
Once you will keep a password on the network it will ensure that the only authentic people are using your network. And also, make sure you don't put the password simple, use a unique combination of keys. Simple passwords are easy to guess!
6. Buy a Repeater:
Most of the routers have a range of about 150 feet. So it becomes problematic when you live in a big house. If you are away from the router, computers and devices can take a hard time to connect. In such cases, wifi repeater can work well for you.
This is the easiest fix to boost the signals. The repeater can be plugged into any wall outlet and will increase a signal's range and strength to the farthest parts of your home. This is the best wifi extender which gives the wireless signal booster.
7. Extend Your Router’s Signal With Hacking
This is another trick that can help you boost your wifi signal. However, this trick has some disadvantages as well but that can be overcome easily.
To increase the Wifi signal, hack your router and install the DD-WRT firmware. This is one of the good ways to boost wifi signals. This way you won't only be able to increase the signal strength but will give you a ton of great security features and other enhancements.
8. Keep your Router Away From Appliances And Metal Objects:
Keeping router near appliances like Microwaves, fluorescent lights, etc can interfere with your Wi-Fi signal. Even the other routers in other apartments or neighbor's home can also interfere with your wifi signal.
So to avoid this interference, try placing your router away from household appliances and set it to another frequency and wireless channel.
Apart from the above-mentioned points, you can also install a wireless amplifier. Wifi signal amplifier is also known as a booster. This can be directly attached to your router.
The booster can be more affordable than a repeater as it increases the strength of your existing signal.
After following the above tactics, I am sure you will realize, your Wi-Fi is faster, secure and more reliable than ever before. If it happens do let us know by dropping a comment in the comment section.
So this was all about How to extend the wifi range. I am quite sure you will find this article useful since all the tactics I have shared are almost working one.
Follow all the mentioned tricks and enjoy your extended wifi signals. If you liked and enjoyed the article, you can share that on your social media platforms. If you face any difficulty or have any confusion drop that in the comment section. We will try to reach out to you as soon as possible.
How to Download and Install Photoshop on Windows?
Do you want to know how to download and install Photoshop on Windows?
If you are ready to spend some bucks, this will not trouble you. But the problem arises when you want to install Photoshop free.
Don’t worry! I have got you covered.
In this tutorial, I am going to walk you through the entire steps needed to download the setup file of Photoshop for free. Once you do it, you can easily proceed to the installation by opening the downloaded file.
So, are you ready to dive into the core of this article? Here you go!
How to Download and Install Photoshop on Windows?
Before you proceed to install the software, I want you to ensure your system specifications. The following are the requirements to run Photoshop on a computer.
System Requirements for Photoshop
- The PC users should have at least the following series of processors or later.
Intel Centrino, Xeon, Xeon Dual, Pentium III or a Pentium 4.
- You must be a Windows XP or Windows 2000 user. For the former class of users, Service Pack 4 is needed. When it comes to the latter class, you should have Service Pack 1 or 2.
- Every user needs at least 384 MB of RAM.
- The free space on your hard disk must be greater than 650 MB.
- There is a necessity of at least a 16-bit video card.
- Photoshop works well on a monitor with a resolution of 1024 by 768.
- Adobe also states that you need a CD drive to install the software from a CD or DVD, which in this case is not needed.
Now that you have read the specification requirements for your Windows computer, it’s time to know how to download Photoshop for free full version.
How to Download Photoshop for Free?
I have given below the complete steps needed to download and install Photoshop for free. You can follow them to proceed further.
Step 1: First, you have to open your web browser. It is completely up to your choice whether to go with which one. Nonetheless, my favorite choice is Google Chrome. You can use Mozilla Firefox or Microsoft Edge as well.
Step 2: Once you open the browser, enter adobe.com into the address bar. You can see a Sign in button on the top-right portion of the screen. On the next screen, you will get a link to Get an Adobe ID.
Do you think there is too much to do?
Don’t worry! Just click on the link given right below to reach directly access to the Signup page.
Finally, hit that yellow button to finish the process of signing up.
Step 4: On finishing the signup process, you will get access to their download page. Bear in mind that having an Adobe ID doesn’t grant you free access to the latest Photoshop version. Instead what we get here is Adobe Photoshop CS6.
N.B.- CS6 may not have all the features of the latest version. Still, it serves the purpose of graphic designing and, a lot of people around the globe are using the same version.
You have to find the download link for Photoshop CS6. Press Ctrl+ F simultaneously to get a search field using which you can find Photoshop CS6.
Most probably, you will get two links right to the name. As you want to know how to download Photoshop free, you need to choose the second link.
Click on the second link that says Free Trial. You may have to choose a destination. Hit Enter after doing so.
If you wanted to access all the features without any time limit, you have to buy the license key from Adobe. Once you got the key, you have enter that while installing.
Step 5: Access the directory into which the executable file is downloaded. Then, open the same to kick-start the installation.
First, you have to choose the location to install the software. Then, they will show you a license agreement. On agreeing to it, you can move on to the next step.
Here, they want you to enter a username, organization name (not mandatory) and serial number. You already have the last one copied from the download page.
Now, you need to hit Next on a few screens and after that, you will get the Install button. Hit the same and wait a few minutes to get it finished. You can trace the improvement in the installation in real-time with the help of the progress bar given on the window.
Finally, click on Finish to exit the installer.
Step 6: Most probably, you will get a shortcut to the software on the desktop. Use it to launch Photoshop CS6. For the first time, you will be shown a registration form where you have to enter a few basic details to get product updates and support.
You can skip the registration or do it right away.
Once you do it either way, you will be brought to the magic world of Photoshop.
Also Read:- How to Photoshop Pictures?
Hope you know how to download and install Photoshop on Windows now.
We won’t recommend you use any crack or patches. The steps in the process given here are completely legit and the product key is supplied to you from Adobe itself.
I am not sure of the duration of the link and serial key you can avail from the official website. So don’t hesitate to rush to the spot and, get a copy for yourself.
Don’t forget to share this article with your social media friends and followers. They will thank you later for doing so.
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.
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!!
How to Get Kik For PC
How to Find the Mode?
How to Turn Off Cellular Data for Specific Apps on Android?
How to Reset Macbook Air?
How to Receive Money through PayPal?
How to Make a Yahoo Account Without a Phone Number?
Computers1 month ago
How to Reset Macbook Air?
Tech2 years ago
How to Receive Money through PayPal?
Tech2 years ago
How to Make a Yahoo Account Without a Phone Number?
Tutorials2 years ago
How To Enable/Disable Chrome Pop Up Blocker
Tech2 years ago
How to Tame a Horse in Minecraft?
iOS2 years ago
How to Stream Torrents on iPhone?
Mac1 year ago
How to Use Apple Thunderbolt Display with PC?
Mac2 years ago
How to Install GIMP for Mac