Tutorial Playlist

Excel Tutorial

Overview

Your One-Stop Solution to Know About Excel Worksheets

Lesson - 1

Your One-Stop Solution For Excel UserForms

Lesson - 2

The Best Guide on How to Send an Email in Excel

Lesson - 3

Your One-Stop Solution That Will Help You Learn How to Convert PDF to Excel

Lesson - 4

A One-Stop Solution for Acing the Excel MIS Report

Lesson - 5

All You Need to Know About Barcode in Excel

Lesson - 6

Your One-Stop Solution to Learn Mail-Merge in Excel and Its Implementation

Lesson - 7

A Comprehensive Guide on Excel Flash Fill

Lesson - 8

Slicers in Excel: The Ultimate Guide to Help You Design and Develop Excel Slicers

Lesson - 9

One-Stop Solution to Learn Everything About Excel Budget Template

Lesson - 10

All You Need to Learn About Match Function in Excel and Its Real-Time Implementation

Lesson - 11

Everything You Need to Learn on How to Create a Pivot Table From Multiple Sheets

Lesson - 12

The Major Fundamentals About XLookUp in Excel Along With Practical Examples

Lesson - 13

The Ultimate Guide to Learn How to Compare Two Columns in Excel

Lesson - 14

The Best Guide and Your One-Stop Solution to Master the Fill Series in Excel

Lesson - 15

What Is the DATE Function in Excel and How to Implement It?

Lesson - 16

Your One-Stop Solution to Designing and Implementing Hyperlinks in Excel

Lesson - 17

One-Stop Solution to Master Everything You Need to Know About Auto-Sum in Excel

Lesson - 18

DAX in Excel: The Complete Guide for DAX Functions and Formulas in Excel

Lesson - 19

A Perfect Guide for All You Need to Know About Data Formatting in Excel

Lesson - 20

The Perfect Guide to Learn How to Add Columns in Excel

Lesson - 21
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. 

Post Graduate Program in Business Analysis

In partnership with Purdue UniversityVIEW COURSE
Post Graduate Program 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.