How Excel workbooks relate to worksheets

Source: Internet
Author: User

Just learning Excel users, the face of books on the work of thin, worksheets, difficult to understand these concepts!

Below, this article gives you a detailed description of how workbooks in Excel relate to worksheets, and how to understand the concepts of workbooks and worksheets.

I. Work-THIN

First, let's look at the picture below. Take a look at the title section.

"My work thin. xls", which is an XLS extension, refers to an Excel file. The Excel file refers to a work-book.

Simply put, an Excel file, which is an XLS file, refers to a work-book.

Ii. Work Sheet

Now, let's see, as in the Excel file above, there are Sheet1, Sheet2, Sheet3 three worksheets.

Now, we can add a few worksheets to this workbook, such as Sheet4, SHEET5, SHEET6, etc. above.

Now, you should understand, a workbook, you can add worksheets, you can delete worksheets, and you can modify names for worksheets.

Like the following figure.

Right-click on any worksheet and the menu pops up. The actions of the worksheet are in the menu in the previous illustration.

Iii. the relationship between the work sheet and the workbook

Now you should understand that the worksheet is subordinate to the workbook, which is a kind of inclusion relationship, that is, the worksheet ∈ Work thin.

For a simple example, the workbook is the equivalent of a book, and the worksheet is equivalent to every page in the book. Without a workbook, there will never be a worksheet. Workbooks are made up of worksheets, and worksheets must be built on top of the workbook, and worksheets cannot exist alone.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.