Microsoft Excel On Mac Keyboard Shortcuts

Sep 19, 2012 One way to get up to speed on this fast is to use a keyboard cover such as which overlays the shortcut keys onto your laptop keyboard. Even users with a basic know-how of Excel can become more efficient by learning keyboard shortcuts. Shortcut keys are most useful and powerful way to save the time. The Microsoft Excel 2011 Keyboard Shortcuts help to provide an easier and usually quicker method of directing and finishing commands. Excel Shortcuts PC Mac. Cheat sheet of the most important Excel keyboard shortcuts to be familiar with. Home › Resources › Excel Resources › Shortcuts › Excel Shortcuts PC Mac. It may seem slower at first if you’re used to the mouse, but it’s worth the investment to take the time and learn these important shortcuts.

Download Excel On Mac
Microsoft Excel On Mac Keyboard Shortcuts List
Excel Mac Keyboard Shortcuts
Microsoft Excel On Mac
Microsoft Excel On Mac Keyboard Shortcuts Mac

You can avoid reaching for the mouse if you are familiar with keyboard shortcuts. If you forget one of these, use the mouse and go to the menu bar. In each pull down menu you will see keyboard commands given in the right side of the window.
Microsoft Excel On Mac Keyboard Shortcuts

Microsoft Excel On Mac Keyboard Shortcuts

Commonly used keyboard combinations

To use one of these combinations Hold the Command (Apple) key down and strike the letter key

Open a new workbook quickly.	Cut- Removes the selection from the active document and places it on the clipboard.
Opens a previously saved document.	Copies the selection to the clipboard
Closes the active window, but does not Exit Excel.	Paste - Inserts the contents of the clipboard at the insertion point (cursor) or whatever is selected.
Saves the active document with its current file name, location and format.	Selects all on the active worksheet.
Prints the active file, also gives the opportunity to change print options	Find - Searches for specified text in the active document
Exit - Closes Microsoft Excel.	Bold - Formats selected text; make text bold, or remove bold formatting
Undo the last action. This selection can be repeated several times.	Italic - Formats selected text; make text italic or remove italic
Redo - After an action has been undone, it can be reinstated in the document. Excel for Office 365 for MacIf you're an Office 365 subscriber, and have signed up for the Insiders Program, then you can refresh existing Power Query queries on your Mac for connections to Text, CSV, XLSX, XML and JSON files. The refresh functionality is live for all Office Insiders Fast customers in Excel for Mac, version 16.26 (19052200) and later. SQL Server connections are refreshable in version 16.35.218.0 and later. Excel 2011 and Excel 2016 for MacGet & Transform (Power Query) is not supported. Excel for Android, iOS and OnlineGet & Transform (Power Query) is not supported. Quickbooks for mac.	Underline - Formats selected text; make text underlined or remove underline

Less commonly used keyboard combinations
(Note: To save space below, the control key is indicated by Ctrl)

Select the next sheet in the workbook	Select the previous sheet in the workbook	Move to the previous workbook or window
Complete a cell entry and move to the right in the selection	Complete a cell entry and move to the left in the selection	Create a chart that uses the current range
Insert a new worksheet	Start a new line in the same cell	Complete a cell entry and move down in the selection
Move to the next workbook or window	Start a formula	Cancel a cell entry
In print preview, move to the first page when zoomed out	In print preview, move to the last page when zoomed out	In print preview, move to the last page when zoomed out
In print preview, move to the first page when zoomed out	Complete a cell entry and move up in the selection	Move between unlocked cells on a protected worksheet
Apply the outline border	Remove outline borders	Apply the outline border
Remove outline borders	Select the entire row	Select the entire column
In a cell with a hyperlink, this activates the hyperlink	Enter the time	Enter the date
Insert a hyperlink	Fill down	Fill to the right
Apply the percentage format	Apply the currency format	Select the current region around the active cell
Hide rows	Hide columns	Insert the AutoSum formula
Unhide rows	Unhide columns	Show, or hide, the Standard toolbar
Complete a cell entry and move up in the selection	Displays all formulas in a worksheet, repeat to hide	Create names from row and column labels
If text is already selected and you want to extend the selection area
Extend selection one character to the left in the formula bar, or one cell to the left in the worksheet		Extend selection one character to the right in the formula bar, or one cell to the right in the worksheet
Extend selection to the last non blank cell to the right or above a selected cell.		Extend selection to the to the last non blank cell to the left or below a selected cell
If you want to move the cursor
Microsoft. One character to the right in the formula bar or one cell to the right in the worksheet		One character to the left in the formula bar or one cell to the left in the worksheet
One word to the right in the formula bar		One word to the left in the formula bar
To the end of a document or to the right edge of the formula bar		To the beginning of a document or to the left edge of the formula bar
This list is by no means complete. To find other keyboard combinations check the Excel help index.

Assignment

Leave your browser window open. Open Microsoft Excel, if it is not already open.
From this point forward, do not use your mouse

1. Open a new workbook .
2. Insert a new worksheet into the workbook
3. Move to sheet 2
4. Move your cursor to cell D4
5. Type your name and press the Enter key
6. Move back into cell D4 and Copy your name
7. Move from sheet 2 to sheet 4
8. Move your cursor into cell E5
9. Paste your name
10. Hide the column your name is in
11. ( deserved , but not required ) Pat yourself on the back!

Each of the steps in the list above should have been accomplished without the use of your mouse. If you reached for the rodent, review the two tables above, go back to step 1 and try again. Good luck.

External Links

Excel PC and Mac Keyboard Shortcuts - This page lists PC and Mac shortcuts side by side

A Macintosh Keyboard is available showing general Macintosh keyboard shortcuts

1. Frequently used shortcuts
⌘+V or Ctrl+V	Paste
⌘+C or Ctrl+C	Copy
Delete	Clear
⌘+S or Ctrl+S	Save
⌘+Z or Ctrl+Z	Undo
⌘+Y or Ctrl+Y	Redo
⌘+X or Ctrl+X	Cut
⌘+B or Ctrl+B	Bold
⌘+P or Ctrl+P	Print
Option+F11	Open Visual Basic
⌘+D or Ctrl+D	Fill Down
⌘+R or Ctrl+R	Fill Right
Ctrl+Shift+=	Insert cells
⌘+- or Ctrl+- (hyphen)	Delete cells
⌘+= or F9	Calculate all open workbooks
⌘+W or Ctrl+W	Close window
⌘+Q	Quit Excel
Ctrl+G or F5	Display the Go To dialog box
⌘+1 or Ctrl+1	Display the Format Cells dialog box
Ctrl+H or ⌘+Shift+H	Display the Replace dialog box
⌘+Ctrl+V or Ctrl+Option+V	Paste Special
⌘+U	Underline
⌘+I or Ctrl+I	Italic
⌘+N or Ctrl+N	New blank workbook
⌘+Shift+P	New workbook from template
⌘+Shift+S or F12	Display the Save As dialog box
F1 or ⌘+/	Display the Help window
⌘+A or ⌘+Shift+Space	Select All
⌘+Shift+F or Ctrl+Shift+L	Add or remove a filter
⌘+Option+R or Ctrl+O	Minimize or maximize the ribbon tabs
⌘+O	Display the Open dialog box
F7	Check spelling
Shift+F7	Open the thesaurus
Shift+F3	Display the Formula Builder
⌘+F3	Open the Define Name dialog box
⌘+Shift+F3	Open the Create names dialog box
Shift+F11	Insert a new sheet *
⌘+P or Ctrl+P	Print
⌘+P or Ctrl+P	Print preview
Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts. This topic flags such shortcuts with an asterisk ( ). To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.

Download Excel On Mac

▲ up

2. Work in windows and dialogs
⌘+Option+R	Expand or minimize the ribbon
⌘+Ctrl+F	Switch to full screen view
⌘+Tab	Switch to the next application
⌘+Shift+Tab	Switch to the previous application
⌘+W	Close the active workbook window
⌘+Shift+3	Copy the image of the screen and save it to a Screen Shot file on your desktop.
Ctrl+F9	Minimize the active window
Ctrl+F10 or ⌘+F10	Maximize or restore the active window
⌘+H	Hide Excel.
Tab	Move to the next box, option, control, or command
Shift+Tab	Move to the previous box, option, control, or command
Esc	Exit a dialog or cancel an action
Enter	Perform the action assigned to the default command button (the button with the bold outline, often the OK button)
Esc	Cancel the command and close

▲ up

3. Move and scroll in a sheet or workbook
Arrow Keys	Move one cell up, down, left, or right
⌘+Arrow Key	Move to the edge of the current data region
Home	Move to the beginning of the row
Ctrl+Home	Move to the beginning of the sheet
Ctrl+End	Move to the last cell in use on the sheet
Page Down	Move down one screen
Page Up	Move up one screen
Option+Page Down	Move one screen to the right
Option+Page Up	Move one screen to the left
Ctrl+Page Down or Option+Arrow Right	Move to the next sheet in the workbook
Ctrl+Page Down or Option+Arrow Left	Move to the previous sheet in the workbook
Ctrl+Delete	Scroll to display the active cell
Ctrl+G	Display the Go To dialog box
Ctrl+F or Shift+F5	Display the Find dialog box
⌘+F	Access search (when in a cell or when a cell is selected)
Tab	Move between unlocked cells on a protected sheet

▲ up

4. Enter data on a sheet
F2	Edit the selected cell
Enter	Complete a cell entry and move forward in the selection
Ctrl+Option+Enter	Start a new line in the same cell
⌘+Return or Ctrl+Enter	Fill the selected cell range with the text that you type
Shift+Enter	Complete a cell entry and move up in the selection
Tab	Complete a cell entry and move to the right in the selection
Shift+Tab	Complete a cell entry and move to the left in the selection
Esc	Cancel a cell entry
Delete	Delete the character to the left of the insertion point, or delete the selection
Delete the character to the right of the insertion point, or delete the selection
On a MacBook, pressFn+Delete	Note: Some smaller keyboards do not have this key
Note: Some smaller keyboards do not have this key
Arrow Keys	Move one character up, down, left, or right
Home	Move to the beginning of the line
Shift+F2	Insert a comment
Shift+F2	Open and edit a cell comment
Ctrl+D or ⌘+D	Fill down
Ctrl+R or ⌘+R	Fill to the right
Ctrl+L	Define a name

▲ up

5. Work in cells or the Formula bar
F2	Edit the selected cell
Delete	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
Enter	Complete a cell entry
⌘+Shift+Return or Ctrl+Shift+Enter	Enter a formula as an array formula
Esc	Cancel an entry in the cell or formula bar
Ctrl+A	Display the Formula Builder after you type a valid function name in a formula
⌘+K or Ctrl+K	Insert a hyperlink
Ctrl+U	Edit the active cell and position the insertion point at the end of the line
Shift+F3	Open the Formula Builder
Shift+F9	Calculate the active sheet
Shift+F10	Display a contextual menu
=	Start a formula
⌘+T or F4	Toggle the formula reference style between absolute, relative, and mixed
⌘+Shift+T	Insert the AutoSum formula
Ctrl+; (semicolon)	Enter the date
⌘+; (semicolon)	Enter the time
Ctrl+Shift+' (inchmark)	Copy the value from the cell above the active cell into the cell or the formula bar
Ctrl+` (grave accent)	Alternate between displaying cell values and displaying cell formulas
Ctrl+' (apostrophe))	Copy a formula from the cell above the active cell into the cell or the formula bar
Ctrl+Option+Arrow Down	Display the AutoComplete list
Ctrl+L	Define a name
Ctrl+Option+⌘+L	Open the Smart Lookup pane

▲ up

6. Format and edit data
F2	Edit the selected cell
⌘+T or Ctrl+T	Create a table
⌘+Option+Return or Ctrl+Option+Enter	Insert a line break in a cell
Ctrl+Spacebar or ⌘+Space	Insert special characters like symbols, including emoji
⌘+Shift+>	Increase font size
⌘+Shift+<	Decrease font size
⌘+E	Align center
⌘+L	Align left
⌘+Shift+L	Display the Modify Cell Style dialog box
⌘+1	Display the Format Cells dialog box
Ctrl+Shift+~	Apply the general number format
Ctrl+Shift+$	Apply the currency format with two decimal places (negative numbers appear in red with parentheses)
Ctrl+Shift+%	Apply the percentage format with no decimal places
Ctrl+Shift+^	Apply the exponential number format with two decimal places
Ctrl+Shift+#	Apply the date format with the day, month, and year
Ctrl+Shift+@	Apply the time format with the hour and minute, and indicate AM or PM
Ctrl+Shift+!	Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values
⌘+Option+0	Apply the outline border around the selected cells
⌘+Option+Arrow Right	Add an outline border to the right of the selection
⌘+Option+Arrow Left	Add an outline border to the left of the selection
⌘+Option+Arrow Up	Add an outline border to the top of the selection
⌘+Option+Arrow Down	Add an outline border to the bottom of the selection
⌘+Option+- (hyphen)	Remove outline borders
⌘+B	Apply or remove bold formatting
⌘+I	Apply or remove italic formatting
⌘+U	Apply or remove underscoring
⌘+Shift+X	Apply or remove strikethrough formatting
⌘+) or Ctrl+)	Hide a column
⌘+Shift+) or Ctrl+Shift+)	Unhide a column
⌘+( or Ctrl+(	Hide a row
⌘+Shift+( or Ctrl+Shift+(	Unhide a row
Ctrl+U	Edit the active cell
Esc	Cancel an entry in the cell or the formula bar
Delete	Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
⌘+V	Paste text into the active cell
Enter	Complete a cell entry
⌘+Return or Ctrl+Enter	Give selected cells the current cell's entry
⌘+Shift+Return or Ctrl+Shift+Enter	Enter a formula as an array formula
Ctrl+A	Display the Formula Builder after you type a valid function name in a formula

▲ up

7. Select cells, columns, or rows
Shift+Arrow Key	Extend the selection by one cell
⌘+Shift+Arrow Key	Extend the selection to the last nonblank cell in the same column or row as the active cell
Shift+Home	Extend the selection to the beginning of the row
Ctrl+Shift+Home	Extend the selection to the beginning of the sheet
Ctrl+Shift+End	Extend the selection to the last cell used on the sheet (lower-right corner)
Ctrl+Space	Select the entire column
Shift+Space	Select the entire row
⌘+A	Select the entire sheet
⌘+Shift+* (asterisk)	Select only visible cells
Shift+Delete	Select only the active cell when multiple cells are selected
Shift+Page Down	Extend the selection down one screen
Shift+Page Up	Extend the selection up one screen
Ctrl+6	Alternate between hiding objects, displaying objects, and displaying placeholders for objects
F8	Turn on the capability to extend a selection by using the arrow keys
Shift+F8	Add another range of cells to the selection
Ctrl+/	Select the current array, which is the array that the active cell belongs to.
Ctrl+	Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
Ctrl+Shift+[	Select only cells that are directly referred to by formulas in the selection
Ctrl+Shift+{	Select all cells that are directly or indirectly referred to by formulas in the selection
Ctrl+]	Select only cells with formulas that refer directly to the active cell
Ctrl+Shift+}	Select all cells with formulas that refer directly or indirectly to the active cell

▲ up

8. Work with a selection
⌘+C or Ctrl+C	Copy
⌘+V or Ctrl+V	Paste
⌘+X or Ctrl+X	Cut
Delete	Clear
Ctrl+- (hyphen)	Delete the selection
⌘+Z	Undo the last action
⌘+) or Ctrl+)	Hide a column
⌘+Shift+) or Ctrl+Shift+)	Unhide a column
⌘+( or Ctrl+(	Hide a row
⌘+Shift+( or Ctrl+Shift+(	Unhide a row
Enter	Move from top to bottom within the selection (down)*
Shift+Enter	Move from bottom to top within the selection (up)*
Tab	Move from left to right within the selection, or move down one cell if only one column is selected
Shift+Tab	Move from right to left within the selection, or move down one cell if only one column is selected
Ctrl+. (period)	Move clockwise to the next corner of the selection
⌘+Shift+K	Group selected cells
⌘+Shift+J	Ungroup selected cells
*These shortcuts may move in another direction other than down or up. If you'd 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.

▲ up

9. Use charts
F11	Insert a new chart sheet.
ArrowKeys	Cycle through chart object selection

▲ up

10. Sort, filter, and use PivotTable reports
⌘+Shift+R	Open the Sort dialog box
⌘+Shift+F or Ctrl+Shift+L	Add or remove a filter
Option+Arrow Down	Display the Filter list or PivotTable page field pop-up menu for the selected cell