Microsoft Excel for Macbook Download {UPDATED}
Microsoft Excel for Mac is the world’s most famous and widely used spreadsheet editing application. Originally developed by the Microsoft in 1987, this software received numerous expansions of capabilities, making it the go-to source for spreadsheet editing, use of graphing tools, pivot tables, macro programming, and much more. Available today on all modern platforms, including Windows, MacOS, Android and iOS, today this app is used by hundreds of millions of people each day. Since 1990, Microsoft Excel for macOS can be found as a part of the Microsoft Office, a suite of document, presentation and email editing applications covering all usage scenarios needed in a modern collaborative working environment.
MS Excel for Mac Download
It is very hard to quickly review software so powerful, versatile, ubiquitous, and genre-defining as MS Excel for Mac. Regarded as the gold standard for spreadsheet creation and analysis, MS Excel to this day outmatches all competition with its wide array of tools and powerful advanced features that satisfy the needs of everyone, from first-time spreadsheet users to largest corporations who are interested in analytics and integrated forecasting functions. Its versatility enables effortless integration into workflows for managing countless tasks, including but not limited to, document creation, budgeting, personal finance, tax record management, small business document management, student/research analysis, and extensive needs of government agencies, non-profit organizations and largest corporations on the planet.
Even though it is filled to the brim with tools and services, the user interface of the MSExcel is as intuitive as ever, providing easy access to every one of its functions via tabbed toolbars on the top of the window, right-click cell menus and powerful configuration tools in the main setting window. Longtime users will have no trouble adapting to the latest version of the app, only really needing to get accustomed to the newly introduced integration into the Office 365 online suite that enables effortless online collaboration and document sharing.
Features and Highlights
- Effortless Spreadsheet creation – Manage spreadsheets of all sizes, from personal or school documents to government databases.
- Extensive toolset – Take advantage from most advanced toolset present in modern spreadsheet software, including advanced formulas, pivot tables, lookup formulas, charts, sorting & filtering data, conditional formatting, structural references, data explorer, data analysis, VBA, macros, automation and much more.
- Analytics – Gain valuable insights from built-in analytics tools.
- Audit Trail – Track changes in audit files using the integrated Review and Track Changes tools.
- Advanced calculations – Take financial and data analysis to a whole new level.
- Charting – Visualize data with a wide array of charts that can be exported to other apps from Office suite.
- Multi-user collaboration – Office 365 integration enables all users of Excel to easily share their documents and collaborate.
- Templates – Simplify document creation with powerful and customizable template offering.
Microsoft Office 365 for Mac: Get Word, Excel, PowerPoint, and others in App Store
For Apple enthusiasts who want to use Microsoft’s Office software on a Mac, iPad, or iPhone, you can easily download the full Office 365 bundle, or any of its individual apps, from the Mac App Store. The Office 365 bundle includes six apps: Excel, PowerPoint, OneDrive, OneNote, Outlook, and Word, each of which can also be downloaded individually. There is a free one-month trial for Office 365, after which the subscription is $69.99 a year, or $6.99 a month. If you already have an Office 365 subscription, you can use it here. As part of the subscription software updates are applied automatically as they’re rolled out.
In a press release from Apple, VP Phil Schiller said, “Apple and Microsoft have worked together to bring great Office productivity to Mac users from the very beginning. Now, with Office 365 on the Mac App Store, it’s easier than ever to get the latest and best version of Office 365 for Mac, iPad and iPhone.”
Highlights
- Unmistakably Office, designed for Mac – MacBook Pro Touch Bar is fully supported by Microsoft Excel. If you type an equals sign into a cell, Excel will immediately pull up the most recently used functions in the Touch Bar. Go easy on your eyes with Dark Mode. Excel makes it easier to view your spreadsheets in low-light environments by supporting Dark Mode for macOS Mojave
- Create, calculate and analyse with confidence – jump-start your budget, task list, accounting or financial analysis with Excel’s modern templates. Use familiar formulas to run calculations and analyse your data. Rich features and formatting options make your workbook easier to read and use. All spreadsheet features, formats and formulas operate the same way – whatever device you use.
- Get a better picture of your data – new charts and graphs help you present your data in compelling ways, with formatting, sparklines and tables to better understand your data. Easily create forecasts with just a click to predict trends
- Turn data into insights – enhanced by intelligence, Excel learns your patterns, organising your data to save you time. Create spreadsheets with ease from templates or on your own and perform calculations with modern formulas
- Work better together – share your workbook with others and always work on the latest version for real-time collaboration to help get work done faster. With Office 365, work within an Excel file from mobile, desktop and web
Is Excel for Mac free?
Microsoft Excel and can be purchased for $139.99 or is part of Office 365 which offers you a 1-month trial and includes: Excel, PowerPoint, OneDrive, Skype, Outlook, and Word for $69.99 a year.
If you only need Excel, purchasing it is the better option for you but most want access to the other apps and elect to use the subscription option.
The powerful Excel spreadsheet app lets you create, view, edit, and share your files with others quickly and easily. It also lets you view and edit workbooks attached to email messages. Work in accounting, auditing, finance, or other fields, with anyone, anywhere with confidence. With Excel, your Office moves with you and can implement the most complex formulas, with amazing features.
Microsoft Excel Shortcuts for Mac and Windows
So, here is Microsoft Excel shortcuts key, but before moving to our main title, let’s know about Microsoft Excel. moreover, Excel is a spreadsheet developed by Microsoft for Windows, macOS, iOS and Android devices. however, the main features of Excel are Calculation, Pivot table, Graphic tool and etc…
Note: ✔ These Excel shortcuts are for both Windows and Mac.
✔ Ms. Excel shortcuts work on MS. Excel 2003. MS. Excel 2007, MS Excel 2010 and MS. Excel 2013 versions.
Microsoft Excel Shortcuts key
File
Windows |
Mac | Action |
Ctrl + N | ⌘ + N |
To create new workbook
|
Ctrl + O | ⌘+ O | To open workbook |
Ctrl + S | ⌘ + S | Save workbook |
F12 | ⌘ + ⇧ + S | Save “as” |
Ctrl + P | ⌘ + P | Print file |
Ctrl + F2 | Close the running workbook | Open print preview window |
Ctrl + F4 | ⌘ + W | Close current workbook |
Ribbon |
⌘ + Q | Close Excel |
Ctrl + F1 | ⌘ + ⌥ + R | Expand or collapse ribbon |
Tab | Tab | Move to next ribbon control |
Space | Space | Activate or open selected control |
Enter | Return | To confirm control change |
General |
⌘ + / | Open help |
Ctrl + Z | ⌘ + Z | Undo last action |
Ctrl + Y | ⌘ + Y | Redo last action |
Ctrl + C | ⌘ + C | Copy selected cells |
F4 | ⌘ + Y | Repeat last action |
Ctrl + X | ⌘ + X | Cut selected cells |
Ctrl + V | ⌘ + V | To paste content from clipboard |
Ctrl + Alt + V | ⌃ + ⌘ + V | Display the Paste Special dialog box |
Ctrl + F | ⌘ + F | Display find and replace |
Ctrl + H | ⌃ + H | Display find and replace selected |
Shift + F4 | ⌘ + G | Find next match |
Ctrl + Shift + F4 | ⌘ + ⇧ + G | Find previous match |
Alt + F1 | Fn + ⌥ + F1 | Create embedded chart |
F11 | Fn + F11 | Create chart in new worksheet |
Ctrl + Shift + L | ⌘ + ⇧ + F | Toggle Autofilter |
Alt + ↓ | ⌥ + ↓ | Activate filter |
Tables and Filters |
⌃ + T | Insert table |
Shift + Space | ⇧ + Space | Select table row |
Ctrl + Space | ⌃ + Space | Select table column |
Ctrl + A | ⌘ + A | Select table |
Drag and Drop |
Drag | Drag and cut |
Ctrl + Dg | ⌥ + Drag | To copy, drag |
Shift+ Dg | ⇧ + Dg | insert |
Ctrl + Shift + Dg | ⌥ + ⇧ + Dg | insert copy |
Alt + Dg | ⌘ + Drag | Drag to worksheet |
Ctrl + Drag | ⌥ + Drag | Duplicate worksheet |
|
→ | Move one cell right |
↑ | ↑ | Move one cell up |
← | ← | Move one cell left |
↓ | ↓ | Move one cell down |
Alt + Page Down | Fn + ⌥ + ↓ | Move one screen right |
Alt + Page Up | Fn + ⌥ + ↑ |
Move one screen left
|
Page Up | Fn + ↑ | Move one screen up |
Page Down | Fn + ↓ | Move one screen down |
Ctrl + → | ⌃ + → | Move to right edge of data region |
Ctrl + ← | ⌃ + ← | Move to left edge of data region |
Ctrl + ↑ | ⌃ + ↑ | Move to top edge of data region |
Ctrl + ↓ | ⌃ + ↓ |
Move to bottom edge of data region |
Home | Fn + ← | Move to beginning of row |
Ctrl + Home | Fn + ⌃ + ← | Move to first cell in worksheet |
End | Fn + → | Turn End mode on |
Selection |
⇧ + Space | Select entire row |
Ctrl + A |
⌘ + A | Select entire worksheet |
Shift + Click | ⇧ + Click | Add adjacent cells to selection |
Ctrl + Click | ⌘ + Click | Add non-adjacent cells to selection |
Ctrl + Alt + → | ⌃ + ⌥ + → | Move right between non-adjacent selections |
Ctrl + Alt + ← | ⌃ + ⌥ + ← | Move left between non-adjacent selections |
Shift + F8 | Fn + ⇧ + F8 | Toggle add to selection mode |
Escape | Escape | Cancel selection |
Active Cell |
⇧ + Delete | Select active cell only |
Ctrl + Backspace | ⌘ + Delete | Show the active cell on worksheet |
Ctrl + . | ⌃ + . | Move active cell clockwise in selection |
Enter | Return | Move active cell down in the selection |
Shift + Enter | ⇧ + Return | Move active cell up in the selection |
Tab | Tab | Move active cell up in a selection |
Shift + Tab | ⇧ + Tab | Move active cell left in a selection |
Extend Selection |
⇧ + → | Extend selection by one cell right |
Shift + ← | ⇧ + ← | Extend selection by one cell left |
Shift + ↓ | ⇧ + ↓ | Extend selection by one cell down |
Shift + ↑ | ⇧ + ↑ | Extend selection by one cell up |
Ctrl + Shift + → | ⌃ + ⇧ + → | Extend the selection to the last cell right |
Ctrl + Shift + ↑ | ⌃ + ⇧ + ↑ | Extend the selection to the last cell up |
Ctrl + Shift + ← | ⌃ + ⇧ + ← | Extend the selection to the last cell left |
Ctrl + Shift + ↓ | ⌃ + ⇧ + ↓ | Extend the selection to the last cell down |
Shift + Page Up | Fn + ⇧ + ↑ | Extend selection up one screen |
Shift + Page Down | Fn + ⇧ + ↓ | Extend selection down one screen |
Alt + Shift + Page Up | Fn + ⇧ + ⌘ + ↑ | Extend selection left one screen |
Alt + Shift + Page Down | Fn + ⇧ + ⌘ + ↓ | Extend selection right one screen |
Shift + Home | Fn + ⇧ + ← | Extend selection to start of row |
Ctrl + Shift + Home |
Fn + ⌃ + ⇧ + ← | Extend selection to first cell in worksheet |
Ctrl + Shift + End | Fn + ⌃ + ⇧ + → | Extend selection to last cell in worksheet |
F8 | Fn + F8 | Toggle extend selection mode |
Select Special |
⌃ + G | Display ‘Go To’ dialog box |
Ctrl + Shift + O | Fn + ⌃ + ⇧ + O | Select cells with comments |
Ctrl + A | ⌘ + A | Select current region |
Ctrl + / | ⌃ + / | Select current array |
Ctrl + \ | ⌃ + \ | Select row differences |
Ctrl + Shift + | | ⌃ + ⇧ + | | Select column differences |
Ctrl + [ | ⌃ + [ | Select direct precedents |
Ctrl + Shift + { | ⌃ + ⇧ + { | Select all precedents |
Ctrl + ] | ⌃ + ] | Select direct dependents |
Ctrl + Shift + } | ⌃ + ⇧ + } | Select direct dependents |
Alt + ; | ⌘ + ⇧ + Z | Select visible cells only |
Cell edit mode |
⌃ + U | Edit the active cell |
Shift + F2 | Fn + ⇧ + F2 | Insert or edit comment |
Escape | Escape | Cancel entry |
Shift + → | ⇧ + → | Select one character right |
Shift + ← | ⇧ + ← | Select one character left |
Ctrl + → | ⌃ + → | Move one word right |
Ctrl + ← | ⌃ + ← | Move one word left |
Ctrl + Shift + → | ⌃ + ⇧ + → | Select one word right |
Ctrl + Shift + ← | ⌃ + ⇧ + ← | Select one word left |
Shift + Home | Fn + ⇧ + ← | Select to beginning of cell |
Shift+ End | Fn + ⇧ + → | Select to end of cell |
Ctrl + Delete | ⌃ + Delete | Delete to end of line |
Backspace | Delete | remove character to the left of cursor |
Delete | Fn + Delete | Delete character to the right of cursor |
Alt + Enter | ⌃ + ⌥ + Return | Start a new line in the same cell |
Entering data |
Return | Enter and move down |
Shift + Enter | ⇧ + Return | Enter and move up |
Tab | Tab | Enter and move right |
Shift + Tab | ⇧ + Tab | Enter and move left |
Ctrl + Enter | ⌃ + Return | Complete entry and stay in same cell |
Ctrl + ; | ⌃ + ; | Complete entry and stay in same cell |
Ctrl + Shift + : | ⌃ + ⇧ + : | Insert current time |
Ctrl + D | ⌃ + D | Fill down from cell above |
Ctrl + R | ⌃ + R | Fill right from cell left |
Ctrl + ‘ | ⌃ + ‘ | Copy formula from cell above |
Ctrl + Shift + “ | ⌃ + ⇧ + “ | Copy value from cell above |
Ctrl + K | ⌘ + K | Add hyperlink |
Alt + ↓ | ⌥ + ↓ | Display AutoComplete list |
Ctrl + E | To Format | Flash fill |
Formatting |
⌘ + 1 | Format (almost) anything |
Ctrl + Shift + F | ⌃ + ⇧ + F | Display Format Cells with Font tab selected |
Ctrl + B | ⌘ + B | Apply or remove bold formatting |
Ctrl + I | ⌘ + I | Apply or remove italic formatting |
Ctrl + U | ⌘ + U | Apply or remove underscoring |
Ctrl + 5 | ⌘ + ⇧ + X | Apply or remove strikethrough formatting |
Alt + H + A + C | ⌘ + E | Align center |
Alt + H + A + L | ⌘ + L | Align left |
Alt + H + A + R | ⌘ + R |
Align right
|
Alt + H6 | ⌃ + ⌥ + Tab | Indent |
Alt + H5 | ⌃ + ⌥ + ⇧ + Tab | Remove indent |
Alt + H + F + K | ⌘ + ⇧ + ‹ | Decrease font size one step |
Number Formatting |
⌃ + ⇧ + ~ | Apply general format |
Ctrl + Shift + $ | ⌃ + ⇧ + $ | Apply currency format |
Ctrl + Shift + % | ⌃ + ⇧ + % | Apply percentage format |
Ctrl + Shift + ^ | ⌃ + ⇧ + ^ | Apply scientific format |
Ctrl + Shift + # | ⌃ + ⇧ + # | Apply date format |
Ctrl + Shift + @ | ⌃ + ⇧ + @ | Apply time format |
Ctrl + Shift + ! | ⌃ + ⇧ + ! | Apply number format |
Borders |
⌘ + ⌥ + 0 | Add border outline |
Alt + R | ⌘ + ⌥ + → | Add or remove border right |
Alt + L | ⌘ + ⌥ + ← | Add or remove border left |
Alt + T | ⌘ + ⌥ + ↑ | Add or remove border top |
Alt + B | ⌘ + ⌥ + ↓ | Add or remove border bottom |
Ctrl + Shift + _ | ⌘ + ⌥ + _ | Remove borders |
Formulas |
⌘ + T | Toggle absolute and relative references |
Shift + F3 | Fn + ⇧ + F3 | Open the Insert Function Dialog Box |
Alt + = | ⌘ + ⇧ + T | Autosum selected cells |
Ctrl + ` | ⌃ + ` | Toggle formulas on and off |
Ctrl + Shift + A | ⌃ + ⇧ + A | Insert function arguments |
Ctrl + Shift + Enter | ⌃ + ⇧ + Return | Enter array formula |
F9 | Fn + F9 | Calculate worksheets |
Shift + F9 | Fn + ⇧ + F9 | Calculate active worksheet |
F9 | Fn + F9 | Calculate worksheets |
Ctrl + Shift + U | ⌃ + ⇧ + U | Expand or collapse the formula bar |
⌃ + A | Display function arguments dialog box | |
Ctrl + F3 | Fn + ⌃ + F3 | Define name |
Tab | ↓ + Tab | Accept function with autocomplete |
Grid Operations |
⌃ + I | Insert rows |
Ctrl + Shift + + | ⌃ + I | Display Insert Dialog box |
Ctrl + Shift + + | ⌃ + I | Insert columns |
Ctrl + – | ⌃ + – | Delete cells |
Ctrl + – | ⌃ + – | To delete columns |
Ctrl+ – | ⌃ + – | To delete rows |
Ctrl + – | ⌃ + – | Display Delete dialog box |
Delete | Fn + Delete | To delete contents of selected cells |
Ctrl + 0 | ⌃ + 0 | Hide columns |
Ctrl + 9 | ⌃ + 9 | Hide rows |
Ctrl + Shift + 9 | ⌃ + ⇧ + 9 | Unhide rows |
Ctrl + Shift + 0 | ⌃ + ⇧ + 0 | Unhide columns |
Alt + Shift + → | ⌘ + ⇧ + K | Group rows or columns |
Alt + Shift + ← | ⌘ + ⇧ + J | Ungroup rows or columns |
Alt + Shift + → | ⌘ + ⇧ + K | Open Group Dialog Box |
Alt + Shift + ← | ⌘ + ⇧ + J | Open Ungroup Dialog Box |
Ctrl + 8 | ⌃ + 8 | Hide or show outline symbols |
Ctrl + Alt + + | ⌥ + ⌘ + + | Zoom in |
⌥ + ⌘ + – | Zoom out | |
Pivot Tables |
⌘ + A | Select entire pivot table |
Space | Space | Toggle pivot table field checkbox |
Alt + Shift + → | ⌘ + ⇧ + K | Group pivot table items |
Alt + Shift + ← | ⌘+ ⇧ + J | Ungroup pivot table items |
Ctrl + – | ⌃ + – | Hide pivot table item |
Workbook |
Fn + F11 | Create pivot chart on new worksheet |
Alt + D + P | ⌘ + ⌥ + P | Open pivot table wizard |
Shift + F11 | Fn + ⇧ + F11 | Insert new worksheet |
Ctrl + Page Down | Fn + ⌃ + ↓ | Go to next worksheet |
Ctrl + Page Up | Fn + ⌃ + ↑ | Go to previous worksheet |
F6 | Fn + F6 | Move to next pane |
Shift + F6 | Fn + ⇧ + F6 | Move to previous pane |
Ctrl + Tab | ⌃ + Tab | Go to next workbook |
Ctrl + Shift + Tab | ⌃ + ⇧ + Tab | Go to previous workbook |
Ctrl + F9 | ⌘ + M | To minimize current workbook window |
Ctrl + F10 | Fn + ⌃ + F10 | To maximize current workbook window |
Shift + Click | ⇧ + Click | Select adjacent worksheets |
Ctrl + Click | ⌘ + Click | Select non-adjacent worksheets |
Screen Lock | Fn + ⇧ + F14 | Toggle scroll lock |
Ctrl + Shift + | ⌃ + ⌘ + F | Toggle full screen |
Dialog boxes |
Tab | Move to next control |
Shift + Tab | ⇧ + Tab | Move to previous control |
Ctrl + Tab | ⌃ + ⇧ + Tab | Move to next tab |
Enter | Return | Accept and apply |
Space | Space | Check and uncheck box |
Escape | Escape | Cancel and close the dialog box |
Other |
Fn + F7 | Open Spelling dialog box |
Shift + F7 | Fn + ⇧ + F7 | Open Thesaurus dialog box |
Alt + F8 | Fn + ⌥ + F8 | Open Macro dialog box |
Alt + F11 | Fn + ⌥ + F11 | Open VBA Editor |
Ctrl + D | ⌘ + D | Duplicate object |
Alt | ⌘ | Snap to grid |
Ctrl + 6 | ⌃ + 6 | Hide or show objects |
Alt + ‘ | ⌘ + ⇧ + L | Display Modify Cell Style dialog box |
Shift + F10 | Fn + ⇧ + F10 | Display right-click menu |
Fn + Shift + F10 | To delete comment | |
Alt + Space | ? | Display control menu |
PROS
- Moving to the cloud: Like the other apps in the latest Mac Office suite, Excel 2016 lets you store, sync, and edit files online, via Microsoft’s OneDrive cloud storage service. You can also save Excel files to your Dropbox account.
- Collaborate: Excel 2016, through OneDrive, lets you share documents with colleagues and collaborate in real time. You can chat online as well, either through a document chat window or through Skype.
- Modern design: The redesigned ribbon for the Mac version of Excel borrows the look and feel of its Windows counterpart, presenting tools and formatting options in much the same way as Excel for Windows does. Excel also recommends appropriate charts based on spreadsheet data.
- Moving across platforms: Excel 2016 supports many of the Windows keyboard shortcuts and most of the Excel 2013 for Windows functions, which should make it easier to use the tool across platforms. The update also includes an Analysis ToolPak add-in, PivotTable slicers for analyzing data, and an improved formula builder.
CONS
- Macro limits: Prior to Office 2016, you could build macros in Excel for Mac. The 2016 edition offers what Microsoft calls a “simplified” Visual Basic Editor (VBE), which allows you to debug existing macros. But if you want to build new macros, you need to do that on the Windows side or use an earlier Mac version. For those who built macros in preceding Mac editions, this is a big loss.
BOTTOM LINE
Microsoft Excel spreadsheet app lets you create, view, edit and share your files with others quickly and easily. It also lets you view and edit workbooks attached to email messages. Work in accounting, auditing, finance or other fields, with anyone, anywhere, with confidence. With Excel, your Office moves with you and can implement the most complex formulas, with amazing features
Excel 2016 is probably worth the upgrade just based on its ability to take advantage of OneDrive. The new analysis tools and formula builder help keep Microsoft’s spreadsheet an essential tool. Hobbling its macros tool, however, diminishes a bit of the attraction for serious users.
These were Microsoft Excel Shortcuts for Mac and Windows. moreover, If you found this content helpful. Please share it on your Facebook, Twitter, and LinkedIn. leave your comments below as well if you have any thoughts to add or questions.