Keyboard shortcuts in Excel | Microsoft Support Quick tips for using keyboard shortcuts with Excel for the web If you use a screen reader, go to Accessibility Shortcuts Menu (Alt+Shift+A) These are the most frequently used shortcuts for Excel for the web To quickly create a new worksheet in Excel for the web, open your browser, type Excel new in the address bar, and then press Enter
Protect a worksheet - Microsoft Support In your Excel file, select the worksheet tab that you want to protect Tip: You can select multiple, non-contiguous cells by pressing Ctrl+Left-Click Next, select the actions that users should be allowed to take on the sheet, such as insert or delete columns or rows, edit objects, sort, or use AutoFilter, to name a few
Filter for unique values or remove duplicate values In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, select Data > Sort Filter > Advanced To remove duplicate values, select Data > Data Tools > Remove Duplicates To highlight unique or duplicate values, from the Home tab, use the Conditional Formatting command in the Style group
Outline (group) data in a worksheet - Microsoft Support Go to Home > Cells > Format, point to Hide Unhide, and then select Unhide Columns To display the detail data within a group, select the button for the group, or press ALT+SHIFT+= Expand or collapse the entire outline to a particular level In the outline symbols, select the number of the level that you want
Filter data in a range or table in Excel - Microsoft Support Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data
Error message when you try to insert or hide rows or columns in Excel . . . If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2 Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells
Filter by using advanced criteria - Microsoft Support Click a cell in the list range Using the example, click any cell in the list range A6:C10 On the Data tab, in the Sort Filter group, click Advanced Choose to either Filter the list, in-place, hide rows that don't match your criteria, or Copy to another location, copy rows that match your criteria to another area of the worksheet