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 …
Enable or disable macros in Microsoft 365 files
Block suspicious macros in Office on Windows 10 S. How malware can infect your PC. Improve security, evaluate and mitigate the risks of running macros, and see how to enable or disable …
TREND function - Microsoft Support
The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that …
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Keyboard shortcuts in Excel - Microsoft Support
This table lists the most frequently used shortcuts in Excel. Top of Page. Ribbon keyboard shortcuts. The ribbon groups related options on tabs. For example, on the Home tab, the …
Undo, redo, or repeat an action - Microsoft Support
Undo, redo, or repeat an action. Applies To. You can undo, redo, or repeat many actions in Microsoft Word, PowerPoint, and Excel. You can undo changes, even after you have saved, …
Activate Office - Microsoft Support
To use Microsoft 365 on your new device, you can activate Microsoft 365 as a 1-month trial of Microsoft 365 Family. You can also buy Microsoft 365 or a non-subscription version of Office, …
Manage workbook links - Microsoft Support
There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
Use Excel with earlier versions of Excel - Microsoft Support
To avoid the loss of data or functionality in an earlier version of Excel, you can then make the necessary changes to your current workbook. When you save a workbook to an Excel 97 …
Create workbook links - Microsoft Support
A workbook link (previously called an external reference) is a way to combine data from other workbooks or other sheets in the same workbook. You might want to use them to: Link …