Move to first cell in worksheet
Related videos The videos below demonstrate this shortcut.
Posts
Move to last cell in worksheet
The last cell may or may not contain data. Related videos The videos below demonstrate this shortcut. Shortcuts to navigate worksheets
Move to left edge of data region
If the active cell is non-empty, Excel will stop on the last non-empty cell to the left. On a Mac, the control key () can be used instead of the command key (). Related videos The videos below demonstrate this shortcut. Shortcuts to navigate worksheets How to move around big lists fast Selecting chart elements
Move to next control
About This Shortcut This shortcut will move to the next control in the dialog box. Related videos The videos below demonstrate this shortcut. Shortcuts for Excel dialog boxes (Mac) Shortcuts for Excel dialog boxes (Win)
Move to next pane
About This Shortcut Move to the next pane in a worksheet that has been split. Related videos The videos below demonstrate this shortcut. Shortcuts to navigate workbooks
Move to next ribbon control
About This Shortcut This shortcut will move to the next ribbon control from the currently active control. Use SHIFT-TAB to move backwards. Related videos The videos below demonstrate this shortcut. Excel Ribbon shortcuts
Move to next tab
About This Shortcut This shortcut will move to the next tab in the dialog box. Related videos The videos below demonstrate this shortcut. Shortcuts for Excel dialog boxes (Mac) Shortcuts for Excel dialog boxes (Win)
Move to previous control
About This Shortcut This shortcut will move to the previous control in the dialog box. Related videos The videos below demonstrate this shortcut. Shortcuts for Excel dialog boxes (Mac) Shortcuts for Excel dialog boxes (Win)
Move to previous pane
About This Shortcut Move to the previous pane in a worksheet that has been split. Related videos The videos below demonstrate this shortcut. Shortcuts to navigate workbooks
Move to previous tab
About This Shortcut This shortcut will move to the previous tab in the dialog box. Related videos The videos below demonstrate this shortcut. Shortcuts for Excel dialog boxes (Mac) Shortcuts for Excel dialog boxes (Win)
Move to right edge of data region
If the active cell is non-empty, Excel will stop on the last non-empty cell to the right. On a Mac, the control key () can be used instead of the command key (). Related videos The videos below demonstrate this shortcut.
Move to top edge of data region
If the active cell is non-empty, Excel will stop on the last non-empty cell above the active cell. On a Mac, the control key () can be used instead of the command key (). Related videos The videos below demonstrate this shortcut.
Moving average formula
This is why it “works” in E5 and E6. When the current row number is less than 3, the formula returns #N/A. Otherwise, the formula returns a moving average as before. The general form is: where n is the number of periods to include in each average. As above, OFFSET returns a range that is passed into the AVERAGE function. Below you’re able to see this formula in action, wherenis thenamed rangeE2....
