Excel For Mac 2017 Keyboard Shortcuts
Best free dvd ripper for mac 2016. If you are Windows users, please turn to.
You can always ask an expert in the, get support in the, or suggest a new feature or improvement on. See also Technical support for customers with disabilities Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the for technical assistance.
Ctrl+Arrow Key moves to the edge of the current data region in a worksheet. Shift+Arrow Key extends the selection of cells by one cell. Ctrl+Shift+Arrow Key extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. Left Arrow or Right Arrow selects the tab to the left or right when the Ribbon is selected.
Excel For Mac 2017 Keyboard Shortcut Switch Sheets
Shift+F11 inserts a new worksheet. Alt+F11 opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA). F12 Displays the Save As dialog box. Other useful shortcuts Key Description Alt Displays the Key Tips (new shortcuts) on the Ribbon. For example, Alt, W, P switches the worksheet to Page Layout view.
Microsoft's own lists of keyboard shortcuts for Excel in Excel 2016 for Windows, Excel 2016 for Mac, Excel Online, Excel 2013, Excel 2010 and Excel 2007. The Excel Hero Shortcut Key Game. The Periodic Table of Excel Keyboard Shortcuts at Data Pig Technologies. 200 Excel Shortcuts for PC and Mac. Well, get ready to be even fancier (and more productive) because we've curated 200 of the best Excel keyboard shortcuts.
When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons.
If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. CTRL+F10 maximizes or restores the selected workbook window. F11 Creates a chart of the data in the current range.
Down Arrow or Alt+Down Arrow opens a selected drop-down list. Backspace Deletes one character to the left in the Formula Bar. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point. Delete Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro. F9 Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. Any video converter for mac free software. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
For example, ALT, W, P switches the worksheet to Page Layout view. ALT, W, L switches the worksheet to Normal view. ALT, W, I switches the worksheet to Page Break Preview view. ARROW KEYS Move one cell up, down, left, or right in a worksheet. CTRL+ARROW KEY moves to the edge of the current data region in a worksheet. SHIFT+ARROW KEY extends the selection of cells by one cell.
Tip: Download or print a Quick Reference Card:. (PDF) Key Description CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left.
Ctrl+F1 displays or hides the Ribbon. Alt+F1 creates an embedded chart of the data in the current range. Alt+Shift+F1 inserts a new worksheet. F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. Shift+F2 adds or edits a cell comment. Ctrl+F2 displays the print preview area on the Print tab in the Backstage view.
F3 Displays the Paste Name dialog box. Available only if names have been defined in the workbook ( Formulas tab, Defined Names group, Define Name). Shift+F3 displays the Insert Function dialog box. F4 Repeats the last command or action, if possible. When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references.