15. Excel How to add columns ?


Inserting empty columns in a worksheet

To insert a column into a worksheet:

  • Select a cell to the left of which the column will be added. That is, if you want the column to be added between columns C and D, then select one or more cells in column D.
  • Use the Insert command in the Cells group on the Home tab and choose Insert Sheet Columns.

Excel 2016 Insert Sheet Columns Button

To insert several columns at once :

  • Select a cell range with as many columns as you want to add. That is, if you want to insert 4 columns for example, just select 4 cells horizontally.
  • Use the Insert command in the Cells group on the Home tab and choose Insert Sheet Columns.

Inserting copied or cut columns

We use the insertion of columns copied from another sheet or workbook. We also use this technique to change the order of columns within a sheet. To do this :

  • Select the column(s) you want to copy
  • Use the Copy or Cut buttons in the Clipboard group on the Home tab of the Ribbon

Excel 2016 Copy or Cut buttons

  • Select the column to the left of which the copied column(s) will be added.
  • Use the Insert command in the Cells group on the Home tab and choose Insert Copied Cells.

Excel 2016 Insert Copied Cells button


<< 14. Excel How to add a secondary axis ?

16. Excel How to add times ? >>