Easy Shortcut: How to Add a Column in Excel

July 21, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

Excel is one of the greatest data analysis and storage programmes available. You may generate millions of columns and rows, as well as automate a wide range of tasks. Excel, for example, is ideal for keeping track of personnel schedules or student grades. One column might be used to indicate a person's surname or another category.So, what happens if you need to add another category to an Excel table that has already been prepared?

Fortunately, creating a new column in Excel is a simple and quick procedure. There are two methods for adding columns, and we'll walk you through them both.

In Excel, columns are used to organise data and are frequently used as categories with headers to sort cells. To create a new column just before an existing one, simply right-click on it. To add additional columns, click Insert after selecting the required number of columns. You may also insert cells from your spreadsheet's Home tab.

Here's how to add columns.

By right-clicking on a cell in Excel, you may create a column online 2016 and 2019. Here's how

1.Open WPS Office on your windows or Mac.

2. Choose the column to the right of the one where you want to add a new one. (Excel will place the new column in front of the old one.) By clicking on the letter name at the top of a column, you may select the entire column.

3. Right click in the column anywhere and then click insert from the menu. 

4.The column of cells just preceding the one you clicked on will now be empty. You may now start entering data.

How to insert multiple columns in excel

1. To add several columns, select the same number of columns to be added. If you want to add two new columns, for example, highlight two existing columns.

2. Select any of the highlighted columns with a right-click.

3. Select Insert from the drop-down menu. Excel will add the same number of columns as you choose.

Using the Home tab in Excel, how to create a column

1. Open WPS Office on your windows or Mac.

2. You may also utilise a feature in the Home tab instead of right-clicking. The first choice at the very top of the spreadsheet is this tab.

3. Navigate to the right hand side of the Home page after selecting the required number of columns.

4. To quickly insert the columns, click Insert, or click the arrow to show a drop-down menu. You may then manually pick Insert Sheet Columns from the drop-down menu. (If you've picked rows instead, you may also insert rows.)

Note: This was an attempt to show you how to add column in excel online, 2016 and 2019 on both Windows and Mac. You can have access to WPS Premium, once you download the WPS Office. If you follow all of these instructions, you can easily learn how to add columns in excel.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.