Page 181 - CA 165 ver 1.0 Class 9
P. 181
Step 2: Finally the entire point Should appear as shown below.
Step 3: ‘Rename Sheet’ sub-window appears. Give a new name to the sheet and click on the ‘OK’
button. The selected sheet will be renamed with the new name.
Sheet Tabs Before Sheet Tabs After
Renaming Sheet Renaming Sheet
Moving Sheet
By ‘Move Sheet’ option, a worksheet can be reordered in a new sequence, as desired. To move a sheet,
follow these steps:
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 ‘Copy’ checkbox to create a duplicate copy of the sheet.
4
Hide/Unhide Sheet
User can hide worksheet(s) of a workbook which can be displayed later. To hide a worksheet, follow
these steps:
Step 1: Select the sheet(s) to be hidden.
Step 2: Select the option ‘Sheet’ from the ‘Format’ menu. Click on the ‘Hide’ option.
Working with Spreadsheet 179

