Quickest Excel column creation methods you shouldn’t miss

Creating a column is a fairly simple task in Excel. You can create a column at any desired position. Follow this article to learn how to do it quickly and easily!

0
158

1. Shortcut to quickly add columns

Step 1: First, on the Excel toolbar, select the letter of the column where you want to insert a new column. Alternatively, you can press the combination Ctrl + Space to select all columns.

Press the combination Ctrl + Space

Step 2: Press the Ctrl + Shift + “+” shortcut.

Press the Ctrl + Shift + “+” shortcut

Step 3: The new column is inserted as shown below, where column B is the newly inserted column.

Quickest ways to create columns in Excel

Similarly, when you select 2 or more columns and press the Ctrl + Shift + “+” shortcut, the number of inserted columns will be equal to the number of columns selected.

2. Inserting columns using Insert

Step 1: At any cell, click on the letter of the column where you want to insert a new column.

On the fixed alphabet toolbar in Excel, click on the letter where you want to insert a column at that position.

Click on the letter where you want to insert a column

Step 2: Right-click on the selected column and choose Insert. You have completed the column insert operation in the spreadsheet.

Choose Insert

To insert multiple columns at once, perform the following steps:

Step 1: Select the columns where you want to insert new columns at that position.

Quickest ways to create columns in Excel

Step 2: Right-click and choose Insert to insert columns. The column insert operation is now complete.

Choose Insert to insert columns

3. Inserting columns at different positions

Step 1: Similar to the above instructions, you can select non-consecutive columns where you want to insert new columns right in front of those columns.

Note: To select multiple non-consecutive columns, hold down the Ctrl key and click on the positions where you want to insert additional columns.

Quickest ways to create columns in Excel

Step 2: Right-click on the selected column and choose Insert to insert.

Right-click and choose Insert to insert columns

Step 3: The new columns will be added to the table. Columns B and E are the 2 newly added columns.

Quickest ways to create columns in Excel

4. Inserting columns in an Excel Table

An Excel table, or Excel table, is a named object that allows you to manage data inside the table independently of the rest of the data in Excel.

In this method of inserting columns, there are two cases as follows:

Case 1: Inserting 1 column at a column that is not the last column of the table.

Step 1: Click on the header cell in the column where you want to insert a new column.

Click on the header cell

Step 2: Right-click on the selected header cell and select Insert. The new column will be inserted to the left in this case, so you should choose Table Columns to the Left.

Choose Table Columns to the Left

Step 3: The new column will be inserted into the table with the default column name being Column1.

Quickest ways to create columns in Excel

Case 2: Inserting 1 column at the last column of the table.

Step 1: Click on the header cell in the last column of the table.

Click on the header cell

Step 2: Right-click on the header cell and select Insert.

In this case:

  • If you want to insert 1 column to the right of that column: Select Table Columns to the Right.
  • If you want to insert 1 column to the left of that column: Select Table Columns to the Left.
Quickest ways to create columns in Excel

Step 3: The new column will be inserted into the table with the default column name being Column1.

Quickest ways to create columns in Excel

5. Quick column deletion

Step 1: Click on the column you want to delete by clicking on the default character cell on the Excel toolbar.

Quickest ways to create columns in Excel

Step 2: Go to Home on the toolbar or press the Delete key, in the Editing section, click Clear and select Clear All to complete the delete operation.

Quickest ways to create columns in Excel

Where:

  • Clear All: Delete all data you selected.
  • Clear Format: Delete the format of all cells you selected to the default format of Excel.
  • Clear Content: Delete the content within the selected column cells.
  • Clear Comment: Delete the comment in the column cell.
  • Clear Hyperlinks: Delete existing hyperlinks in the column.

Conclusion

Excel calculated columns are a great tool for entering calculation formulas and effectively presenting data. They allow you to enter a single formula in a cell, and the formula will automatically expand to the rest of the columns. When using columns in Excel, you don’t have to use the Fill or Copy commands. This can save a lot of time, especially when you have many rows. And the same thing happens when you change the formula; and the calculated data area will also expand to the rest of the calculated columns.

An affordable computer will be a tool to help you improve your learning and work efficiency. Visit FPT Shop to refer and choose the most suitable products for yourself.

You may also like

Troubleshooting Tips for When Microsoft Excel Doesn’t Allow Column Insertion

Having trouble inserting columns in Excel? FPT Shop is here to help! This article will show you solutions and methods for getting your insert column command to work.

The Quickest Way for Word Newbies to Delete a Column

It is common for people to look for ways to delete columns or cells in Word when working with tables. Although it may seem like a simple task, not everyone is familiar with it, especially those who are new to Word.

Simple and Quick Guide to Deleting Columns in Excel

Deleting columns in Excel is a useful technique for removing empty and unnecessary columns from your data table. If you’re looking for a step-by-step guide on how to delete columns in Excel, then look no further. Here is a detailed tutorial to help you with the process.