Page 257 - open office
P. 257
Renaming Sheets
The existing worksheet can also be renamed. To rename a sheet:
Step 1: Double-click on the specified sheet from the Sheet tab or right-click on it and select the Rename
Sheet’ option. The ‘Rename Sheet’ sub-window appears.
Step 2: Type a new name for the sheet.
Step 3: Click on the OK button. The selected sheet will be renamed with the new name.
Sheet Tabs Before Sheet Tabs A er
Renaming Sheet Renaming Sheet
1
2 3
Moving Sheet
By the ‘Moving sheet’ option, a worksheet can be moved to a different order of sequence as required. To
move a sheet:
Step 1: Right-click on the sheet to be moved.
Step 2: Click on the option ‘Move/Copy Sheet’. Select the sheet before/after which the selected sheet is to
be placed.
Step 3: Select the desired position and click on OK .
Step 4: Click on the ‘Copy’ checkbox to create a duplicate copy of the sheet.
4
Hide / Unhide Sheet
User can hide worksheet(s) of a workbook that can be displayed later. To hide a worksheet:
Step 1: Select the sheet(s) to be hidden.
Step 2: Select the option Sheet from the Format menu. Click on the Hide option.
Step 3: Click on the OK button.
Working with Spreadsheet 25

