7) Working with worksheet

Working with worksheet

Inserting new sheet

By default, there will be only one worksheet when you open a spreadsheet file. Incase when you need more number of sheets you can insert worksheets in two ways where one is a quick insert and other is detailed insert.

1. Quick insert:

In this quick insert, only one worksheet can be inserted at a time after the last sheet.

1. Click on the Add Sheet (Plus) icon which is seen at the bottom of the sheet on the left side .

 

This inserts a new sheet after the last sheet in the spreadsheet having a name that succeeds the previous sheet number

 

2. Detailed insert:

This gives space for inserting any number of worksheets. Also you can specify whether to insert before or after the specific sheet.

1. Select the sheet where you want to insert a new sheet, then go to Sheet→Insert Sheet in the menu bar (or) Right-click on the sheet tab where you want to insert a new sheet and select ‘Insert Sheet’ from the context menu.

2. This opens a Insert Sheet dialog where you can position the new sheet, create more than one sheet, name the new sheet, or select a sheet from a file. Select the required options and click OK.

 

For example, if you select ‘After current sheet’ and give no of sheets to be ‘4’ then four sheets gets inserted at a time.

 

In case you insert only one sheet, you can also specify the name of the sheet

 

As per the instruction, sheet with name “New sheet” is inserted before sheet 3.

 

It also gives space of inserting a worksheet from another file.

Deleting sheets

To delete a single sheet, right-click on the sheet tab you want to delete and select Delete Sheet from the context menu,

 

or go to Sheet →Delete Sheet on the main menu bar.

 

Click Yes to confirm the deletion.

 

To delete multiple sheets, select the sheets (by holding Ctrl and selecting each sheets) then follow any one of the above said method.

Renaming sheets

By default, the name for each new sheet added is Sheet X, where X is the number of the next sheet

to be added. While this works for a small spreadsheet with only a few sheets, it can become

difficult to identify sheets when a spreadsheet contains many sheets..

You can rename a sheet using one of the following methods:

• Enter the name in the ‘Name’ text box when you create the sheet using the Insert Sheet dialog
• Right-click on a sheet tab and select Rename Sheet from the context menu to replace the existing name with a different one.
• Double-click on a sheet tab to open the Rename Sheet dialog

Moving and copying sheets

You can move or copy sheets within the same spreadsheet as well as to a different spreadsheet.Moving or copying sheets within the same spreadsheet can be done by dragging and dropping or using the Move/ Copy Sheet dialog . To move or copy a sheet into a different spreadsheet, you have to use the Move/ Copy Sheet dialog.

Dragging and dropping:

To move a sheet to a different position within the same spreadsheet, click on the sheet tab and

drag it to its new position before releasing the mouse button. To copy a sheet within the same spreadsheet, hold down the Ctrl key then click on the sheet tab and drag it to its new position before releasing the mouse button.

Using Move/Copy Sheet dialog:

TheMove/Copy Sheet dialog allows you to specify exactly whether you want the sheet in the

same or a different spreadsheet, its position within the spreadsheet, the sheet name when you

move or copy the sheet.

1. In the current document, right-click on the sheet tab you wish to move or copy and select Move/ Copy Sheet from the context menu or go to Edit > Sheet > Move/Copy on the main menu bar.

2. Move/Copy sheet dialog opens up

 

3. Select Move to move the sheet or Copy to copy the sheet under the heading ‘Action’.
4. Select the spreadsheet where you want the sheet to be placed from the drop-down list under the heading ‘To document’. This can be the same spreadsheet, another spreadsheet already open, or you can create a new spreadsheet.
5. Select the position where you want to place the sheet from the list that appears under the heading ‘Insert before’.
6. Type a name in the New name text box if you want to rename the sheet when it is moved or copied. If you do not enter a name, Calc creates a default name (Sheet 1, Sheet 2, and so on).
7. Click OK to confirm the move or copy and this close the dialog.

(Note When you move or copy to another spreadsheet or a new spreadsheet, a conflict may occur with formulas linked to other sheets in the previous location).