The Perfect Guide to Learn How to Add Columns in Excel

Business Data is always prone to face minor changes based on market trends. You might require adding one or more details to your raw data or final insights. Either way, you have to add columns in excel without having to hamper the existing data.

This tutorial on “How to Add Columns in Excel” will not only help you learn the spreadsheet fundamentals but also train you to add one or more columns to your Excel spreadsheet without a hassle. 

PCP in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
PCP in Business Analysis

A column in Excel could be added by following a few simple steps below.

  • Select the column where you want to add a new blank column.

Add_Columns_In_Excel_1.

  • Here, in the image shown below, the user wants to add a new column in the position of column C. So, column C is selected. Right-click on the column to open a dialogue box and click on the “Insert” option.

Add_Columns_In_Excel_2

  • A new column will be included, as shown in the image below.

Add_Columns_In_Excel_3

Similarly, if you wish to add multiple columns to your Excel spreadsheet, it can be done by employing the similar procedure described as follows.

  • Select the columns where you wish to add multiple columns.

Add_Columns_In_Excel_4.

FREE Business Analytics With Excel Course

Start your Business Analytics Learning for FREEStart Learning
FREE Business Analytics With Excel Course

In the image below, the user has selected four columns, ranging from column C to column F. Right-click on the selected columns, and in the dialogue box, select the “Insert” option. 

  • Four new columns are added, as shown below.

Add_Columns_In_Excel_5

With this, you have reached the end of this tutorial on “How to Add Columns in Excel”.

Kick-start your career growth story with our PGP in Business Analysis. Get a chance to master Excel, Tableau, and Python tools. Start learning now!

Next Steps

Microsoft Excel is business analytics and intelligence software. Apart from that, it is also an advanced spread software. It is employed to display or share the data. In a few scenarios, Excel uses page breaks to fit data into one screen, forcing it to crop off some part of the data. To avoid this, removing breaks becomes mandatory. So, ‘How to Remove Page Break in Excel’ can be your next stop for your data analytics with the Excel learning journey. 

Are you interested in getting certified in Business Analytics? Then do visit our  Post-Graduate Program in Business Analysis from Simplilearn. It is on top among the five popular and top-ranking business analytics training and certifications in the industry. This Simplilearn program is a result-oriented training and certification program that helps you master statistics and data analytics concepts. 

Should you have questions about this “How to Add Columns in Excel?” tutorial, please feel free to write to us in the comments below. Our expert team will resolve them and will be happy to answer them earliest. 

About the Author

Ravikiran A SRavikiran A S

Ravikiran A S works with Simplilearn as a Research Analyst. He an enthusiastic geek always in the hunt to learn the latest technologies. He is proficient with Java Programming Language, Big Data, and powerful Big Data Frameworks like Apache Hadoop and Apache Spark.

View More
  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.
  • *According to Simplilearn survey conducted and subject to terms & conditions with Ernst & Young LLP (EY) as Process Advisors