key instead of the Shift key. What we will do is limit our scope and concentrate only on Function Keys today. In a dialog, it performs the action for the default command button in the dialog (the button with the bold outline, often the OK button). This gives you something like a full-page view of your sheet. On the Keyboard tab, select the check box for Use all F1, F2, etc. by using the arrow keys, Add another range of cells to the selection, Select the current array, which is the array that the Copy a formula from the cell above the active cell into the cell or the Formula Bar. +Shift+Z, +X Keys for other layouts might not correspond exactly to the keys on a US keyboard. field pop-up menu for the selected cell. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet. Left or Right arrow key selects the tab to the left or right when the ribbon is selected. Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below. Open the Home tab and format text and numbers, or use other tools such as Find. Select all cells from the current location to the last cell of the row. Or, in a protected worksheet, move between unlocked cells. active cell belongs to, Select cells in a row that don't match the value After pressing Return, move selection, select the direction you want to move in. Just press the FN key. When a cell reference or range is selected in a formula, F4 cycles through all the various combinations of absolute and relative references. Apply the Scientific number format with two decimal places. Windows keyboard: Windows context key+F10. We will try and learn the actions associated with F1 through F12, standalone and in combination with keys like Alt, Ctrl and Shift. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Ctrl+F5: restores the window size of the selected workbook window. Open the Data tab and refresh connections or use data tools. Change system preferences for keyboard shortcuts with the mouse, Change function key preferences with the mouse. Check spelling in the active worksheet or selected range. Paste content at the insertion point, replacing any selection. (not the forward delete key  Refreshes workbook. Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel for Mac. Recheck dependent formulas and then calculates all cells in all open workbooks. Control+Shift+Return, Cancel an entry in the cell or formula bar, Display the Formula Builder after you type a valid function name in a formula, Edit the active cell and position the insertion point at the end of the line, Toggle the formula reference style between absolute, relative, and mixed, Copy the value from the cell above the active cell into the cell or the formula bar, Alternate between displaying cell values and displaying cell formulas, Copy a formula from the cell above the active cell into the cell or the formula bar, +Option+Return +F, and then type your search words. You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Complete an entry in the formula bar and select the cell below. Enable Add to Selection mode - select non-adjacent cells when enabled. A notification pops up saying you're using an access key from an earlier version of Microsoft Office. For example, press the letter C to pick the Comments option. Move to the edge of the current data region in a worksheet. Press This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Mac. F2 alone: edit the active cell and put the insertion point at the end of its contents. Ctrl+Shift… In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks. Open the File page and use Backstage view. or A comma sign (,) in a shortcut means that you need to press multiple keys in order. Extend selection to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. Ctrl+F10: maximizes or restores the selected workbook window. Tips: If a spreadsheet opens in the Reading view, editing commands won’t work. If you're familiar with keyboard shortcuts on your MacOS computer, the same key combinations work with Excel for iOS using an external keyboard, too. on the sheet (lower-right corner), Control+Shift+End or In a data form, it moves to the first field in the next record. Open the Data tab and connect to, sort, filter, analyze, and work with data. In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Switch to the next workbook window when more than one workbook window is open. On a MacBook, Shift+FN+Up arrow, Alternate between hiding objects, displaying objects, Excel Shortcuts: Ctrl. If you're familiar with keyboard shortcuts on your Windows computer, the same key combinations work with Excel for Android using an external keyboard, too. or To move between tabs on the ribbon, press the Tab key. Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). +Y If you don't want to press the FN key each time, you can change your Apple system preferences. Check dependent formulas, and then calculate all cells in all open workbooks, including cells not marked as needing to be calculated. (Pressing Alt does the same thing.). Ctrl+F9: minimizes a workbook window to an icon. Ctrl+Arrow key moves to the edge of the current data region in a worksheet. or move down one cell if only one column is selected, Move from right to left within the selection, Press again to turn off. Alt or F10. Open the context menu for the selected cell, column, or row. Edit the active cell and put the insertion point at the end of its contents. Repeat last action (for example, create a text box) or toggle among cell references. Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected. Open the list of validation choices on a cell that has data validation option applied to it. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. * These shortcuts may move in another direction other than down or up.