Keyboard shortcuts listed in this topic refer to the U.S. keyboard layout. Keys on other keyboard layouts might not correspond to the keys on a U.S. How to change format of a picture on mac. keyboard. Keyboard shortcuts for laptop computers might also differ.
Some function key shortcuts conflict with default key assignments in Mac OS X version 10.3 or later. To use them, you must change the settings for your function keys. On the Apple menu, go to System Preferences. Under Hardware, click Keyboard > Keyboard and then check Use all F1, F2, etc. as standard function keys.
Alt+Shift+Down arrow key. Expand the text under a heading. Alt+Shift+Plus sign. Collapse the text under a heading. Alt+Shift+Minus sign. Expand or collapse all text or headings. Hide or display the character formatting. Forward slash (/) (on the numeric keypad) Switch between showing the first line of body text and showing all body. Alt-Shift-Command-V will paste and match style - so that the text you paste in has the same style as the text around it, rather than the style brought over from the place you copied it from.
Custom Keyboard Shortcuts: In the Mac versions of Excel, you have to go to the Tools menu (it may be under File and then Options depending on the Excel version) and then select Customize Keyboard there to create these shortcuts. These shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently.
Tip: To quickly find your search term on this page, press CtrlF or ⌘F (Mac) and use the find bar.
General | Windows | Mac |
Open Excel help | F1 | ⌘/ |
Undo last action | CtrlZ | ⌘Z |
Redo last action | CtrlY | ⌘Y |
Copy selected cells | CtrlC | ⌘C |
Cut selected cells | CtrlX | ⌘X |
Paste content from clipboard | CtrlV | ⌘V |
Display the Paste Special dialog box | CtrlAltV | Control⌘V |
Display find and replace | CtrlF | ⌘F |
Display find and replace, replace selected | CtrlH | ControlH |
Find next match | ShiftF4 | ⌘G |
Find previous match | CtrlShiftF4 | ⌘ShiftG |
Create embedded chart | AltF1 | FnOptionF1 |
Create chart in new chart sheet | F11 | FnF11 |
Toggle Autofilter | CtrlShiftL | ⌘ShiftF |
Activate filter | Alt↓ | Option↓ |
Create table | CtrlT | ControlT |
Select an entire row | ShiftSpacebar | ShiftSpacebar |
Select an entire column | CtrlSpacebar | ControlSpacebar |
Select the entire worksheet | CtrlA or CtrlShiftSpacebar | ⌘A |
File | Windows | Mac |
Create new workbook | CtrlN | ⌘N |
Open workbook | CtrlO | ⌘O |
Save workbook | CtrlS | ⌘S |
Displays the Save As dialog | F12 | ⌘ShiftS |
Print preview and print | CtrlP or CtrlF2 | ⌘P |
Close current workbook | CtrlF4 | ⌘W |
Close Excel | AltF4 | ⌘Q |
Ribbon | Windows | Mac |
Expand or collapse ribbon | CtrlF1 | ⌘OptionR |
Activate access keys | Alt | |
Move to next ribbon control | Tab | Tab |
Activate or open selected control | Spacebar | Spacebar |
Confirm control change | Enter | Return |
Get help on selected control | F1 | |
Drag and Drop | Windows | Mac |
Drag and cut | drag | drag |
Drag and copy | Ctrldrag | Optiondrag |
Drag and insert | Shiftdrag | Shiftdrag |
Drag and insert copy | CtrlShiftdrag | OptionShiftdrag |
Drag to worksheet | Altdrag | ⌘drag |
Drag to duplicate worksheet | Ctrldrag | Optiondrag |
Navigation | Windows | Mac |
Move one cell right | → | → |
Move one cell left | ← | ← |
Move one cell up | ↑ | ↑ |
Move one cell down | ↓ | ↓ |
Move one screen right | AltPgDn | FnOption↑ |
Move one screen left | AltPgUp | FnOption↓ |
Move one screen up | PgUp | Fn↑ |
Move one screen down | PgDn | Fn↓ |
Move to right edge of data region | Ctrl→ | Control→ |
Move to left edge of data region | Ctrl← | Control← |
Move to top edge of data region | Ctrl↑ | Control↑ |
Move to bottom edge of data region | Ctrl↓ | Control↓ |
Move to beginning of row | Home | Fn← |
Move to last cell in worksheet | CtrlEnd | FnControl→ |
Move to first cell in worksheet | CtrlHome | FnControl← |
Turn End mode on | End | Fn→ |
Selection | Windows | Mac |
Select entire row | ShiftSpacebar | ShiftSpacebar |
Select entire column | CtrlSpacebar | ControlSpacebar |
Select entire worksheet | CtrlA | ⌘A |
Add non-adjacent cells to selection | CtrlClick | ControlClick |
Move right between non-adjacent selections | CtrlAlt→ | ControlOption→ |
Move left between non-adjacent selections | CtrlAlt← | ControlOption← |
Toggle add to selection mode | ShiftF8 | FnShiftF8 |
Cancel selection | Esc | Esc |
Extend Selection | Windows | Mac |
Extend selection by one cell right | Shift→ | Shift→ |
Extend selection by one cell left | Shift← | Shift← |
Extend selection by one cell up | Shift↑ | Shift↑ |
Extend selection by one cell down | Shift↓ | Shift↓ |
Extend the selection to the last cell right | CtrlShift→ | ControlShift→ |
Extend the selection to the last cell left | CtrlShift← | ControlShift← |
Extend the selection to the last cell up | CtrlShift↑ | ControlShift↑ |
Extend the selection to the last cell down | CtrlShift↓ | ControlShift↓ |
Extend selection up one screen | ShiftPgUp | FnShift↑ |
Extend selection down one screen | ShiftPgDn | FnShift↓ |
Extend selection to start of row | ShiftHome | FnShift← |
Extend selection to first cell in worksheet | CtrlShiftHome | FnControlShift← |
Extend selection to last cell in worksheet | CtrlShiftEnd | FnControlShift→ |
Toggle extend selection mode | F8 | FnF8 |
Active Cell | Windows | Mac |
Select active cell only | ShiftBackspace | ShiftDelete |
Show the active cell on worksheet | CtrlBackspace | ⌘Delete |
Move active cell clockwise in selection | Ctrl. | Control. |
Move active cell down in selection | Enter | Return |
Move active cell up in selection | ShiftEnter | ShiftReturn |
Move active cell right in a selection | Tab | Tab |
Move active cell left in a selection | ShiftTab | ShiftTab |
Select Special | Windows | Mac |
Display ‘Go To' dialog box | CtrlG | ControlG |
Select cells with comments | CtrlShiftO | FnControlShiftO |
Select current region around active cell | CtrlShift* | ControlShiftSpacebar |
Select current region | CtrlA | ⌘A |
Select current array | Ctrl/ | Control/ |
Select row differences | Ctrl | Control |
Select column differences | CtrlShift| | ControlShift| |
Select direct precedents | Ctrl[ | Control[ |
Select all precedents | CtrlShift{ | ControlShift{ |
Select direct dependents | Ctrl] | Control] |
Select all dependents | CtrlShift} | ControlShift} |
Select visible cells only | Alt; | ⌘ShiftZ |
Cell Edit Mode | Windows | Mac |
Edit the active cell | F2 | ControlU |
Insert or edit comment | ShiftF2 | ShiftF2 |
Cancel entry | Esc | Esc |
Select one character right | Shift→ | Shift→ |
Select one character left | Shift← | Shift← |
Move one word right | Ctrl→ | Control→ |
Move one word left | Ctrl← | Control← |
Select one word right | CtrlShift→ | ControlShift→ |
Select one word left | CtrlShift← | ControlShift← |
Select to beginning of cell | ShiftHome | FnShift← |
Select to end of cell | ShiftEnd | FnShift→ |
Delete to end of line | CtrlDelete | ControlDelete |
Delete character to the left of cursor | Backspace | Delete |
Delete character to the right of cursor | Delete | FnDelete |
Start a new line in the same cell | AltEnter | ControlOptionReturn |
Entering Data | Windows | Mac |
Enter and move down | Enter | Return |
Enter and move up | ShiftEnter | ShiftReturn |
Enter and move right | Tab | Tab |
Enter and move left | ShiftTab | ShiftTab |
Complete entry and stay in same cell | CtrlEnter | ControlReturn |
Enter same data in multiple cells | CtrlEnter | ControlReturn |
Insert current date | Ctrl; | Control; |
Insert current time | CtrlShift: | ControlShift: |
Fill down from cell above | CtrlD | ControlD |
Fill right from cell left | CtrlR | ControlR |
Copy formula from cell above | Ctrl` | Control` |
Copy value from cell above | CtrlShift' | ControlShift' |
Add hyperlink | CtrlK | ⌘K |
Display AutoComplete list | Alt↓ | Option↓ |
Formatting | Windows | Mac |
Format (almost) anything | Ctrl1 | ⌘1 |
Display Format Cells with Font tab selected | CtrlShiftF | |
Apply format again | F4 | ControlY |
Apply or remove bold formatting | CtrlB | ⌘B |
Apply or remove italic formatting | CtrlI | ⌘I |
Apply or remove underscoring | CtrlU | ⌘U |
Apply or remove strikethrough formatting | Ctrl5 | ⌘ShiftX |
Add or remove the shadow font style | ⌘ShiftW | |
Add or remove the outline font style | ⌘ShiftD | |
Align center | AltHAC | ⌘E |
Align left | AltHAL | ⌘L |
Align right | AltHAR | ⌘R |
Indent | ⌘M | |
Remove indent | ⌘ShiftM | |
Increase font size one step | ⌘Shift> | |
Decrease font size one step | ⌘Shift< | |
Number Formatting | Windows | Mac |
Apply general format | CtrlShift~ | ControlShift~ |
Apply currency format | CtrlShift$ | ControlShift$ |
Apply percentage format | CtrlShift% | ControlShift% |
Apply scientific format | CtrlShift^ | ControlShift^ |
Apply date format | CtrlShift# | ControlShift# |
Apply time format | CtrlShift@ | ControlShift@ |
Apply number format | CtrlShift! | ControlShift! |
Borders | Windows | Mac |
Add border outline | CtrlShift& | ⌘Option0 |
Add or remove border right | AltR | ⌘Option→ |
Add or remove border left | AltL | ⌘Option← |
Add or remove border top | AltT | ⌘Option↑ |
Add or remove border bottom | AltB | ⌘Option↓ |
Add or remove border upward diagonal | AltD | |
Add or remove border horizontal interior | AltH | |
Add or remove border vertical interior | AltV | |
Remove borders | CtrlShift_ | ⌘Option_ |
Formulas | Windows | Mac |
Toggle absolute and relative references | F4 | ⌘T |
Open the Insert Function Dialog Box | ShiftF3 | FnShiftF3 |
Autosum selected cells | Alt= | ⌘ShiftT |
Toggle formulas on and off | Ctrl` | Control` |
Insert function arguments | CtrlShiftA | ControlShiftA |
Enter array formula | CtrlShiftEnter | ControlShiftReturn |
Calculate worksheets | F9 | F9 |
Calculate active worksheet | ShiftF9 | FnShiftF9 |
Force calculate all worksheets | CtrlAltF9 | |
Evaluate part of a formula | F9 | FnF9 |
Expand or collapse the formula bar | CtrlShiftU | ControlShiftU |
Display function arguments dialog box | CtrlA | ControlA |
Name Manager | CtrlF3 | ControlL |
Define name using row and column labels | CtrlShiftF3 | ControlShiftF3 |
Paste name into formula | F3 | |
Accept function with autocomplete | Tab | ↓Tab |
Pivot Tables | Windows | Mac |
Select entire pivot table | CtrlA | ⌘A |
Toggle pivot table field checkbox | Spacebar | Spacebar |
Group pivot table items | AltShift→ | ⌘ShiftK |
Ungroup pivot table items | AltShift← | ⌘ShiftJ |
Hide pivot table item | Ctrl- | Ctrl- |
Create pivot chart on same worksheet | AltF1 | |
Create pivot chart on new worksheet | F11 | FnF11 |
Workbook | Windows | Mac |
Insert new worksheet | ShiftF11 | ShiftF11 |
Go to next worksheet | CtrlPgDn | FnControl↓ |
Go to previous worksheet | CtrlPgUp | FnControl↑ |
Move to next pane | F6 | F6 |
Move to previous pane | ShiftF6 | ShiftF6 |
Go to next workbook | CtrlTab | ControlTab |
Go to previous workbook | CtrlShiftTab | ControlShiftTab |
Display control menu | AltSpacebar | |
Minimize current workbook window | CtrlF9 | ⌘M |
Maximize current workbook window | CtrlF10 | |
Dialog Boxes | Windows | Mac |
Move to next control | Tab | Tab |
Move to previous control | ShiftTab | ShiftTab |
Move to next tab | CtrlTab | ControlTab |
Move to previous tab | CtrlShiftTab | ControlShiftTab |
Accept and apply | Enter | Return |
Check and uncheck box | Spacebar | Spacebar |
Cancel and close the dialog box | Esc | Esc |
Grid Operations | Windows | Mac |
Display Insert Dialog box | CtrlShift+ | ControlI |
Insert rows | CtrlShift+ | ControlI |
Insert columns | CtrlShift+ | ControlI |
Display Delete dialog box | Ctrl- | Control- |
Delete rows | Ctrl- | Control- |
Delete columns | Ctrl- | Control- |
Delete cells | Ctrl- | Control- |
Delete contents of selected cells | Delete | FnDelete |
Hide columns | Ctrl0 | Control0 |
Hide rows | Ctrl9 | Control9 |
Unhide rows | CtrlShift9 | ControlShift9 |
Unhide columns | CtrlShift0 | ControlShift0 |
Group rows or columns | AltShift→ | ⌘ShiftK |
Ungroup rows or columns | AltShift← | ⌘ShiftJ |
Open Group Dialog Box | AltShift→ | ⌘ShiftK |
Open Ungroup Dialog Box | AltShift← | ⌘ShiftJ |
Hide or show outline symbols | Ctrl8 | Control8 |
VBA Editor | Windows | Mac |
Help | F1 | |
Object Browser | F2 | |
Find Next | F3 | |
Properies Window | F4 | |
Run | F5 | |
Switch Split Windows | F6 | |
Goto Window Of Object | F7 | |
Step | F8 | |
Breakpoint | F9 | |
Activate Menu Bar | F10 | |
Toggle Insert Mode | Insert | |
Delete | Delete | |
Beginning Of Line | Home | |
End Of Line | End | |
Page Up | PgUp | |
Page Down | PgDn | |
Left | ← | |
Right | → | |
Up | ↑ | |
Down | ↓ | |
Indent | Tab | |
New Line | Enter | |
Delete Prev Char | BackSpace | |
Procedure Definition | ShiftF2 | |
Find Prev | ShiftF3 | |
Find Next | F3 | |
Procedure Step | ShiftF8 | |
Quick Watch | ShiftF9 | |
Show Right Click Menu | ShiftF10 | |
Paste | ShiftInsert | |
Select To Start Of Line | ShiftHome | |
Select To End Of Line | ShiftEnd | |
Select To Top Of Module | ShiftPgUp | |
Select To End Of Module | ShiftPgDn | |
Extend Selection Left 1 Char | Shift← | |
Extend Selection Right 1 Char | Shift→ | |
Extend Selection Up | Shift↑ | |
Extend Selection Down | Shift↓ | |
Un-indent | ShiftTab | |
Focus To Object Box | CtrlF2 | |
Close Window | CtrlF4 | |
Run To Cursor | CtrlF8 | |
Activate Menu Bar | CtrlF10 | |
Select All Text | CtrlB | |
Copy | CtrlC | |
Export Module | CtrlE | |
Find | CtrlF | |
Immediate Window | CtrlG | |
Replace | CtrlH | |
Turn On Quick Info | CtrlI | |
List Members | CtrlJ | |
Show Call Stack | CtrlL | |
Import File | CtrlM | |
New Line | CtrlN | |
CtrlP | ||
Project Window | CtrlR | |
Save | CtrlS | |
Show Available Components | CtrlT | |
Paste | CtrlV | |
Cut | CtrlX | |
Cut Entire Line | CtrlY | |
Undo | CtrlZ | |
Copy | CtrlInsert | |
Delete To End Of Word | CtrlDelete | |
Top Of Module | CtrlHome | |
End Of Module | CtrlEnd | |
Top Of Current Procedure | CtrlPage Up | |
End Of Current Procedure | CtrlPage Down | |
Left Word | CtrlLeft Arrow | |
Right Word | CtrlRight Arrow | |
Previous Procedure | CtrlUp Arrow | |
Next Procedure | CtrlDown Arrow | |
Turn On Complete Word | CtrlSpacebar | |
Cycle Windows | CtrlTab | |
Delete To Start Of Word | CtrlBackSpace | |
Close VBE | AltF4 | |
Run Error Handler | AltF5 | |
Switch Between Last 2 Windows | AltF6 | |
Step Error Handler | AltF7 | |
Return To Application | AltF11 | |
Add-Ins Menu | AltA | |
Debug Menu | AltD | |
Edit Menu | AltE | |
File Menu | AltF | |
Help Menu | AltH | |
Insert Menu | AltJ | |
Format Menu | AltO | |
Close & Return | AltQ | |
Run Menu | AltR | |
Tools Menu | AltT | |
View Menu | AltV | |
Window Menu | AltW | |
System Menu | AltSpacebar | |
Cycle Applications | AltTab | |
Undo | AltBackSpace | |
Previous Position | CtrlShiftF2 | |
Clear All Breakpoints | CtrlShiftF9 | |
Turn On Param Info | CtrlShiftI | |
Turn On List Properties | CtrlShiftJ | |
Other | Windows | Mac |
Open Spelling dialog box | F7 | F7 |
Open Thesaurus dialog box | ShiftF7 | ShiftF7 |
Open Macro dialog box | AltF8 | FnOptionF8 |
Open VBA Editor | AltF11 | FnOptionF11 |
Duplicate object | CtrlD | ⌘D |
Snap to grid | Alt | ⌘ |
Hide or show objects | Ctrl6 | Control6 |
Display Modify Cell Style dialog box | Alt' | ⌘ShiftL |
In Microsoft Excel, the default action when pressing the Enter key is to move down to the next cell. However, when working with a cell containing multiple lines of text, it can be frustrating to create a new line. Below are the keyboard shortcut keys to make this task easy. Mac os x sftp client.
All latest versions of Microsoft Excel
All versions of Microsoft Excel for the PC and Mac now support the ability to press the keyboard shortcut Alt+Enter to move to the next line. To use this keyboard shortcut, type text in the cell. When ready for a new line, press and hold down the Alt key, then press the Enter key. The shortcut key can be used as many times as needed.
NoteAlt Shift In Mac
If you are on a Mac and the key shortcut above doesn't work, try Control+Option+Return.
TipInstead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel. Adobe premiere pro cc mac requirements.
Microsoft Excel in Windows
Alt Shift In Machine
On all versions of Microsoft Excel for the PC and Windows, the keyboard shortcut Alt+Enter moves to the next line. To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Alt key, then press the Enter key. The shortcut key can be used as many times as needed.
TipInstead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.
Early versions of Microsoft Excel for the Mac
On earlier versions of Excel for the Mac, the Alt+Enter keyboard shortcut does not work. To create a new line on the Mac, use the Control+Option+Return keyboard shortcut. To use this keyboard shortcut, type text in the cell and when ready for a new line, press and hold down the Control key, Option key, and Return key. The shortcut key can be used as many times as needed.
Alt Shift In Macomb
TipInstead of adding a note or lots of text in a cell, create a comment to make the spreadsheet look cleaner. For help creating a comment, see: How to create, edit, and delete a comment in Microsoft Excel.
Alt Shift Language In Mac
Additional information
Alt Shift In Machu
- See our cell and new line definitions for further information and related links.