Tips and Trick: 3 Ways to Add Columns in Excel

AppsTips and Trick: 3 Ways to Add Columns in Excel

Toper.me – One of the requirements when working using Microsoft Excel is to add a column between the existing columns. You fill it with data.

You may need to add a column because you forgot to add data.

For example, you have written a number of data in the cells in columns A to D, then you intend to add one more column between A and B.

Well, is this possible to do?

Adding a column Microsoft Excel can be done very easily, you can even do it in several ways.

Then how to insert a column in Excel?

1. Add a column via the Insert Column menu

You can add a column via the Insert Column menu provided by Excel.

As quoted from the page Microsoft, here’s how to add columns in Excel as follows:

  • Select the Excel cell where you want to add the column
  • Then click “Home” then “Insert” then “Insert Sheet Columns”

Then a new column will appear on the left side of the selected cell.

2. Add column using keyboard shortcut

Meanwhile, quoted from page Makeusof, you can also add columns by pressing the keyboard shortcut.

The way to insert an Excel column in this way is as follows:

  • Select the cell next to which the column will be added
  • Press the “Ctrl” +”Shift”+”+”, Then automatically a new column will be formed faster.

3. Add a column by right-clicking

The next way to add a column is to right-click with your mouse. The way to add a column by right-clicking is as follows:

  • The way to add a column by right-clicking is as follows:
  • Select the cell next to which the column will be added
  • Next right clicks on the cell
  • Click “OK”

Here are three ways to add columns in Excel that you might need when you’re working with an Excel worksheet.

Popular

Other Articles