How to Add Columns in Excel. Once you understand whether it’s Rows, columns, cells, and ranges in excel Next we’ll try to work by using rows and columns in excel.
This time we will try to add columns and delete columns in excel.
Adding these columns and rows has a role when we work with a single piece of data. Next, we will slip new data on that data or vice versa we can delete columns and rows of data when we do not need it.
How to Add columns in Excel
Excel 2007 and later
How to Easily Select the cell where you want to add columns in Excel. To add a column to column ‘C’, select cell C1 or another cell in column C.
In the Home tab in the Ribbon menu, click Enter and select Slip Column Sheet. You can right-click the selected cell, select Enter, and then select All options columns.
Guide
If you want to add multiple excel columns, highlight more than one column, and then click Enter and select Slip Column Sheet. Suppose, if you’re going to add four rows to column C, highlight column C.
Next, highlight an additional three columns to the right, by clicking and dragging on the letters C, D, E, and F.
In the other step, with column C in the highlight, hold down Shift and click column title F. Then click Enter and select Slip Column Sheet.
Excel 2003 and the old
Select the cell where you want to add columns in Excel. To add a column in column ‘C’, select cell C1 or another cell in column C.
In the menu bar, click Enter and select Columns. This option does not exist when you highlight rows instead of columns.
Guide
If you want to add multiple columns at once, highlight more than one column, click Enter and select Columns. Suppose, if you’re going to add four rows to column C, highlight column C.
Next, highlight an additional three columns to the right, by clicking and dragging on the letters C, D, E, and F. In the other step, with column C in the highlight, hold down Shift and click column title F. Then click Enter and select Columns.
How to Delete columns in Excel
Excel 2007 and later
Highlight the excel column or column that you want to delete. then in the Home tab in the Ribbon menu, then click Delete and select Delete Column Sheet. You can right-click with your mouse on the highlighted column and select Delete.
Using some of the steps above, delete or shift columns from the right to the left. When you want to delete the contents of the column, press the Delete key on the keyboard.
Excel 2003 and the old
Highlight the excel column or column that you want to delete. Then in the menu bar, click Change and select Delete. You can right-click with your mouse on the highlighted column and select Delete.
Using some of the steps above, delete or shift columns from the right to the left. After that, if you want to delete the contents of the column, press the Delete key on the keyboard.
