excel for mac table merge cells shortcut

Excel Table Merge Cells Shortcut Full Screen View

Keyboard shortcuts allow you to quickly complete commands and functions without using a mouse.

The shortcuts in this article refer to the US keyboard layout.

Keys for other layouts might not correspond exactly to the keys on a US keyboard.

If you have to press one key immediately after another, the keys are separated by a comma (,).

For information about changing the key assignment of a keyboard shortcut, see Mac Help for your version of the Mac OS or see your utility application.

To do this Press Paste V or CONTROL V Copy C or CONTROL C Clear DELETE Save S or CONTROL S Undo Z or CONTROL Z Redo Y or CONTROL Y or SHIFT Z Cut X or CONTROL X Bold B or CONTROL B Print P or CONTROL P Open Visual Basic OPTION F11 Fill Down D or CONTROL D Fill Right R or CONTROL R Insert cells CONTROL SHIFT Delete cells HYPHEN or CONTROL HYPHEN Calculate all open workbooks or F9 Close window W or CONTROL W Quit Excel Q Display the Go To dialog box CONTROL G or F5 Display the Format Cells dialog box 1 or CONTROL 1 Display the Replace dialog box CONTROL H or SHIFT H Paste Special CONTROL V or CONTROL OPTION V or OPTION V Underline U Italic I or CONTROL I New blank workbook N or CONTROL N New workbook from template SHIFT P Display the Save As dialog box SHIFT S or F12 Display the Help window F1 or Select All A or SHIFT SPACEBAR Add or remove a filter SHIFT F or CONTROL SHIFT L Minimize or maximize the ribbon tabs OPTION R Display the Open dialog box O or CONTROL O Check spelling F7 Open the thesaurus SHIFT F7 Display the Formula Builder SHIFT F3 Open the Define Name dialog box F3 Open the Create names dialog box SHIFT F3 Insert a new sheet SHIFT F11 Print P or CONTROL P Print preview P or CONTROL P Get started Many keyboards assign special functions to function keys, by default.

To use the function key for other purposes, you have to press Fnthe function key.

Shortcut conflicts Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts.

To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.

Change system preferences for keyboard shortcuts with the mouse On the Apple menu, press System Preferences.

Clear the check box for the keyboard shortcut that you want to use.

Excel Table Merge Cells Shortcut Full Screen View

Work in windows and dialogs To do this Press Expand or minimize the ribbon OPTION R Switch to full screen view CONTROL F Switch to the next application TAB Switch to the previous application SHIFT TAB Close the active workbook window W Copy the image of the screen and save it to a Screen Shot file on your desktop.

SHIFT 3 Minimize the active window CONTROL F9 Maximize or restore the active window CONTROL F10 or F10 Hide Excel.

You must select the row starting with the active cell CONTROL Select only cells that are directly referred to by formulas in the selection CONTROL SHIFT Select all cells that are directly or indirectly referred to by formulas in the selection CONTROL SHIFT Select only cells with formulas that refer directly to the active cell CONTROL Select all cells with formulas that refer directly or indirectly to the active cell CONTROL SHIFT Work with a selection To do this Press Copy C or CONTROL V Paste V or CONTROL V Cut X or CONTROL X Clear DELETE Delete the selection CONTROL HYPHEN Undo the last action Z Hide a column ) or CONTROL ) Unhide a column SHIFT ) or CONTROL SHIFT ) Hide a row ( or CONTROL ( Unhide a row SHIFT ( or CONTROL SHIFT ( Move from top to bottom within the selection (down) RETURN Move from bottom to top within the selection (up) SHIFT RETURN Move from left to right within the selection, or move down one cell if only one column is selected TAB Move from right to left within the selection, or move up one cell if only one column is selected SHIFT TAB Move clockwise to the next corner of the selection CONTROL PERIOD Group selected cells SHIFT K Ungroup selected cells SHIFT J These shortcuts may move in another direction other than down or up.

If youd like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences, click Edit, and then, under.

After pressing Return, move selection, select the direction you want to move in.

F11 Cycle through chart object selection ARROW KEYS Sort, filter, and use PivotTable reports To do this Press Open the Sort dialog box SHIFT R Add or remove a filter SHIFT F or CONTROL SHIFT L Display the Filter list or PivotTable page field pop-up menu for the selected cell OPTION DOWN ARROW Outline data To do this Press Display or hide outline symbols CONTROL 8 Hide selected rows CONTROL 9 Unhide selected rows CONTROL SHIFT Opening parenthesis ( ( ) Hide selected columns CONTROL ZERO Unhide selected columns CONTROL SHIFT Closing parenthesis ( ) ) Use function key shortcuts Excel 2016 for Mac uses the function keys for common commands, including Copy and Paste.

For quick access to these shortcuts, you can change your Apple system preferences so you dont have to press the FN key every time you use a function key shortcut NOTE: Changing system function key preferences affects how the function keys work for your Mac, not just Excel.

After changing this setting, you can still perform the special features printed on a function key.

For example, to use the F12 key to change your volume, you would press FNF12.

If a function key doesnt work as you expect it to, press the FN key in addition to the function key.

If you dont want to press the FN key each time, you can change your Apple system preferences: Change function key preferences with the mouse On the Apple menu, press System Preferences.

Select Keyboard. On the Keyboard tab, select the check box for Use all F1, F2, etc.

Excel For Mac Table Merge Cells Shortcut