Insert columns or rows

Product: MyOffice Professional, MyOffice Standard, MyOffice Education

Application: Spreadsheet Desktop version

Insert columns

To quickly insert one column, follow these steps:

1.Select a cell or a column to the left or to the right of which you want to add a new column.

2.Insert a column in one of the following ways:

•In the Table menu, select Insert Column to the Left or Insert Column to the Right.

•On the Toolbar, select the Cells section and click editor_insert_column_icon Insert Column to the Left or editor_insert_column_right_icon Insert Column to the Right.

•Right-click the selected cell or heading of the selected column and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert column to the left, press Alt+L. To insert column to the right, press Alt+R.

To add several columns, perform the following actions:

1.Select the number of columns and cells horizontally equal to the number of columns to be inserted.

2.Insert the columns in one of the following ways:

•In the Table menu, select Insert Column to the Left or Insert Column to the Right.

•On the Toolbar, select the Cells section and click editor_insert_column_icon Insert Column to the Left or editor_insert_column_right_icon Insert Column to the Right.

•Right-click anywhere on the selected range and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert columns to the left, press Alt+L. To insert columns to the right, press Alt+R.

To double the number of columns on the sheet, do the following:

1.Select any entire row on the sheet.

2.Insert columns in one of the following ways:

•Right-click the column heading area and select the Insert Column to the Left or Insert Column to the Right command from the context menu.

•To insert columns to the left, press Alt+L. To insert columns to the right, press Alt+R.

Insert rows

To quickly add one row, follow these steps:

1.Select a cell or row to the left or right of which you want to add a new row.

2.Insert a row in one of the ways:

•In the Table menu, select Insert Row Above or Insert Row Below.

•On the Toolbar, select the Cells section and click the editor_insert_row_icon Insert Row Above or editor_insert_row_below_icon Insert Row Below.

•Right-click anywhere on the selected range and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Alt+A. To insert rows below, press Alt+B.

To add several rows, do the following:

1.Select the number of rows and cells vertically equal to the number of rows to be inserted.

2.Insert rows in one of the ways:

•In the Table menu, select Insert Row Above or Insert Row Below.

•On the Toolbar, select the Cells section and click editor_insert_row_icon Insert Row Above or editor_insert_row_below_icon Insert Row Below.

•Right-click anywhere on the selected range and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Alt+A. To insert rows below, press Alt+B.

To double the number of rows on the sheet, proceed with the following:

1.Select any entire column on the sheet.

2.Insert rows in one of the ways:

•Right-click the row heading area and select the Insert Row Above or Insert Row Below command from the context menu.

•To insert rows above, press Alt+A. To insert rows below, press Alt+B.

Was this helpful?

Yes