![parts of a spreadsheet microsoft excel parts of a spreadsheet microsoft excel](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/4009863675/original/What_is_a_spreadsheets_and_its_usesimage1.jpeg)
For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num. Use this function to select one of up to 254 values based on the index number. For example, if the range A1:A3 contains the values 5, 7, and 38, then the formula =MATCH(7,A1:A3,0) returns the number 2, because 7 is the second item in the range.
![parts of a spreadsheet microsoft excel parts of a spreadsheet microsoft excel](https://www.exceldemy.com/wp-content/uploads/2013/12/excel-2013-window01-660x352.png)
Use this function to search for an item in a range of cells, and then return the relative position of that item in the range. Check out this video about using VLOOKUP. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book). Use this function when you need to find things in a table or a range by row. Use this function when you need to look in a single row or column and find a value from the same position in a second row or column. Here's a video about using the IF function. Use this function to return one value if a condition is true and another value if it's false. Use this function to add the values in cells. *This documentation is neither affiliated with, nor authorized, sponsored, or approved by, Microsoft Corporation.Here are the 10 functions that people read about most. More about the feature is available in the Worksheet Protection article. Additionally, you can choose what options will be available to the user when protection is enabled. When a worksheet is protected the user can edit the contents only of the cells that were explicitly marked as unlocked. Protection: You can restrict the user from modifying the content and structure of the worksheet. For more information about the feature see the Find and Replace article. More information on the topic is available in the Hyperlink article.įind and Replace: You can easily find and replace text and numbers in the content of a worksheet. More information and examples of working with the used cell range of a worksheet are available in the Iterating Used Cells topic.Ĭollection of Hyperlinks: Each worksheet can contain numerous hyperlinks to web pages, particular cells in the workbook or email addresses. Example 1 demonstrates how to get the used cell range of cells with value.Įxample 1: Get the used cell range of cells with valueĬellRange result = worksheet.GetUsedCellRange(new IPropertyDefinition ) With the GetUsedCellRange() method you can pass and IEnumerable object to get the used cell range, holding only the cells with specific property definitions. The UsedCellRange property of the Worksheet class returns a cell range that starts from cell A1 and holds all cells containing data or formatting.
![parts of a spreadsheet microsoft excel parts of a spreadsheet microsoft excel](https://sbcamgscl1.neocities.org/grade5/images/excel_label_parts_with_answers.png)
That said, in a number of scenarios you might want to know which part of the worksheet contains your data and ignore the rest of the cells. 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?