Queries & Connections

• Refresh All (Ctrl + Alt + F5): Updates all information in the active workbook from external sources. Includes a drop-down with commands: Refresh, Refresh Status, Cancel Refresh, and Connection Properties.

• Queries & Connections: Opens the "Workbook Connections" dialog box which manages links to data sources outside the workbook.

• Properties: Active when a cell populated through an external connection is selected.

• Edit Links: Displays the "Edit Links" dialog box for managing data connections.

Data Types

• Stocks: Converts selected cells into a Stocks data type for easy retrieval of financial information (tickers, prices, company details).

• Currencies: Converts currency pairs (e.g., "USD/EUR") into a Currency data type to obtain currency conversion rates.

• Geography: Converts selected cells into a Geography data type for easy access to information about countries, regions, cities, and populations.

Sort & Filter

• Sort A to Z:  Sorts data alphabetically from A to Z and numerically from lowest to highest.

• Sort Z to A: Sorts data alphabetically from Z to A and numerically from highest to lowest.

• Sort: Displays the "Sort" dialog box.

• Filter: Toggles filtering on the current selection.

• Clear: Clears the filter and sort for the current selection.

• Reapply: (Ctrl + Alt + L) Reapplies the filter and sort to the current selection.

• Advanced: Displays the "Advanced Filter" dialog box.