Moving and copying spreadsheets
You can move sheets within a notebook or between notebooks to reorder them, using the mouse to drag the spreadsheet tab to another location. In the same way, you can also copy spreadsheets within a notebook.
To move a spreadsheet |
1.
|
|
Click the tab of the spreadsheet you want to move.
|
2.
|
|
Drag the spreadsheet tab in any direction until a sheet icon appears.
|
3.
|
|
Move the sheet icon by dragging right or left along the row of tabs.
|
4.
|
|
Release the mouse button when the sheet icon is where you want to place the spreadsheet.
|
•
|
|
You can also move a spreadsheet by clicking Edit Move Sheets, and specifying the sheets to move.
|
To copy a spreadsheet |
1.
|
|
Hold down Ctrl and click the tab of the spreadsheet you want to copy.
|
2.
|
|
Drag the spreadsheet tab in any direction until a sheet icon appears.
|
3.
|
|
Move the sheet icon by dragging right or left along the row of tabs.
|
4.
|
|
Release the mouse button when the sheet icon is where you want to place the spreadsheet.
|
•
|
|
You can also copy a spreadsheet by clicking Edit Select all, and then clicking Edit Copy.
|