Start a new line of text inside a cell in Excel - Microsoft Support
Learn how to start a new line of text or add spacing between lines of text in a worksheet cell in Excel for different platforms. Press Alt+Enter, CONTROL + OPTION + RETURN, or the line break key on the numeric keyboard to insert a line break.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Learn how to use VLOOKUP, HLOOKUP, INDEX and MATCH to look up values in Excel tables. See examples, tips and limitations of each function, and how to use the new XLOOKUP and XMATCH functions.
TEXT function - Microsoft Support
Learn how to use the TEXT function to apply formatting to numbers, dates, times, and text in Excel. See format codes, common scenarios, and download an example workbook.
LOOKUP function - Microsoft Support
Learn how to use LOOKUP function to search for a value in a single row or column and return a value from the same position in another row or column. See examples, syntax, and tips for vector and array forms of LOOKUP.
Combine text from two or more cells into one cell
Learn how to use the Ampersand symbol (&) or the CONCAT function to combine data from multiple cells into a single cell in Excel. See examples, syntax, and tips for using these functions.
Keyboard shortcuts in Excel - Microsoft Support
Learn how to use keyboard shortcuts to work more efficiently in Excel for Windows, Mac, and web. Find the most frequently used shortcuts, ribbon shortcuts, access keys, and function keys for various tasks and actions.
Guidelines and examples of array formulas - Microsoft Support
The key difference is that when using an array formula, you press Ctrl+Shift+Enter to enter your formula. When you do this, Excel surrounds your array formula with braces — if you type the braces manually, your formula will be converted to a text string, and it won't work. Array functions can be an efficient way to build complex formulas.
Create a drop-down list - Microsoft Support
Learn how to insert a drop-down list of valid entries in Excel to make data entry easier or limit entries to certain items. Follow the steps to select a list range, set up data validation, and customize input and error messages.
Using IF with AND, OR, and NOT functions in Excel
Learn how to use the IF function with AND, OR, and NOT functions to test multiple conditions and return values in Excel. See examples, formulas, and tips for conditional formatting with these functions.
INDIRECT function - Microsoft Support
Learn how to use the INDIRECT function to return the reference specified by a text string. See syntax, arguments, examples, and limitations of this function in Excel for Microsoft 365, Mac, and web.
Using structured references with Excel tables - Microsoft Support
Learn how to create a custom name for your Excel table and use structured references to refer to table and column data in formulas. See examples, rules, and syntax for structured references.