Microsoft Excel On Mac Keyboard Shortcuts
.Cannot be combined with any other offerTerms and conditions apply; see full agreement'Microsoft Military Discounts and SavingsMilitary personnel are the men and women who keep us safe and allow us to breathe easy. Microsoft office for mac military appreciation edition.
Below is a huge list of Excel keyboard shortcuts you can use to work faster. Scroll through the list or use the Index to quickly go to the section you want. How To Read The List Where shortcut keys must be pressed together they will be shown like this Ctrl + P which means press CTRL and P together. Keyboard Shortcuts to use with a Macintosh Computer. 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. Commonly used keyboard combinations.
Table of contents
Worksheets and WorkbooksViewRow and Column SelectionRibbon ControlPivot TablesOperating within a CellNavigating and Selecting CellsHelp and MenusGroup Selection General ExcelGeneral Cell ControlFormulas and FunctionsFormatting Text and NumbersDialog BoxesBordersAdvanced Selection Adding Content to CellsWorksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
Worksheets and Workbooks
Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.
View
Row and Column Selection
Ribbon Control
Pivot Tables
Operating within a Cell
Navigating and Selecting Cells
Help and Menus
Group Selection
General Excel
General Cell Control
Formulas and Functions
Formatting Text and Numbers
Dialog Boxes
Borders
Advanced Selection
Adding Content to Cells
Get more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.
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.Commonly used keyboard combinations
To use one of these combinations Hold the Command (Apple) key down and strike the letter keyOpen 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 Download os x el capitan. With the release of macOS 10.15 Catalina,Office 365 for Mac and Office 2019 for Mac support macOS 10.15, 10.14, and 10.13. Moving forward, as new major versions of macOS are made generally available, Microsoft will drop support for the oldest version and support the newest and previous two versions of. Jan 13, 2016 Support Communities / Mac OS & System Software / OS X El Capitan Announcement: Upgrade to macOS Catalina Experience dedicated apps for music, TV, and podcasts, plus smart new features like Sidecar. I have all my info on old Mac in Microsoft Word. Was going to purchase Word program & download onto new Mac but i've been told it. Jul 30, 2019 Download Mac OS X El Capitan 10.11.6 free latest version standalone offline bootable DMG image setup for Apple Macintosh. The Mac OS X El Capitan 10.11 is among the latest Apple Operating System with greater security and better performance. Mar 19, 2020 I can download the office 365 pkg file under my corporate account, but when I try to instal I get the message I can't in the version of OSX that I have. El Capitan is the terminal OSX version for my laptop. Office version I am trying to instal is MicrosoftOffice0901I. Thanks for your help. Oct 24, 2019 Mac Pro introduced in early 2008 or later Xserve models introduced in early 2009. To find your Mac model, memory, storage space, and macOS version, choose About This Mac from the Apple menu. If your Mac isn't compatible with OS X El Capitan, the installer will let you know. |
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. | 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)
Download Excel On Mac
| 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 | |||||
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.
Microsoft Excel On Mac Keyboard Shortcuts Windows 10
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