• Shortcut Key For Strikethrough Mac Excel
• Shortcut Keys For Excel Machine Learning
• Shortcut Keys For Excel Macros
• Shortcut Keys For Excel Macro
• Excel Shortcuts On Mac Keyboard

Top 5 Excel keyboard shortcuts. KeyCuts Blog - March 11, 2019 on the KeyCuts blog about keyboard shortcuts. One of the more popular ones is this one about the top 5 keyboard shortcuts in Mac Excel. A lot of people think you can only use keyboard shortcuts on the PC, but fear not–they also. Excel keyboard shortcuts – Microsoft Excel keyboard shortcuts for PC and Mac. Shortcuts of File, Ribbon, Drag and Drop, Active Cell, General, General Continued, Selection, Navigation, Extend. Apr 26, 2020 The use case scenario for Excel differs from person to person. We won’t be talking about the most common keyboard shortcuts for editing and manipulating text, instead, we will focus on Mac keyboard shortcuts that improve your Excel experience. Let’s get started. The Best Microsoft Excel Keyboard Shortcuts for macOS 1. Show/Hide Ribbon. A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Windows shortcuts in dark gray on the left, Mac shortcuts in white on the right.

.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 don't have to press the FN key every time you use a function key shortcut.

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. 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.

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.

Shortcut Key For Strikethrough Mac Excel

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
Print	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

Many of you are transitioning to Excel for the Mac, and have asked us what our favorite Excel Mac shortcuts are. While our keyboard covers show the 20 most commonly used shortcuts, there are definitely a few gems that really make using Excel on the Mac that much better than the PC. That’s right…I said it…Excel for the Mac is better than the PC!

Here are the Top 5:

1) Increase/Decrease Font Size – SHIFT+COMMAND+. (increase)SHIFT+COMMAND+, (decrease)

The reason why this is the best Mac Excel shortcut is because it doesn’t even exist on the PC! Quickly increase and decrease the font size without going through the Format Cells menu or clicking on the pesky font size drop-down in the toolbar.

2) Delete Everything in Selected Cells – FN+DELETE

Why is it so hard to delete stuff in Excel for the Mac? Press fn+delete and you’ll actually delete everything in your selection and the delete button actually works like it’s intended to work.

3) Create Filter – SHIFT+COMMAND+F

You have a list of data and you need to create a filter. Instead of going through the regular toolbar, navigate to the first row with the field names in your list and hit shift+command+f. Simple.

Shortcut Keys For Excel Machine Learning

4) Center Align Data – COMMAND+E

You have a bunch of cells with data and they are all weirdly aligned. Some are right-aligned and some are left-aligned. The reason why this shortcut is so powerful is because it’s SO EASY to use! There is no equivalent on the PC; the PC shortcut is ALT, H, A, C! Definitely a lot simpler to hit command+e in my opinion!

5) Autosum a Bunch of Numbers – SHIFT+COMMAND+T

We’ve all had to type =SUM(blah blah blah) before to sum a bunch of numbers. This handy shortcut let’s you create the sum automatically without having to type in the formula! Just go to the empty cell below a bunch of numbers you want to sum and hit shift+command+t and Excel automatically knows which cells you want to sum!

Shortcut Keys For Excel Macros

In conclusion, Excel for the Mac is pretty powerful…

Shortcut Keys For Excel Macro

Excel Shortcuts On Mac Keyboard

Which Excel for Mac shortcuts do you use every day? Best twitter app for mac. Which Excel shortcuts on the PC do you wish existed on the Mac?