What is the difference between workbook and worksheet in excel?

Difference: A workbook refers to a file used to store and process work data in Excel. Its extension is ".xlsx"; both data and charts are stored in the workbook in the form of a worksheet. middle. The worksheet is the most important part of Excel for storing and processing data. It is the table displayed in the workbook window.

Recommended: "Excel Tutorial"

Workbooks and worksheets in excel2016 Difference

Workbook

Workbook refers to the file used to store and process work data in Excel, and its extension is .xlsx . In Excel, both data and charts are stored in the workbook in the form of worksheets. The Excel file usually refers to a workbook file. The folder shown in the figure below contains 2 workbooks.

In Excel, a workbook is similar to a book, which contains many worksheets, and different types of data can be stored in the worksheets.

When Excel is started, the system will automatically create a new workbook file named "Workbook 1". The names of future workbooks will default to "Workbook 2" and "Workbook 3"...

Worksheet

The worksheet is the most important part of Excel for storing and processing data, and is displayed in the workbook window form. A worksheet can consist of up to 1,048,576 rows and 16,384 columns. The row numbers range from 1 to 1048576, and the column numbers are represented by the letters A, B...AA...XFD. Row numbers appear on the left side of the workbook window, and column numbers appear on the top edge of the workbook window.

The worksheet is a page in the workbook, and the worksheet is composed of cells. Usually related worksheets are placed in a workbook. For example, you can put the scores of the whole class in one workbook, put the scores of each student in their own worksheet, and put the statistical analysis of the scores of the whole class in one worksheet.

A workbook in Excel 2016 has 1 worksheet by default. Users can add worksheets as needed, but each workbook can include up to 255 worksheets. The workbook shown in the figure below contains three worksheets: [Calendar View], [Employee Leave Tracker] and [Settings].

To read more related articles, please visit PHP Chinese website! !

The above is the detailed content of What is the difference between workbook and worksheet in excel?. For more information, please follow other related articles on the PHP Chinese website!