Move Or Copy Rows And Columns. In order for a sheet to appear in the Select a sheet window both you and the owner of the source sheet must have Owner- or Admin-level sharing permissions to the destination sheet. This will copy row 1 and insert it into row 5 shifting the existing rows down.
You must copy or move the entire row or column. In order for a sheet to appear in the Select a sheet window both you and the owner of the source sheet must have Owner- or Admin-level sharing permissions to the destination sheet. If you copy or move a row or column you can paste it only in the same grid.
To move a column left or right tap on the column header and choose Move column leftright from the dropdown menu.
Click on the edge with left mouse button while still holding the shift key. To add a blank column anywhere in a plan select the column next to where you wish to have a new column tap on the column header. If you copy or move a row or column you can paste it only in the same grid. Excel cannot insert the sheets into the destination workbook because it contains fewer rows and columns that the source workbook.