Home  >  Article  >  Topics  >  What does excel worksheet refer to?

What does excel worksheet refer to?

藏色散人
藏色散人Original
2020-03-09 09:33:2617770browse

What does excel worksheet refer to?

#What does excel worksheet refer to?

A worksheet is a table displayed in the workbook window. A worksheet can be composed of 1048576 rows and 256 columns. The rows are numbered from 1 to 1048576, and the columns are numbered with the letters A and B in sequence. ...IV means that the row number is displayed on the left side of the workbook window, and the column number is displayed on the top of the workbook window.

Recommended: "excel tutorial"

Excel defaults to a workbook with three worksheets. Users can add worksheets as needed, but the work in each workbook The number of tables is limited by available memory. The current mainstream configuration can easily create more than 255 worksheets.

Each worksheet has a name, and the worksheet name is displayed on the worksheet label. The worksheet label displays the first three default worksheet names of the system: Sheet1, Sheet2, and Sheet3. The white worksheet label indicates the active worksheet. Click a worksheet label to select the worksheet as the active worksheet.

Each table in the workbook is called a worksheet. The workbook is like a binder, and the worksheets are like the sheets of loose-leaf paper in it. The worksheet is the most important part of Excel for storing and processing data, and contains cells arranged in rows and columns. It is part of a workbook, also called a spreadsheet. Use worksheets to organize and analyze data. Data can be entered and edited on multiple worksheets at the same time, and data from different worksheets can be summarized and calculated. After you create a chart, you can place it on the same worksheet as the source data or on a separate chart sheet.

New worksheet

If necessary, you can create multiple new worksheets in the workbook.

In the Excel2003 and Excel2000 workbook windows, click the target location of the new worksheet and click the "Insert" - "Worksheet" command to create a new worksheet.

In Excel 2010, click the "Insert Worksheet" icon at the worksheet label at the bottom of the workbook window to create a new worksheet at the end of the workbook.

In Excel 2013, click the " " icon at the worksheet label at the bottom of the workbook window to create a new worksheet at the end of the workbook.

Many table controls also support multiple worksheets and cross-worksheets, such as the excel-like table control Spread.

The above is the detailed content of What does excel worksheet refer to?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn