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.
- Select the heading of the row where you want to insert a new row.
- Click Insert-Insert Row.
Insert Column
Perform the following to insert a column into the column where is selected.
- Select the heading of the column where you want to insert a new column.
- Click Insert-Insert Column.
Insert Sheet
Perform the following to insert a sheet.
- Click Insert-Insert Sheet.
- Click and drag the last sheet that is just created to the location where you want to place on the sheet tab.
- 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
Menu | Shortcuts | Description |
---|---|---|
Insert Row | - | Insert a row into the location where is selected. |
Insert Column | - | Insert a column into the location where is selected. |
Insert Sheet | Shift+F11 | Insert a sheet where you want to. |
Note
You can delete, rename, or hide sheets using the context menus that appear when you right click on a sheet tab.