Insert Row, Column and Sheet

You can insert rows and columns. You can also insert sheets and change there names.

Insert Row

Perform the following to insert a row into the row where is selected.

1. Select the heading of the row where you want to insert a new row.
2. Click Insert-Insert Row.

Insert Column

Perform the following to insert a column into the column where is selected.

1. Select the heading of the column where you want to insert a new column.
2. Click Insert-Insert Column.

Insert Sheet

Perform the following to insert a sheet.

1. Click Insert-Insert Sheet.
2. Click and drag the last sheet that is just created to the location where you want to place on the sheet tab.
3. Right click on the new sheet and click the Rename Sheet on the context menu and then change the sheet name.

More Information

Submenu of Insert Row, Column, and Sheet

Note

You can delete, rename, or hide sheets using the context menus that appear when you right click on a sheet tab.