Turn off Scroll Lock - Microsoft Support
Learn how to disable scroll lock in Excel using the ScrLk key or the on-screen keyboard. Find out how to troubleshoot scroll lock issues and check the status bar for scroll lock indication.
Track changes in a Shared Workbook - Microsoft Support
Learn how to use Track Changes to see the changes made to a shared workbook by others. This article explains an older method that has many limitations and has been replaced by co-authoring.
Find and remove duplicates - Microsoft Support
Learn how to use conditional formatting and Remove Duplicates feature to identify and delete duplicate values in Excel. Follow the steps and tips to avoid losing any important data.
Repairing a corrupted workbook - Microsoft Support
Excel cannot always start File Recovery mode automatically. If you cannot open a workbook because it has been corrupted, you can try to repair the workbook manually. You can also try other methods to recover workbook data when repairing a workbook is not successful.
Reapply a filter and sort, or clear a filter - Microsoft Support
Learn how to clear a filter for one column or all filters in a range of cells or table in Excel. Find out how to reapply a filter or sort, or save filter and sort criteria with a workbook.
Get help with Show Changes in Excel - Microsoft Support
Learn how to track and view the most recent changes to your Excel workbook using the Show Changes feature. Find out where to use Show Changes, what changes are supported, and how to clear or restore the Changes pane.
Use the Selection pane to manage objects in documents
Learn how to use the Selection pane to re-order, show or hide, and group or ungroup objects in your Word, Excel, or PowerPoint document. The Selection pane displays the name and order of each inserted object and lets you apply keyboard shortcuts.
Undo, redo, or repeat an action - Microsoft Support
Learn how to use keyboard shortcuts or the Quick Access Toolbar to undo, redo, or repeat actions in Microsoft Word, PowerPoint, and Excel. Find out how to modify the undo limit and what actions can't be undone or repeated.
Add a PDF to your Office file - Microsoft Support
Learn how to insert a PDF file as an attachment into your Office file, such as Word, Excel, or Outlook. You can also edit the PDF content in Word 2013 or 2016 with the reflow feature.
About the shared workbook feature - Microsoft Support
Learn how to enable and use the Shared Workbook feature in Excel, which allows multiple users to collaborate on a workbook. Note that this feature has limitations and has been replaced by co-authoring in newer versions of Excel.
Clear or remove a filter - Microsoft Support
Learn how to clear or remove a filter from a specific column, clear all filters in a worksheet, or remove all filters in Excel. Find out how to identify filtered data and use AutoFilter to filter your data.