![]() ![]() The keyboard shortcut to reapply is Ctrl + Alt + L. New or modified data in the column won't be filtered or sorted until you click Reapply. Reapply - Reapply the filter and sort in the current range. Ĭlear - Clear the filter and sort data for the current range of data. The keyboard shortcut to filter is Ctrl + Shift + L. Once filtering is turned on, click on the arrow in the column header to choose a filter for the column. Sort - Launch the Sort to sort data based on several criteria at once.įilter - Enable filtering of the selected cells. Sort Z to A - Sort the selection so that the highest values are at the top of the column. Sort A to Z - Sort the selection so that the lowest values are at the top of the column. This command will be unavailable if the workbook does not contain linked information. Properties - Data Range Properties - Specify how cells connected to a data source will update, what contents from the source will be displayed, and how changes in the number of rows or columns in the data source will be handled in the workbook.Įdit Links - This is used to break a link to an external reference. ![]() Data connections are links to data outside of this workbook which can be upgraded if the source data changes. ![]() Ĭonnections - Display all data connections for the workbook. The keyboard shortcut to Refresh All is Ctrl + Alt + F5. Refresh All - Update all the information in the workbook that is coming from a data source. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |