![]() Typically, a worksheet uses only a part of the available cells. ![]() UsedCellRange and GetUsedCellRange(): Since each worksheet contains over a million rows and more than sixteen thousand columns, it is unlikely to use the full capacity of a worksheet. More about the feature is available in the Names article. Names (Named Ranges): the Worksheet class exposes a Names property of type NameCollection that allows you to create, update and manage names. For more info about rows refer to the Working with Rows and Columns section. Additionally, you can adjust the height of specific rows and the width of columns. The API of a worksheet allows you insert, manipulate and delete rows and columns. Rows and Columns: Cells in a worksheet are organized in rows and columns. More information about worksheet cells is available in the What is a Cell? section. The Cells property allows you to insert, manipulate and delete worksheet cells. The main characteristics of worksheets can be summarized in the following list:Ĭells: Each worksheet has a significant number of cells that can be assigned values and various formatting options. Typically, a workbook contains several worksheets with related content and only one of the worksheets is active at a time. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information. It is the working surface you interact with to enter data. The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. This article will help you get familiar with the concept of a worksheet and its features. Download free 30-day trial What is a Worksheet?
0 Comments
Leave a Reply. |