View source for Documentation/AOO4 User Guides/Getting Started/Getting Started with Calc/Working with Sheets

{{DISPLAYTITLE:Working with Sheets}}
{{Documentation/GSCalc4TOC
|ShowPrevNext=block
|PrevPage=Documentation/AOO4_User_Guides/Getting Started/Getting Started with Calc/Working with Columns and Rows
|NextPage=Documentation/AOO4 User Guides/Getting Started/Getting Started with Calc/Viewing Calc
}}__NOTOC__

== Working with Sheets ==

Like any other Calc element, sheets can be inserted, deleted, and renamed.

=== Inserting New Sheets ===

There are several ways to insert a new sheet. The first step for all the methods is to select the sheets that the new sheet will be inserted next to. Then any of the following options can be used.

* Choose {{menu|Insert|Sheet}} from the menu bar.

* Right-click on the sheet tab and choose '''Insert Sheet'''.
* Click in an empty space at the end of the line of sheet tabs.

[[Image:AOO41GS05_019.png|none|center]]
<center>''Figure 75. Creating a new sheet''</center>

Each method will open the Insert Sheet dialog (Figure 76). Here you can select whether the new sheet is to go before or after the selected sheet and how many sheets you want to insert. If you are inserting only one sheet, there is the opportunity to give the sheet a name.

[[Image:AOO41GS05_020.png|400px|]]
<center>''Figure 76. Insert Sheet dialog''</center>

=== Moving and Copying Sheets ===
You can move or copy sheets within the same spreadsheet by using either the mouse (drag and drop) or a dialog. Drag and drop does not work if you wish to move or copy a sheet to a different spreadsheet; instead, you need to use the dialog.

==== Using the Mouse ====
To ''move'' a sheet to a different position within the same spreadsheet, click on the sheet tab and drag it left or right. Two little triangles indicate where the sheet will be dropped (see Figure 77). The mouse pointer (not shown in the illustration) may change to include an indicator; the indicator symbol varies with your operating system.

[[Image:AOO41GS05_021.png|400px|center|]]
<center>''Figure 77: Dragging a sheet to move it''</center>

To ''copy'' a sheet within the same spreadsheet, hold down the {{key|Ctrl}} key ({{key|Option}} key on Mac) while you click on the sheet tab and drag it. The mouse pointer may change to include a plus sign or other indicator; the symbol varies with your operating system.

==== Using a dialog ====
The Move/Copy dialog provides the opportunity to specify exactly where you want the sheet to go (in the same or a different document), at the same time as moving or copying occurs.

{{Note| When moving or copying sheets between different spreadsheets, be sure that both documents are open.}}

Follow these steps:

# In the current document, right-click on the sheet tab you wish to move or copy.
# Select '''Move/Copy Sheet''' from the context menu.
# On the Move/Copy Sheet dialog (Figure 78):

* 
** Select or deselect the '''Copy''' option at the bottom.
** '''To document''': select the document in which you want to place the sheet. By default, the field will show the current document. If you have another spreadsheet open, its name will appear in the drop-down list along with—new document—.'''Insert before:''' select the position within the target document.

# When you are done, click {{button|OK}}.

[[Image:AOO41GS05_022.png|400px|center]]
<center>''Figure 78: Move/Copy Sheet dialog''</center>

{{Warn| If you choose—new document—as the location, a new spreadsheet will be created. This may cause conflicts with formulas linked to other sheets in the previous location. If you accidentally move a sheet, you can fix it by moving or copying the sheet back to the original location.

This caution also applies to moving sheets to other existing documents.}}

=== Deleting Sheets can be Deleted Individually or in Groups. ===

'''Single sheet'''

Right-click on the tab of the sheet you want to delete and choose '''Delete Sheet''' from the pop-up menu, or choose {{menu|Edit|Sheet|Delete}} from the menu bar.

'''Multiple sheets'''

To delete multiple sheets, select them as described earlier, then either right-click over one of the tabs and select '''Delete Sheet''' from the pop-up menu, or choose {{menu|Edit|Sheet|Delete}} from the menu bar.

=== Renaming Sheets ===

The default name for a new sheet is ''SheetX'', where ''X'' is a number. While this works for a small spreadsheet with only a few sheets, it becomes awkward when there are many sheets.

To give a sheet a more meaningful name, you can:

* Enter the name in the Name box when you create the sheet, or
* Right-click on a sheet tab and choose '''Rename Sheet''' from the pop-up menu; replace the existing name with a better one.
* Double-click on a sheet tab to pop up the Rename Sheet dialog.

{{Note| Sheet names must start with either a letter or a number. Apart from the first character of the sheet name, allowed characters are letters, numbers, spaces, and the underline character. Attempting to rename a sheet with an invalid name will produce an error message.}}

{{CCBY}}
[[Category:Getting Started (Documentation)]]