You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

This article describes the formula syntax and usage of the CHOOSE function which uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of …

How to use the INDEX function in Excel to return a value or reference to a value within a table or range.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …

When you enter a value in cell B2 (the first argument), VLOOKUP searches the cells in the range C2:E7 (2nd argument) and returns the closest approximate match from the third column in the …

Next, select the actions that users should be allowed to take on the sheet, such as insert or delete columns or rows, edit objects, sort, or use AutoFilter, to name a few.

The following examples show you how to create multi-cell and single-cell array formulas. Where possible, we’ve included examples with some of the dynamic array functions, as well as …

To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let's use the following example data to …

Match entire cell contents - Check this if you want to search for cells that contain only the characters that you typed in the Find what box. If you want to search for text or numbers with …

Learn how to select cells, ranges, entire columns or rows, or the contents of cells, and discover how you can quickly select all data in a worksheet or Excel table.