Adding and deleting spreadsheets
You can add or delete single or multiple spreadsheets to or from your notebook.
To insert a spreadsheet |  |
|
1.
|
|
Click the tab of the spreadsheet you want to follow the new spreadsheet.
|
|
2.
|
|
Click Insert
 Insert sheet. |
To insert multiple spreadsheets | |
|
1.
|
|
Click Insert
Insert cells. |
|
2.
|
|
Enable the Sheets option in the Dimension area.
|
|
3.
|
|
Enable the Entire option in the Span area.
|
|
4.
|
|
Type a 3D selection in the Cells field.
|
|
For example, to insert three sheets before spreadsheet B, enter B:A3..D:A3 (it does not matter which cell you reference).
|
To delete a spreadsheet | |
|
1.
|
|
Click a spreadsheet tab.
|
|
2.
|
|
Click Edit
Delete cells. |
|
3.
|
|
Enable the Sheets option.
|
|
4.
|
|
Enable the Entire option.
|
|
•
|
|
You can also delete a spreadsheet by right-clicking a spreadsheet tab, and clicking Delete sheet.
|
To delete multiple spreadsheets | |
|
1.
|
|
Click the first spreadsheet tab.
|
|
2.
|
|
Hold down Shift while you click the last spreadsheet tab to delete.
|
|
A black line appears under the tabs.
|
|
3.
|
|
Click Edit
Delete cells. |
|
4.
|
|
Enable the Sheets option.
|
|
5.
|
|
Enable the Entire option.
|