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 *

Android

How to Delete Snapchat Account

Published

on

How to delete snapchat account

Alike various social networks, Snapchat is also a social networking app of its kind. The app was created long back and has not lost its popularity even after the introduction of various other similar apps.

Originally, Snapchat was a multimedia messaging app that lets you share videos with other Snapchat users (texts, drawings and pics sharing facility was added later). These shared files as basically known as “Snaps.”

The biggest upside of using Snapchat is that the files that you share cannot be downloaded on the other end. Also, the snaps are self-destructive – meaning that they destroy themselves once the recipient sees them, or after the desired time as decided by the sender.

Even if you are a Snapchat user and have no plan to learn how to delete the Snapchat account, you should consider learning how to delete a Snapchat account as you may find the information handy in the future.

Also, it is better to delete your Snapchat account instead of leaving it inactive. The reason for doing so is discussed below.

#1. How to Delete Snapchat Account – Using App

Step 1: Launch the official Snapchat application on your smartphone be it Android based on iOs based. In case you do not have the app on your device, simply download the Snapchat application from play store or iTunes, it’s fully free.
Step 2: As soon as you launch the app, the first impression will be of the login screen demanding your registered username and password. Enter the correct details to log in. In case, you have forgotten your password, and then you can recover it by implying the steps mentioned above.

In case, you have more than one or multiple Snap chat accounts, and then you are supposed to have different username and password for each one them. Enter the login details of the account which you wish to delete.

Step 3: After you have successfully logged in with the concerned username and password, you need to open the “Settings” panel in your Snapchat app. The settings options are usually found in the top-right corner of your smartphone's screen.

Step 4: Now navigate to the “support” option in the menu that appears subsequently.

Step 5: Among the numerous options that appear the as-as result of tapping on the support option, go with the “learning the basics” options for further.

Going with the – learning the basics option may appear to be a bit distinct. However, one needs to select this option to continue with the further process.

Steps 5: Once you enter the learning the basics screen, navigate to “Account Settings” options which will be a major step in deleting your Snapchat account.

Step 6: Ultimately, in the account settings menu you will be able to see the option namely – “Delete an account” Tap on deleting my account to continue the future course of action.

Note: we strongly recommend you to give a second thought to the decision of deleting your Snapchat account. As once deleted, the action cannot be reversed nor can the account be recovered.

Step 7: At last, you will be asked to enter your password once again in the text field as a method of confirmation. Also, you may be asked to enter the password more than once.

#2. How to Delete a Snapchat Account – Using Link

Step 1: Open this link in the browser of your PC or laptop or even your mobile! Although this link is supposed to work with major Android browser.

It is always recommended to use a PC or laptop for a better experience. Also, for iPhone and iPod users, Safari browser would be a great option.

Step 2: The link that opens is not a much fancy link. However, it is proven as the fastest method to delete a Snapchat account.

This step is much like one of the above-mentioned steps. In the webpage that appears, insert the concerned username and password of the Snapchat account that you wish to delete.

Step 3: Subsequently, you will be asked once more to enter the password as a step towards confirmation. Simply enter the same password that you had entered in the previous step.

Step 4: Finally, you will be able to see the “Delete my account” option right on your screen (desktop).

Step 5: Proceed with clicking on the delete my account option to delete your Snapchat account via PC or Laptop.

Notes

Follow the following steps to make sure whether your Snapchat account has been deleted or not:

Step 1: Open the Snapchat app on your smartphone or the official website on your PC or Laptop.

Step 2: This step is to be followed with great attention. Now, enter username and password of the Snapchat account that you had attempted to delete with the help of above-mentioned steps.

Step 3: Subsequently, you will observer either of the two results:

  • You will be logged in to your Snapchat account, or
  • You will not be logged into your previously existing Snapchat account.

In case you observe the first option i.e. you are logged in to your Snapchat account, try following the above-mentioned steps once more to successfully execute the deletion process.

Also, it is recommended to wait for some time before you go with:

  • Verification of whether your account has been deleted or not; and
  • Retrying with the process of deleting your Snapchat account.

Final Words

We often find people inquiring about – How do you delete a Snapchat account. So this was all about how to delete a Snapchat account yourself using a link as well as a PC or a laptop.

It is often seen that many people, if they do not want to continue using any account, just make it inactive and do not delete.

The reasons can be numerous – either they do not have sufficient resources to learn How do I delete my Snapchat account, or they are lazy enough to learn how to delete a Snapchat.

However, it is always recommended to delete an account if you do not wish to use it as it may be used by anyone to perform some unethical stuff that can actually cause you troubles.

Want to enhance your browsing experience? Learn how to enable cookies on a Mac

Continue Reading

Tech

How to Host a Web server From Home PC for Your Website

Published

on

Here is trick or you can say a tutorial on How To Host a Web server from Home PC.

Turn your PC  into a web server and share files like documents, pictures and many other things with the people you want, or just Host a Website From Home via converting that simple home PC into a complete web server. 

So lets us learn, but before doing the thing, we will see is converting that home PC into a web server is it worth? well, let's find out.

Why you should learn how to host a webserver:

Learning how to host a web server from Home PC can be okay, but is it really required. Here are some legit reasons you should consider turning your home PC into a webserver.

  • If you have some files on that computer that are important for your work, you could access these files from anywhere provided you have an internet connection.
  • If you have some files to share with your friends or relatives, so rather uploading these files on other sites, you could just convert the PC into a web server.
  • This is the strongest point, you want to host a web server for your website and using things like FTP, DNS, etc is too hard for you. So just set up a local web server at your home, within seconds and host your website without spending any buck. So you can Host a Web server from Home with this tweak.

These were some of the reasons you consider this tutorial of How to Host a web server from Home PC, important and well as interesting as it could save you some extra bucks, as you could just host a website from home without any hard work.

Let's Begin (Host your Website from Home):

This is a very simple trick, even dummies could do it, in just a couple of minutes. But before learning How to host a web server, you should download this tool Opera Unit.

And also install it on the PC you want to make web server off. And you are done. You are now running a web server from home to host your website at your home, or rather for other functions I mentioned above.

You just need to configure some files and folders, you are willing to share with others over the internet, via your hosted web server.

Now start the Opera Browser and just enable the Opera Unite service from the lower left corner of the window.

Now click on the File Sharing link and select which folder you are willing to share via your hosted web server from home. Now any file or folder within this folder will be shared on your configured web server.

You can use any public URL or rather set a password if you are not willing to share those files with the public.

The advantage of this tool is that it does not download or upload any of your files, it will just make it access gateway through your machine.

This was a tutorial on how to host a web server from home PC for your website and hence host a website from home. Hope you liked it.

Continue Reading

iPhone

How to Recover Deleted Photos from Your iPhone

Published

on

Well, being a big fan of iOS over Android, I just love the devices manufactured by Apple.inc. I am also an iPhone user so whenever I have some free time I just keep searching for useful iPhone and iOS tricks.

I just learnt a really helpful trick, which will help you recover all your deleted pics on your iPhone.

This comes in really very handy when you have to transfer some important things through your friends iPhone to yours using Bluetooth, but your device's memory is full.

So in such a situation you can delete the pics in your iPhone and transfer the data and then recover the pics back once easily using this trick.

This trick will also help you if you tend to delete the pics accidentally. So as iPhone doesn't come with a trash bin where the deleted pics are sent, you need to learn this trick in order to restore them.

Follow these steps:-

1. Firstly download and install the software named iPhone Data Recovery. You can easily download this software from HERE

2. Once you have installed the software successfully, open up the software in your pc.

3. Now connect your iPhone to your pc

4. Once it shows that your iPhone is successfully connected, just enter the DFU mode

5. Once you enter the DFU mode (it may take up several minutes to enter the DFU mode after clicking), it takes time as it will scan your complete phone data and show up all the folder on the screen.

6. As the scan completes you can easily see all the deleted photos and can select the ones you need to recover.

7. After you have selected the photos that you want to recover, simply click on the RECOVER button on the left corner.

8. Now disconnect your phone and open gallery, you will notice that the photos that you selected would have been recovered.

The software being used is completely safe, I have personally used it and can assure you that it will not add any kind of spyware or viruses to your system. I have seen that most of the users are a bit reluctant for using any kind of third-party software for such tricks.

However such tricks without a third-party software won't be possible because iOS is a closed source software, so it is not that easy to make a change to the system files, well such things can be done without software in Android as its an open source software.

Continue Reading

Tech

How To Run Whatsapp On The Computer?

Published

on

whatsapp-on-the-computer

WhatsApp needs no prior introduction. It's so far the most used and the most popular instant messaging application, for mobile operating system's out there.

What makes WhatsApp so popular is the fact that it's a cross-platform messaging application, and that you don't need to create any specific account, in order to use WhatsApp.

 All you need is the mobile phone numbers of you and your friends.

The only limitation or disadvantage, that could be pointed out of WhatsApp was that it has no desktop software or desktop client. Hence, you need a Smartphone with WhatsApp support in order to use the application.

Well, that would no more be a barrier :D. Because now you can use WhatsApp on the computer. Even though there is no official WhatsApp Desktop-App, you can use WhatsApp on the computer with the help of third-party software called “BlueStacks“.

Bluesharks is not an exclusive WhatsApp Client for Windows. You can run any Android application on Windows computers using the BlueShacks software.

Today, we are here with a small tutorial on how to install and use WhatsApp on the computer using the Bluestacks software.

Minimum System Requirements For Installing Bluestacks Software:

To run the Bluestacks software on your computer, there are some minimum system requirements. Like:

  • You need administrator access to your computer.
  • Your computer must be running at least Windows XP Service Pack 3.
  • Your computer must have at least .Net framework 2.0
  • Your computer must have at least 2 GB of RAM.
  • Your computer must have a C: Drive as the default storage location.
  • You need a compatible VGA.

If your computer meets the minimum system requirements to install the Bluestacks software, then below is how you can install the software and run WhatsApp on the computer.

How To Install Bluestacks And Run WhatsApp On The Computer?

Below is the detailed tutorial on how to install bluestacks and run WhatsApp on the computer:

  • Download the bluestacks software installer for your computer from here.
  • After you download the bluestacks software installer, run the installer.
  • When you begin the installation process, set and enable all app store settings.
  • After installing the bluestacks software, visit their official site [the site from where you downloaded the installer] and upgrade it completely.
  • After you have finished the installation, launch the application from your desktop.
  • From the main home screen of the Bluestacks software, you'll see a Search bar.
  • Click on the search bar, and type in “WhatsApp” as the search query.
  • Now click on the install button, to install WhatsApp Messenger to your computer.
  • Before beginning the installation process, you'll need to login to your Google Account. Log in with your credentials. If you don't have a Google Account, you'll need to create one.
  • After the installation of the WhatsApp Messenger ends, launch the WhatsApp application.
  • As usual, you'll need to agree with their Terms and Policies and then you'll need to enter your mobile number with country code [ ex: +91].
  • After entering your mobile number, WhatsApp will now send an automated message to your mobile number with a verification code.
  • Enter that verification code to the WhatsApp application on your computer, and you're done!

Now to add new contacts to your WhatsApp application on the computer, you'll need to add the mobile number of your contact with his/her country code. You can perform any usual tasks using the WhatsApp on the computer.

I hope you found this simple tutorial helpful. If you have any doubts or suggestions, please leave it as a comment below! 🙂

Continue Reading

Android

How To Setup Google Chromecast On Your Television?

Published

on

setup-google-chromecast

The “Breakfast With Sundar Pichai” Google event that happened a few days back, gave us some great new releases.

Namely the new Nexus 7 Android tablet, Android 4.3 Jelly Bean and the Google Chromecast. We were already expecting the release of the next generation Nexus 7 and the Android 4.3 Jelly Bean announcement.

However, the announcement of the Google Chrome cast dongle was by surprise.

And indeed, it received a great amount of positive response from people around the globe. And within just a few hours of the announcement, many online stores went out of stock for supplying the Google Chromecast Dongle.

And this itself shows, how positively the new dongle was welcomed by users.

The Google Chromecast Dongle is a simple USB Device, that can turn any TV into a Smart TV [if it has a HDMI/USB port]. By using the Google Chromecast Dongle, you can play and stream any video from your YouTube or Netflix account directly to your Television, without having any cables or any other devices hanging around, just using the Google Chromecast Dongle.

If you've recently purchased the Google Chromecast Dongle and if you are in need of some online tutorial on how to start using this Google Chromecast Dongle, then here we are to help you out.

Today, we're here with a detailed tutorial on how to install and start using this Google Chromecast.

How Does The Google Chromecast Function?

Before we go through the setup process of the Google Chromecast, we should know that how does this dongle function.

Well, the Google Chromecast dongle is WIFI enabled. Hence during the setup process, you'll need to connect it to your WIFI network, to enjoy its functionality.

After you connect your Google Chromecast using your WIFI network, anyone who uses the same WIFI connection can stream their content directly through your Television.

So anyone using a Chromecast supported application can stream their content through your Television, provided that they're connected to the same WIFI network as your Chromecast dongle.

You can stream videos from YouTube, Netflix or even using the Chrome extension.

And using the chrome extension, you can even browse the web through your television and perform any apparent online task. As the API for the Google Chromecast is available for developers, you can see more and more applications with Google Chromecast support, in the near future.

What Do You Get With Your Google Chromecast Package?

Once you receive your Google Chromecast Package, below are the things that you can find inside your package box:

  • The Chromecast HDMI Dongle.
  • A USB Power adaptor.
  • An external adapter plug.

As you might have noticed, you also receive an external USB power cable, other than your Google Chromecast Dongle. Its because the Chromecast dongle has an HDMI power port, and some televisions do not have an electric-powered HDMI port.

Which means, these HDMI ports won't be able to power the dongle.  In such cases, you can use the external electric power adaptor that's included, to run the Google Chromecast dongle.

But, if you have an electric powered HDMI port on your television, you can plug in the dongle directly, without the need of an external power adaptor.

How To Setup Google Chromecast On Your Television?

Now let's move on to the setup process. Actually, setting up your Google Chromecast Dongle is a very easy task and can be performed under 5 minutes!

Yet if you're confused on how to set up Google Chromecast on your Television, then below is the detailed tutorial on how to set up Google Chromecast on your Television:

  • First of all, connect the Google Chromecast Dongle to your Television. You can refer to the above section to know how to do so.
  • Now, most probably your Television must have automatically detected the Google Chromecast. Else, change the HDMI input from your Television manually.
  • And now, you need to follow through the on-screen instructions.
  • During the setup process, first, you'll be asked to name your Chromecast dongle. This name must be chosen while streaming the content to your Television.
  • And then, you'll be prompted to connect the Chromecast dongle to your home WIFI network. You'll need to connect your Smartphone or any other devices to the same WIFI network as your Chromecast dongle, in order to stream the content.
  • And finally, complete up your setup process and you're good to go!

Again, the streaming speed will depend on your internet connection speed.

Continue Reading

Trending