GW_E3_F/502/0168_SS_BASICS_L4

• Computing ICT
• Further Education (Key Stage 5)

Working with Multiple Worksheets

Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.

What are you going to learn?

In this lesson you're going to learn how to . . .

1

2

3

Insert, Copy, delete and rename a worksheet

Move and change 

the Colour of a 

Worksheet tab

Group and ungroup 

Worksheet

00:37

How Many Worksheets does Excel provide on initial startup

1. 1
2. 4
3. 3
4. 2

02:14

Can you Copy and Move Worksheet Tabs

1. True
2. False

Insert a New Work Sheet

Locate and select the New sheet button near the bottom-right corner of the Excel window.

1

A new blank worksheet will appear.

2

By default, any new workbook you create in Excel will contain one worksheet, called Sheet1. To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook.xt

To Copy A Work Sheet

If you need to duplicate the content of one worksheet to another, Excel allows you to copy an existing worksheet.

Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.

1

1. The Move or Copy dialog box will appear. Choose where the sheet will appear in the Before sheet: field. In our example, we'll choose (move to end) to place the worksheet to the right of the existing worksheet.
2. Check the box next to Create a copy, then click OK.

2

The worksheet will be copied. It will have the same title as the original worksheet, as well as a version number. In our example, we copied the November worksheet, so our new worksheet is named November (2). All content from the November worksheet has also been copied to the new worksheet.

3

To rename a worksheet:

Right-click the worksheet you want to rename, then select Rename from the worksheet menu.

1

Release the mouse. The worksheet will be moved.

2

You can also copy a worksheet to an entirely different workbook. You can select any workbook that is currently open from the To book: drop-down menu.

To move a worksheet:

Right-click the worksheet you want to rename, then select Rename from the worksheet menu.

1

Release the mouse. The worksheet will be moved.

2

                   To change the worksheet tab colour

1. Right-click the desired worksheet tab, and hover the mouse over Tab Color. The Color menu will appear.
2. Select the desired color.
3. The worksheet tab color will be changed.

1

The worksheet tab colour will be changed.

2

The worksheet tab color is considerably less noticeable when the worksheet is selected. Select another worksheet to see how the color will appear when the worksheet is not selected.

3

                   To Delete a Worksheet

Right-click the worksheet you want to delete, then select Delete from the worksheet menu.

1

The worksheet is deleted

2

If you want to prevent specific worksheets from being edited or deleted, you can protect them by right-clicking the desired worksheet and selecting Protect Sheet from the worksheet menu.

To insert A new Worksheet

Locate and Select New Sheet Button

Locate and select the New sheet button near the bottom-right corner of the Excel window.

1

Right-click the worksheet you want to copy

Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.

Right-click the worksheet you want to rename

Right-click the worksheet you want to rename, then select Rename from the worksheet menu.

Short Cut Worksheet

The Video provides Useful Tips

Common Excel Short Cut Keys

Ctrl + N

Create a new workbook.

1

Ctrl + O

Open an existing workbook

2

Ctrl + S

Save the active workbook.

3

Ctrl +W

Close the active workbook.

4

Ctrl + C

Copy the contents of the selected cells to Clipboard.

4

Ctrl + X

.Cut the contents of the selected cells to Clipboard

5

Ctrl + V

Insert the contents of the Clipboard into the selected cell(s).

5

Ctrl +P

Open the "Print" dialog.

6

Ctrl +1

Open the "Format Cells" dialog.

7

Ctrl +T

Convert selected cells to a table. You can also select any cell in a range of related data, and pressing Ctrl + T will make it a table.

Find more about Excel tables and their features.

7

Which Short cut Key Prints the WorkBook

1. CRTL-T
2. CRTL-X
3. CRTL-V
4. CRTL-S

CTRL-N

1. Opens a new Excel workbook
2. Copies a cell to the clipboard
3. Prints the worksheet
4. Pastes the clipboard into a range of cells

Challenge

1. Open our practice workbook (using The previous next slde
2. Insert a new worksheet, and rename it Q1 Summary.
   
3. Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April.
   
4. Create a copy of the Expenses Summary worksheet by right-clicking the tab. Do not just copy and paste the content of the worksheet into a new worksheet.
   
5. Change the color of the January tab to blue and the color of the February tab to red.
   
6. Group the worksheets September, October, and November.

Link https://media.gcflearnfree.org/content/56410d66ca7fad0d9cc8050a_11_09_2015/excel2016_multiplesheets_practice.xlsxt

Practice Workbook link

Upload your completed Worksheet

Enter 3 things you
have learnt about
Worksheets

How did you do?

I did well

I did ok

Need to speak to the teacher