![]() ![]() To sort in ascending alphanumeric order ( Sort A to Z), press S and then A. The Data tab opens, and with Narrator you hear: “Ribbon tabs, Selected, Data tab item.” With JAWS, you hear: “Upper ribbon, Group box, Data tab.” With NVDA, you hear: "Ribbon tabs tab control expanded, Data tab selected." Use the arrow keys to navigate to a column of alphanumeric data in a range of cells, or to a table column containing alphanumeric data. You hear "Sorted," followed by the selected option. Use the Down arrow key to browse the options, and then press Enter to select an option. You can sort alphanumeric data from A to Z or from Z to A. For example, you can sort numeric data from smallest to largest or largest to smallest. The options that appear depend on the kind of data in the column. Press Alt+Down arrow key to open the filter menu, and then press the Tab key repeatedly until you hear: "Menu, Sort A to Z, unchecked menu item." Press the Right or Left arrow key to move to the column header for the data that you want to sort. When you are on the header row, you hear "Header item" after the cell location. Navigate to the header row in the table using the arrow keys. ![]() Sort text in a table or range Sort text in a table If you haven't saved the file after sorting, you can use undo (Ctrl+Z) to go back. Note: Once you sort the data, you cannot restore the original order. If you want to save sort criteria so that you can periodically reapply a sort when you open a workbook, it's a good idea to use a table. However, this only works for data in a table, it doesn’t apply to just a range of cells. This is especially important for multicolumn sorts or for sorts that take a long time to create. When you sort a table, Excel saves the criteria that you used with the workbook so that you can reapply it each time that you open the workbook. Most sort operations are column sorts, but you can also sort by rows. You can also sort by a custom list (such as Large, Medium, and Small) or by format, including cell color, font color, or icon set. You can sort data by text (A to Z or Z to A), numbers (smallest to largest or largest to smallest), and dates and times (oldest to newest or newest to oldest) in one or more columns. Open the AutoFilter dropdown menu from a column headerĪlt+M, T, and then move to TRIM with the Down arrow key Turn off the AutoFilter dropdown menu in a column heading This table shows keyboard shortcuts for sorting and filtering. Keyboard shortcuts for sorting and filtering To learn more about screen readers, go to How screen readers work with Microsoft Office. To learn how you can get new features faster, join the Office Insider program. New Microsoft 365 features are released gradually to Microsoft 365 subscribers, so your app might not have these features yet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |