WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Worksheet and workbook

Uploaded time: September 13, 2021 Difficulty Beginner

Worksheet and workbook

Worksheet and workbook

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.

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.

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.

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.

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.