![]() 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. |