XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
Turn off Scroll Lock - Microsoft Support
If a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
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.
Remove or turn off hyperlinks - Microsoft Support
You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.
Create, load, or edit a query in Excel (Power Query)
Applies To. Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window. Tip To tell if data in a worksheet is shaped by Power Query, select a cell of data, and if the Query context ribbon tab appears, then the data was loaded from Power Query.
Lock or unlock specific areas of a protected worksheet
To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. 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.
Open file links directly in Office desktop apps - Microsoft Support
This feature works for links to Word, Excel, or PowerPoint files, stored on OneDrive or SharePoint, that you click in Word, Excel, Outlook, or PowerPoint for Microsoft 365 on Windows or Mac. Once a user turns this feature on, it will apply to all three apps - …
Transpose (rotate) data from rows to columns or vice versa
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 rows, or vice versa.
Cancel printing - Microsoft Support
You’ve started a print job, but you want to cancel it. You can attempt to stop printing either directly from Excel or from Windows. However, you can cancel printing from your computer only if the job hasn’t been entirely sent to the printer.
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and patterns.
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. Double-click the cell in which you want to insert a line break. Click the location inside the selected cell where you want to break the line.