This article provides you Comprehensive notes for Set up multiple sheets Class 10. This topic is explained with MS Excel and OO Calc. Here we go!!!
In electronic spreadsheet (Advanced), We have covered learning outcome 1 Analyse data using scenarios and goal seek, the contents are:
- Use consolidating data
- Create Subtotal
- Use “What if” scenarios Use “What if” tools
- Use GoalSeek and Solver
Set up multiple sheets Class 10
The file of MS Excel is known as a workbook. A workbook contains different worksheets. Observe the following screen shots:
In the above screenshots, OO Calc and MS Excel sheet tabs. The look and layout are different. OO Calc displays 3 tabs whereas MS excel displays Sheet1 by default.
The file of the spreadsheet software is known as a workbook. A workbook contains different worksheets. These spreadsheets are identified by their names.
OO Calc provides 3 worksheets by default in sheet tabs named Sheet1, Sheet2, and Sheet3. The blank space can be used to insert a new worksheet.
In the above screenshot, the bottom part of the worksheet with the title “Sheet1” is known as the sheet tab. This tab is displayed with a transparent sheet tab color. You can change this sheet tab options as and when you want to do so.
Inserting new sheets
Inserting sheet is the first learning objective in the topic Set up multiple sheets Class 10.
MS Excel provides two ways to insert new sheet in the workbook.
1. Click on + (New Sheet) icon available next to Sheet1 word.
2. Click on Home –> Insert Sheet from Cells group.
The new sheet will be inserted to the left of the current sheet with Sheet2 name. Look at the following screen:
Inserting new worksheet in OO Calc is quite easy stuff. Follow the given steps:
- Click on Insert –> Sheet option. The Insert Sheet dialog box will appear.
- Select the place where you want to insert the worksheet either before the current sheet or after the current sheet. or Click on empty space available in the sheet tab after last worksheet.
- Select the sheet options like New Sheet, No. of Sheets, Name of the sheet, or Chose from file option as per your need.
- Click on the OK button. Observe the following screenshot.
The next topic is rename worksheet for the Set up multiple sheets Class 10.
Rename worksheet – Set up multiple sheets Class 10
Rename worksheet option allows changing the name of worksheets as per user’s need in place of sheet1, sheet2, etc. It adds more customization flexibility to handle data easily.
To rename the worksheet follow these steps:
Step 1: Select the worksheet to rename with double click on sheet name.
Step 2: Right click on it and choose Rename worksheet option.
Or Click Home –> Format –> Rename sheet from cells group.
Step 3: Now type the desired new name for your sheet and press enter.
You can rename worksheet by double click and with right click like MS Excel. and another way is given below:
Click on Format –> Sheet –> Rename. and Type the new desired name for the spreadsheet.
Changing the sheet tab color – Set up multiple sheets Class 10
Sheet tab color is used to make the sheet tabs colorful and more attractive. To do this follow these steps in MS Excel:
Step 1: Select the sheet from sheet tab to change the sheet tab.
Step 2: Right click on Sheet tab and Choose Tab Color à Desired Color. Observe the following screen shot:
Or click on Home –> Format –> Tab Color –> Desired Color from cells group. Observe this screenshot.
Steps to change sheet tab color in OO Calc:
Right-click on a particular sheet and choose the Tab color option and pick a desired color from the dialog box.
Click on Format –> Sheet –> Tab color and pick a desired color from the dialog box.
Let’s discuss the next topic from Set up multiple sheets Class 10 i.e. delete a worksheet.
Delete the worksheet
Whenever a worksheet(s) is/are not required for the work, you can delete it/them.
Follow these steps to delete the worksheet:
Step 1: Select the worksheet you want to delete.
Step 2: Right click on sheet tab and choose delete option.
Or click on Home –> Delete –> Delete Sheets option from cells group.
Right click on a particular sheet to delete. Select delete option.
Click on Edit –> Sheet –> Delete option.
If you want to delete multiple sheets, select multiple sheets.
Move or Copy worksheet – Set up multiple sheets Class 10
Move or copy the worksheet is last topic for the learning outcome Set up multiple sheets Class 10.
Sometimes we need to move the worksheet data from one sheet to another sheet. If the same date is required in multiple sheets, you can copy the worksheet. You can copy or move worksheet in similar workbook or another workbook as well.
To move/copy a worksheet follow these steps:
Step 1: Select the sheet to move or copy.
Step 2: Right click on sheet name and choose Move or copy option.
Or click on click on Home → Format → Move or Copy sheet from cells group.
Step 3: Move or copy dialog box opens as displayed in the following screen shot.
Select desired option as given in below screenshot:
Step 4: Click on the OK button finally to place your worksheet at the selected destination.
Right-click on a sheet in the sheet tab and choose the location for the selected worksheet. The selected sheet will be shifted or moved to the particular location.
Move or copy worksheet option is available in Edit menu in OO Calc.
Download the notes in pdf file by unlocking following:
If you have any doubt in the article Set up multiple sheets Class 10 feel free to ask in comment.
Provide your valuable suggestions for the improvements.
Thank you for reading this article.