Worksheet and workbook

Uploaded time: 2021-09-13 Difficulty: Primary

Worksheet and workbook

Worksheet and workbook

Graphic skills

Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.

First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these features to you in the following videos.

1.gif


First of all, let me introduce the worksheet and workbook. The workbook is like one page in a brochure. Sheet1 is a worksheet. We can click the plus sign to create a new worksheet. These two worksheets together form a workbook. We can also create multiple worksheets in one workbook.

2.gif


Double-click to change the name of the worksheet. Press and hold the worksheet to drag the order of worksheets. We can also hold down the Ctrl key and drag the worksheet to copy a new worksheet. 

3.gif


Right-click the worksheet then a detailed menu will pop up. Here, we can hide or unhide it. We can also delete the worksheet if we dont need it.

4.gif


When we need to deal with a lot of worksheets at work, we can mark important worksheets with colors, so that we can quickly locate the needed worksheet. We can also click Font Size to adjust the proportion of the worksheet font.

5.gif


This is the introduction on worksheet and workbook. Did you get it? To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.