Left-click on a column header to sort a column ascending, then left-click again to toggle between ascending and descending. If sorting on multiple column headers using Shift+left-click, use Shift+double-click on the first column that was clicked on and this will toggle ascending/descending direction of all the columns included in the sorting. On multiple column headers, the columns will all be sorted in the same ascending or descending direction. Example use areas: Data analytics Project management Finance and accounting. When End mode is on: (1) Use arrow keys to go to edge of current data area (2) Use Home to go to last cell (cell in lowest used row and right-most used column) of worksheet (3) Use Enter to go to last non-blank cell to the right. Open the Role Center from the navigation pane Excel is the worlds most used spreadsheet program. Excel Keyboard Shortcuts: Navigation And Selection. Open a lookup window (from an ellipsis button)Īpply entries, get source documents, or get warehouse documents Select the menu bar and display access keys Move to the next field on non-line FastTabs Move to the field below in the same column By default, the value is 10 minutes, but you can choose a lower or higher value if you want. Check the option ‘Save AutoRecover information every’ checkbox. In the Excel Options dialog box, click on the Save option on the left. Move to the field above in the same column Below are the steps to turn on Auto-save in Excel: Click the File tab.

The following table provides an overview of shortcut key combinations in the Microsoft Dynamics NAV Windows client.

Microsoft excel shortcut keys 2013