How to delete, add columns in Excel
When working with Excel tables, there are many basic operations that users need to understand to handle tables faster and more fluently. Adding columns or deleting columns in Excel is one of the basic operations that every beginner will practice. After creating an Excel table, you need to create a new Excel column, or delete an Excel column with unnecessary data, instead of hiding the column in Excel. The following article will guide you how to delete and add columns in Excel 2007, 2010, 2013, 2016, 2019. In general, the operation will be the same as deleting and adding columns in Excel 2003.
1. Instructions to add Excel columns
Method 1:
Click on the current column position and right click, select Insert . With the addition of a column in Excel, the new default column will always be left with the column that is clicking.
How to delete, add columns in Excel Picture 1
Immediately a new column E was displayed on the left hand side of the original column F that was clicked. The original mouse column will push to the right.
How to delete, add columns in Excel Picture 2
Method 2:
In any cell in a column that users want to add a new column to the left, press the right button and select Insert .
How to delete, add columns in Excel Picture 3
Display a new dialog box with various options, we click on Entire Column to insert a column in Excel. And the result also shows a new left column at the mouse column click.
Note that if you want to add more than 1 Excel column, you need to select 2 existing columns or highlight 2 cells of 2 adjacent columns to add 2 new columns on the left, with the same method.
How to delete, add columns in Excel Picture 4
2. How to delete columns in Excel
To delete any column in Excel, we select the column and right-click , then click Delete to delete the Excel column is finished. Or, click the column and then press Ctrl + - to delete the Excel column.
How to delete, add columns in Excel Picture 5
You should read it
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Steps to lock columns in Excel
- MS Excel 2007 - Lesson 5: Edit Worksheet
- Complete tutorial of Excel 2016 (Part 6): Change the size of columns, rows and cells
- Instructions for separating column content in Excel
- How to number columns automatically in Excel
- How to black out rows or columns in Excel with keyboard shortcuts
- How to keep Excel and Excel columns fixed?
- The way to color alternating columns in Excel is extremely simple
- 2 ways to separate column Full and Name in Excel
- How to change the position of columns in Excel
- How to combine 2 columns Full name in Excel does not lose content