Transpose (rotate) data from rows to columns or vice versa
Windows Web. If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to …
Split text into different columns with the Convert Text to Columns ...
Learn how to use the Convert Text to Columns Wizard or Excel functions to split text into different columns. See a video tutorial and follow the step-by-step instructions with screenshots.
Overview of formulas in Excel - Microsoft Support
Try using the new XLOOKUP function, an improved version of VLOOKUP that works in any direction and returns exact matches by default, making it easier and more convenient to use than its predecessor. Create a formula that refers to values in other cells. Select a cell. Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Hide or show rows or columns - Microsoft Support
Excel Help & Training. Rows & columns. Hide or show rows or columns. Hide or unhide columns in your spreadsheet to show just the data that you need to see or print. Hide columns. Select one or more columns, and then press Ctrl to select additional columns that aren't adjacent. Right-click the selected columns, and then select Hide.
Create, load, or edit a query in Excel (Power Query)
Power Query for Excel Help. Manage queries in Excel. Power Query offers several options for loading queries into your workbook. You set default query load settings in the Options dialog popup.
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.
Create a PivotTable to analyze worksheet data - Microsoft Support
Learn how to create a PivotTable from an existing table or range, or from multiple tables, Power BI datasets, or other sources. Follow the steps to add fields, change calculations, refresh data, and use recommended PivotTables.
Wrap text in a cell - Microsoft Support
Learn how to format text to wrap automatically or manually in a cell in Excel. Find out how to adjust the row height, use the Alt + Enter shortcut, and get more help from the Excel Tech Community.
Excel functions (alphabetical) - Microsoft Support
A complete list of all Excel functions in alphabetical order.
Apply data validation to cells - Microsoft Support
Learn how to use data validation to restrict, prompt, or alert users when entering data into Excel cells. Find examples, tips, and downloads for different types of data validation, such as drop-down lists, dates, and custom formulas.