| 1. Function keys | |
|---|---|
| F1 | Undo |
| F2 | Cut text from the active cell |
| Shift+F2 | Edit a cell comment |
| F3 | Copy text from the active cell |
| Shift+F3 | Open the Formula Builder |
| F4 | Paste text into the active cell |
| Shift+F4 | Repeat the last Find (Find Next) |
| ⌘+F4 | Close the window |
| F5 | Display the Go To dialog box |
| Shift+F5 | Display the Find dialog box |
| ⌘+F5 | Restore the window size.* |
| F6 | Move to the next pane in a workbook that has been split |
| Shift+F6 | Move to the previous pane in a workbook that has been split |
| ⌘+F6 | Move to the next workbook window |
| ⌘+Shift+F6 | Move to the previous workbook window |
| F7 | Check spelling |
| F8 | Turn on extend selection mode; used with arrow keys or cursor |
| Shift+F8 | Add to the selection |
| Option+F8 | Display the Macro dialog box |
| F9 | Calculate all sheets in all open workbooks. |
| Shift+F9 | Calculate the active sheet. |
| Shift+F10 | Display a contextual menu. |
| ⌘+F10 | Maximize or restore the workbook window |
| Option+F10 | Make the first button on a floating toolbar active |
| F11 | Insert a new chart sheet. |
| Shift+F11 | Insert a new sheet. |
| ⌘+F11 | Insert an Excel 4.0 macro sheet |
| F12 | Display the Save As dialog box. |
| ⌘+F12 | Display the Open dialog box |
| Ctrl+Shift+F12 | Display the Print dialog box |
| *Conflicts with a default Mac OS X key assignment. Turn off the Mac OS X keyboard shortcut for this key. Apple Menu - System Preferences - Under Hardware - Keyboard - Click the Keyboard Shortcuts tab,- clear the On check box for the key assignment that you want to turn off. |
Add: Click to open the Choose a File browser, where you can browse to an add-in template in Finder and add your add-in to the list. Remove: Click to remove the selected add-in from the list. In Word, when you select an add-in's check box or click the Add button, you load the template, thereby making the VBA routines that it has available globally within all open documents in Word. Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 More. Office 2016 for Mac support is ending soon. Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support.
▲ up
| 2. Moving and scrolling in a sheet or workbook | |
|---|---|
| Arrow Keys | Move one cell up, down, left, or right |
| Ctrl+Arrow Key | Move to the edge of the current data region |
| Home | Move to the beginning of the row |
| Ctrl+Home./Ctrl+End | Move to the beginning / to the end of the sheet |
| Page Down/Page Up | Move down one screen / up one screen |
| Option+Page Down/Option+Page Up | Move one screen to the right / to the left |
| Ctrl+Page Down/Ctrl+Page Up | Move to the next sheet / to the previous sheet in the workbook |
| Ctrl+Tab/Ctrl+Shift+Tab | Move to the next workbook / move to the previous workbook or window |
| F6/Shift+F6 | Move to the next pane / move to the previous pane in a workbook that has been split |
| Ctrl+Delete | Scroll to display the active cell |
| Ctrl+g | Display the Go To dialog box |
| ⌘+f | Display the Find dialog box |
| ⌘+g | Repeat the last Find action (same as Find Next) |
| Tab | Move between unlocked cells on a protected sheet |
▲ up
| 3. Previewing and printing | |
|---|---|
| ⌘+p | Display the Print dialog box |
| Arrow Keys | In print preview, move around the page when zoomed in |
| Ctrl+Arrow Down | In print preview, move to the last page when zoomed out |
▲ up
| 4. Entering data on a sheet | |
|---|---|
| Return | Complete a cell entry and move forward in the selection |
| Ctrl+Option+Return | Start a new line in the same cell |
| Ctrl+Return | Fill the selected cell range with the text that you type |
| Shift+Return | Complete a cell entry and move back 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 ⌦ | Delete the character to the right of the insertion point, or delete the selection |
| Ctrl+Delete ⌦ | Delete text to the end of the line |
| Arrow Keys | Move one character up, down, left, or right |
| Home | Move to the beginning of the line |
| ⌘+y | Repeat the last action |
| Shift+F2 | Edit a cell comment |
| Ctrl+d | Fill down |
| Ctrl+r | Fill to the right |
| Ctrl+l | Define a name |
▲ up
| 5. Working in cells 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 |
| Return | Complete a cell entry |
| Ctrl+Shift+Return | 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 | 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 |
| ⌘+= | Calculate all sheets in all open workbooks |
| ⌘+Shift+= | Calculate the active sheet |
| = | Start a formula |
| ⌘+t | 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+' | 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 |
▲ up
| 6. Formatting and editing data | |
|---|---|
| ⌘+Shift+l | Display the 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 A.M. or P.M. |
| Ctrl+Shift+! | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values |
| ⌘+Option+0 (zero) | 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+- | 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 |
| Ctrl+9 | Hide rows |
| Ctrl+Shift+( | Unhide rows |
| Ctrl+0 (zero) | Hide columns |
| Ctrl+Shift+) | Unhide columns |
| ⌘+Shift+w | Add or remove the shadow font style |
| ⌘+Shift+d | Add or remove the outline font style |
| 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 |
| Return | Complete a cell entry |
| Ctrl+Shift+Return | 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. Working with a selection | |
|---|---|
| ⌘+c | Copy the selection |
| ⌘+x | Cut the selection |
| ⌘+v | Paste the selection |
| ⌘+Ctrl+v | Paste special |
| Delete | Clear the contents of the selection |
| Ctrl+- | Delete the selection |
| ⌘+Shift+c | Copy a style |
| ⌘+Shift+v | Paste a style |
| Ctrl+Option+c | Copy text or graphics to the Scrapbook |
| Ctrl+Option+v | Paste to the Scrapbook |
| ⌘+z | Undo the last action |
| Return | Move from top to bottom within the selection (down), or move in the direction that is selected in Edit in thePreferences dialog box (Excel menu, Preferences command) |
| Shift+Return | Move from bottom to top within the selection (up), or move opposite to the direction that is selected in Edit in the Preferences dialog box (Excel menu, Preferences command) |
| 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 up one cell if only one column is selected |
| Ctrl+. (Period) | Move clockwise to the next corner of the selection |
| Ctrl+Option+Arrow Right | Move to the right between nonadjacent selections |
| Ctrl+Option+Arrow Left | Move to the left between nonadjacent selections |
| ⌘+Ctrl+m | Insert graphics using the Media Browser |
▲ up
| 8. Selecting cells, columns, or rows | |
|---|---|
| Shift+Arrow Key | Extend the selection by one cell |
| Ctrl+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+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 |
| Ctrl+7 | Show or hide the Standard toolbar |
| F8 | Turn on the capability to extend a selection by using the arrow keys |
| Shift+F8 | Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |
| 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+[ | Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell. |
| 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 |
| ⌘+Shift+z | Select only visible cells in the current selection |
▲ up
| 9. Charts | |
|---|---|
| F11 | Insert a new chart sheet.* |
| Arrow Key | Cycle through chart object selection |
| *Conflicts with a default Mac OS X key assignment. Turn off the Mac OS X keyboard shortcut for this key. Apple Menu - System Preferences - Under Hardware - Keyboard - Click the Keyboard Shortcuts tab,- clear the On check box for the key assignment that you want to turn off. |
▲ up
| 10. Data forms | |
|---|---|
| Arrow Down/Arrow Up | Move to the same field in the next record / previous record |
| Tab/Shift+Tab | Move to the next field / previous field that you can edit in the record |
| Return /Shift+Return | Move to the first field in the next record / in the previous record |
| Page Down/Page Up | Move to the same field 10 records forward / 10 records back |
| Ctrl+Page Down | Move to a new record |
| Ctrl+Page Up | Move to the first record |
▲ up
| 11. Filters and PivotTable reports | |
|---|---|
| Option+Arrow Down | Display the Filter list or PivotTable page field pop-up menu for the selected cell |
▲ up Mmo for the mac.
| 12. Outlining data | |
|---|---|
| Ctrl+8 | Display or hide outline symbols |
| Ctrl+9 | Hide selected rows |
| Ctrl+Shift+( | Unhide selected rows |
| Ctrl+0 (zero) | Hide selected columns |
| Ctrl+Shift+) | Unhide selected columns |
▲ up
| 13. Toolbars | |
|---|---|
| Option+F10 | Make the first button on a floating toolbar active |
| Tab | When a toolbar is active, select the next button or menu on the toolbar |
| Shift+Tab | When a toolbar is active, select the previous button or menu on the toolbar |
| Ctrl+Tab | When a toolbar is active, select the next toolbar |
| Ctrl+Shift+Tab | When a toolbar is active, select the previous toolbar |
| Return | Perform the action assigned to the selected button |
▲ up
| 14. Windows | |
|---|---|
| ⌘+Option+1 | Expand or minimize the ribbon |
| ⌘+Tab | Switch to the next application |
| ⌘+Shift+Tab | Switch to the previous application |
| ⌘+w | Close the active workbook window |
| ⌘+F5* | Restore the active workbook window size |
| F6 | Move to the next pane in a workbook that has been split |
| Shift+F6 | Move to the previous pane in a workbook that has been split |
| ⌘+F6 | Switch to the next workbook window |
| ⌘+Shift+F6 | Switch to the previous workbook window |
| Ctrl+F10 | Maximize or restore the workbook window |
| ⌘+Shift+3* | Copy the image of the screen to the Clipboard |
| ⌘+Shift+4* | Copy the image of the active window to the Clipboard (after pressing and releasing the key combination, click the window that you want to take a picture of). |
| *Conflicts with a default Mac OS X key assignment. Turn off the Mac OS X keyboard shortcut for this key. Apple Menu - System Preferences - Under Hardware - Keyboard - Click the Keyboard Shortcuts tab,- clear the On check box for the key assignment that you want to turn off. |
▲ up
| 15. Dialog boxes | |
|---|---|
| Tab | Move to the next text box |
| Shift+Tab | Move to the previous text box |
| Ctrl+Tab | Switch to the next tab in a dialog box |
| Ctrl+Shift+Tab | Switch to the previous tab in a dialog box |
| Return | Perform the action assigned to the default command button in the dialog box (the button with the bold outline, often the OK button) |
| Esc | Cancel the command and close the dialog box |
▲ up
Microsoft Office for Mac 2011 applications shown on Mac OS X Snow Leopard | |
| Developer(s) | Microsoft |
|---|---|
| Initial release | October 26, 2010; 9 years ago |
| Stable release | |
| Operating system | Mac OS X 10.5.8 to macOS 10.14.6 |
| Type | Office suite |
| License | |
| Website | www.microsoft.com/mac/ |
Microsoft Office for Mac 2011 is a version of the Microsoft Officeproductivity suite for Mac OS X. It is the successor to Microsoft Office 2008 for Mac and is comparable to Office 2010 for Windows. Office 2011 was followed by Microsoft Office 2016 for Mac released on September 22, 2015, requiring a Mac with an x64 Intel processor and OS X Yosemite or later.
New features[edit]
Microsoft Office 2011 includes more robust enterprise support and greater feature parity with the Windows edition. Its interface is now more similar to Office 2007 and 2010 for Windows, with the addition of the ribbon. Support for Visual Basic for Applications macros has returned after having been dropped in Office 2008.[4][5] Purchasing the Home Premium version of Office for Mac will not allow telephone support automatically to query any problems with the VBA interface. There are however, apparently, according to Microsoft Helpdesk, some third party applications that can address problems with the VBA interface with Office for Mac.[citation needed] In addition, Office 2011 supports online collaboration tools such as OneDrive and Office Web Apps, allowing Mac and Windows users to simultaneously edit documents over the web. It also includes limited support for Apple's high-density Retina Displays, allowing the display of sharp text and images, although most icons within applications themselves are not optimized for this.
A new version of Microsoft Outlook, written using Mac OS X's Cocoa API, returns to the Mac for the first time since 2001 and has full support for Microsoft Exchange Server 2007.[6] It replaces Entourage, which was included in Office 2001, X, 2004 and 2008 for Mac.[7]
In this aircrack tutorial, we outline the steps involved in cracking WEP keys. Aircrack for mac. And -h the host MAC address. Description Aircrack for windows download.
Limitations[edit]
Office for Mac 2011 has a number of limitations compared to Office 2010 for Windows. It does not support ActiveX controls,[8] or OpenDocument Format.[9][10] It also cannot handle attachments in Rich Text Format e-mail messages sent from Outlook for Windows, which are delivered as winmail.dat attachments.[citation needed] It also has several human language limitations, such as lack of support for right-to-left languages such as Arabic, Persian, and Hebrew [11] and automatic language detection. [12]
Download Excel For Mac
Microsoft does not support CalDAV and CardDAV in Outlook, so there is no way to sync directly Outlook through iCloud. Outlook also does not allow the user to disable Cached Exchange Mode, unlike the Windows version, and it is therefore not possible to connect to an Exchange Server without downloading a local cache of mail and calendar data. [13]
Office for Mac 2011 also has a shorter lifecycle than Office 2010, with support phasing out on October 10, 2017.[14] As 32-bit software, it will not run on macOS Catalina, released in 2019.[15]
Editions[edit]
Two editions are available to the general public. Home & Student provides Word, Excel and PowerPoint, while Home & Business adds Outlook and increased support.[16]Microsoft Messenger 8 is included with both editions, and Microsoft Communicator for Mac 2011, which communicates with Microsoft Lync Server, is available only to volume licensing customers.[17] Office 2011 requires an Intel Mac running Mac OS X 10.5.8 or later.[18]
| Applications and services | Home & Student | Home & Business | Academic | Standard |
|---|---|---|---|---|
| Word | Included | Included | Included | Included |
| PowerPoint | Included | Included | Included | Included |
| Excel | Included | Included | Included | Included |
| Outlook | Not included | Included | Included | Included |
| Communicator or Lync | Not included | Not included | Included | Included |
| Office Web Apps | Included | Included | Included | Included |
| Remote Desktop Connection | Not included | Included | Included | Included |
| Information Rights Management | Included | Included | Included | Included |
| Windows SharePoint Services Support | Not included | Included | Included | Included |
| Technical support | 90 days | 1 year | 90 days | ? |
The Home & Student edition is available in a single license for one computer and a family pack for three computers. The Home & Business edition is available in a single license for one computer and a multi-pack for two computers. The Standard edition is only available through Volume Licensing.[19] The Academic edition was created for higher education students, staff and faculty, and includes one installation.[20] Office for Mac is also available as part of Microsoft's Office 365 subscription programme.
Development[edit]
Microsoft announced Office 2011 in 2009.[21] There were 6 beta versions released:
- Beta 1
- Beta 2 (Version 14.0.0, Build 100326)
- Beta 3 (Build 100519)—announced on May 25, 2010[22]
- Beta 4 (Build 100526)
- Beta 5 (Build 100709)
- Beta 6 (Build 100802)
Access to beta versions was by invitation only,[23] although leaked copies were circulated among Mac file sharing websites.[24]
The final version was released to manufacturing on September 10, 2010,[25] was available to volume license customers a day later,[26] and made available to the general public on October 26, 2010.[27] Service Pack 1 was released on April 12, 2011.[28]
Add: Click to open the Choose a File browser, where you can browse to an add-in template in Finder and add your add-in to the list. Remove: Click to remove the selected add-in from the list. In Word, when you select an add-in's check box or click the Add button, you load the template, thereby making the VBA routines that it has available globally within all open documents in Word. Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 More. Office 2016 for Mac support is ending soon. Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support.
▲ up
| 2. Moving and scrolling in a sheet or workbook | |
|---|---|
| Arrow Keys | Move one cell up, down, left, or right |
| Ctrl+Arrow Key | Move to the edge of the current data region |
| Home | Move to the beginning of the row |
| Ctrl+Home./Ctrl+End | Move to the beginning / to the end of the sheet |
| Page Down/Page Up | Move down one screen / up one screen |
| Option+Page Down/Option+Page Up | Move one screen to the right / to the left |
| Ctrl+Page Down/Ctrl+Page Up | Move to the next sheet / to the previous sheet in the workbook |
| Ctrl+Tab/Ctrl+Shift+Tab | Move to the next workbook / move to the previous workbook or window |
| F6/Shift+F6 | Move to the next pane / move to the previous pane in a workbook that has been split |
| Ctrl+Delete | Scroll to display the active cell |
| Ctrl+g | Display the Go To dialog box |
| ⌘+f | Display the Find dialog box |
| ⌘+g | Repeat the last Find action (same as Find Next) |
| Tab | Move between unlocked cells on a protected sheet |
▲ up
| 3. Previewing and printing | |
|---|---|
| ⌘+p | Display the Print dialog box |
| Arrow Keys | In print preview, move around the page when zoomed in |
| Ctrl+Arrow Down | In print preview, move to the last page when zoomed out |
▲ up
| 4. Entering data on a sheet | |
|---|---|
| Return | Complete a cell entry and move forward in the selection |
| Ctrl+Option+Return | Start a new line in the same cell |
| Ctrl+Return | Fill the selected cell range with the text that you type |
| Shift+Return | Complete a cell entry and move back 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 ⌦ | Delete the character to the right of the insertion point, or delete the selection |
| Ctrl+Delete ⌦ | Delete text to the end of the line |
| Arrow Keys | Move one character up, down, left, or right |
| Home | Move to the beginning of the line |
| ⌘+y | Repeat the last action |
| Shift+F2 | Edit a cell comment |
| Ctrl+d | Fill down |
| Ctrl+r | Fill to the right |
| Ctrl+l | Define a name |
▲ up
| 5. Working in cells 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 |
| Return | Complete a cell entry |
| Ctrl+Shift+Return | 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 | 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 |
| ⌘+= | Calculate all sheets in all open workbooks |
| ⌘+Shift+= | Calculate the active sheet |
| = | Start a formula |
| ⌘+t | 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+' | 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 |
▲ up
| 6. Formatting and editing data | |
|---|---|
| ⌘+Shift+l | Display the 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 A.M. or P.M. |
| Ctrl+Shift+! | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values |
| ⌘+Option+0 (zero) | 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+- | 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 |
| Ctrl+9 | Hide rows |
| Ctrl+Shift+( | Unhide rows |
| Ctrl+0 (zero) | Hide columns |
| Ctrl+Shift+) | Unhide columns |
| ⌘+Shift+w | Add or remove the shadow font style |
| ⌘+Shift+d | Add or remove the outline font style |
| 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 |
| Return | Complete a cell entry |
| Ctrl+Shift+Return | 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. Working with a selection | |
|---|---|
| ⌘+c | Copy the selection |
| ⌘+x | Cut the selection |
| ⌘+v | Paste the selection |
| ⌘+Ctrl+v | Paste special |
| Delete | Clear the contents of the selection |
| Ctrl+- | Delete the selection |
| ⌘+Shift+c | Copy a style |
| ⌘+Shift+v | Paste a style |
| Ctrl+Option+c | Copy text or graphics to the Scrapbook |
| Ctrl+Option+v | Paste to the Scrapbook |
| ⌘+z | Undo the last action |
| Return | Move from top to bottom within the selection (down), or move in the direction that is selected in Edit in thePreferences dialog box (Excel menu, Preferences command) |
| Shift+Return | Move from bottom to top within the selection (up), or move opposite to the direction that is selected in Edit in the Preferences dialog box (Excel menu, Preferences command) |
| 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 up one cell if only one column is selected |
| Ctrl+. (Period) | Move clockwise to the next corner of the selection |
| Ctrl+Option+Arrow Right | Move to the right between nonadjacent selections |
| Ctrl+Option+Arrow Left | Move to the left between nonadjacent selections |
| ⌘+Ctrl+m | Insert graphics using the Media Browser |
▲ up
| 8. Selecting cells, columns, or rows | |
|---|---|
| Shift+Arrow Key | Extend the selection by one cell |
| Ctrl+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+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 |
| Ctrl+7 | Show or hide the Standard toolbar |
| F8 | Turn on the capability to extend a selection by using the arrow keys |
| Shift+F8 | Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |
| 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+[ | Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell. |
| 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 |
| ⌘+Shift+z | Select only visible cells in the current selection |
▲ up
| 9. Charts | |
|---|---|
| F11 | Insert a new chart sheet.* |
| Arrow Key | Cycle through chart object selection |
| *Conflicts with a default Mac OS X key assignment. Turn off the Mac OS X keyboard shortcut for this key. Apple Menu - System Preferences - Under Hardware - Keyboard - Click the Keyboard Shortcuts tab,- clear the On check box for the key assignment that you want to turn off. |
▲ up
| 10. Data forms | |
|---|---|
| Arrow Down/Arrow Up | Move to the same field in the next record / previous record |
| Tab/Shift+Tab | Move to the next field / previous field that you can edit in the record |
| Return /Shift+Return | Move to the first field in the next record / in the previous record |
| Page Down/Page Up | Move to the same field 10 records forward / 10 records back |
| Ctrl+Page Down | Move to a new record |
| Ctrl+Page Up | Move to the first record |
▲ up
| 11. Filters and PivotTable reports | |
|---|---|
| Option+Arrow Down | Display the Filter list or PivotTable page field pop-up menu for the selected cell |
▲ up Mmo for the mac.
| 12. Outlining data | |
|---|---|
| Ctrl+8 | Display or hide outline symbols |
| Ctrl+9 | Hide selected rows |
| Ctrl+Shift+( | Unhide selected rows |
| Ctrl+0 (zero) | Hide selected columns |
| Ctrl+Shift+) | Unhide selected columns |
▲ up
| 13. Toolbars | |
|---|---|
| Option+F10 | Make the first button on a floating toolbar active |
| Tab | When a toolbar is active, select the next button or menu on the toolbar |
| Shift+Tab | When a toolbar is active, select the previous button or menu on the toolbar |
| Ctrl+Tab | When a toolbar is active, select the next toolbar |
| Ctrl+Shift+Tab | When a toolbar is active, select the previous toolbar |
| Return | Perform the action assigned to the selected button |
▲ up
| 14. Windows | |
|---|---|
| ⌘+Option+1 | Expand or minimize the ribbon |
| ⌘+Tab | Switch to the next application |
| ⌘+Shift+Tab | Switch to the previous application |
| ⌘+w | Close the active workbook window |
| ⌘+F5* | Restore the active workbook window size |
| F6 | Move to the next pane in a workbook that has been split |
| Shift+F6 | Move to the previous pane in a workbook that has been split |
| ⌘+F6 | Switch to the next workbook window |
| ⌘+Shift+F6 | Switch to the previous workbook window |
| Ctrl+F10 | Maximize or restore the workbook window |
| ⌘+Shift+3* | Copy the image of the screen to the Clipboard |
| ⌘+Shift+4* | Copy the image of the active window to the Clipboard (after pressing and releasing the key combination, click the window that you want to take a picture of). |
| *Conflicts with a default Mac OS X key assignment. Turn off the Mac OS X keyboard shortcut for this key. Apple Menu - System Preferences - Under Hardware - Keyboard - Click the Keyboard Shortcuts tab,- clear the On check box for the key assignment that you want to turn off. |
▲ up
| 15. Dialog boxes | |
|---|---|
| Tab | Move to the next text box |
| Shift+Tab | Move to the previous text box |
| Ctrl+Tab | Switch to the next tab in a dialog box |
| Ctrl+Shift+Tab | Switch to the previous tab in a dialog box |
| Return | Perform the action assigned to the default command button in the dialog box (the button with the bold outline, often the OK button) |
| Esc | Cancel the command and close the dialog box |
▲ up
Start quickly with the most recent versions of Word, Excel, PowerPoint, Outlook, OneNote and OneDrive —combining the familiarity of Office and the unique Mac features you love. Work online or offline, on your own or with others in real time—whatever works for what you're doing. Microsoft 365 is a subscription that includes the most collaborative, up-to-date features in one seamless, integrated experience. Microsoft 365 includes the robust Office desktop apps that you're familiar with, like Word, PowerPoint, and Excel. Get a free trial and you'll have access to the latest AI-powered apps, 1 TB of cloud storage per person, and premium mobile features to stay on top of things wherever you are on any device. Download and install Office apps for free on multiple PCs/Macs, tablets, and phones. Review, edit, analyze.
Microsoft Office for Mac 2011 applications shown on Mac OS X Snow Leopard | |
| Developer(s) | Microsoft |
|---|---|
| Initial release | October 26, 2010; 9 years ago |
| Stable release | |
| Operating system | Mac OS X 10.5.8 to macOS 10.14.6 |
| Type | Office suite |
| License | |
| Website | www.microsoft.com/mac/ |
Microsoft Office for Mac 2011 is a version of the Microsoft Officeproductivity suite for Mac OS X. It is the successor to Microsoft Office 2008 for Mac and is comparable to Office 2010 for Windows. Office 2011 was followed by Microsoft Office 2016 for Mac released on September 22, 2015, requiring a Mac with an x64 Intel processor and OS X Yosemite or later.
New features[edit]
Microsoft Office 2011 includes more robust enterprise support and greater feature parity with the Windows edition. Its interface is now more similar to Office 2007 and 2010 for Windows, with the addition of the ribbon. Support for Visual Basic for Applications macros has returned after having been dropped in Office 2008.[4][5] Purchasing the Home Premium version of Office for Mac will not allow telephone support automatically to query any problems with the VBA interface. There are however, apparently, according to Microsoft Helpdesk, some third party applications that can address problems with the VBA interface with Office for Mac.[citation needed] In addition, Office 2011 supports online collaboration tools such as OneDrive and Office Web Apps, allowing Mac and Windows users to simultaneously edit documents over the web. It also includes limited support for Apple's high-density Retina Displays, allowing the display of sharp text and images, although most icons within applications themselves are not optimized for this.
A new version of Microsoft Outlook, written using Mac OS X's Cocoa API, returns to the Mac for the first time since 2001 and has full support for Microsoft Exchange Server 2007.[6] It replaces Entourage, which was included in Office 2001, X, 2004 and 2008 for Mac.[7]
In this aircrack tutorial, we outline the steps involved in cracking WEP keys. Aircrack for mac. And -h the host MAC address. Description Aircrack for windows download.
Limitations[edit]
Office for Mac 2011 has a number of limitations compared to Office 2010 for Windows. It does not support ActiveX controls,[8] or OpenDocument Format.[9][10] It also cannot handle attachments in Rich Text Format e-mail messages sent from Outlook for Windows, which are delivered as winmail.dat attachments.[citation needed] It also has several human language limitations, such as lack of support for right-to-left languages such as Arabic, Persian, and Hebrew [11] and automatic language detection. [12]
Download Excel For Mac
Microsoft does not support CalDAV and CardDAV in Outlook, so there is no way to sync directly Outlook through iCloud. Outlook also does not allow the user to disable Cached Exchange Mode, unlike the Windows version, and it is therefore not possible to connect to an Exchange Server without downloading a local cache of mail and calendar data. [13]
Office for Mac 2011 also has a shorter lifecycle than Office 2010, with support phasing out on October 10, 2017.[14] As 32-bit software, it will not run on macOS Catalina, released in 2019.[15]
Editions[edit]
Two editions are available to the general public. Home & Student provides Word, Excel and PowerPoint, while Home & Business adds Outlook and increased support.[16]Microsoft Messenger 8 is included with both editions, and Microsoft Communicator for Mac 2011, which communicates with Microsoft Lync Server, is available only to volume licensing customers.[17] Office 2011 requires an Intel Mac running Mac OS X 10.5.8 or later.[18]
| Applications and services | Home & Student | Home & Business | Academic | Standard |
|---|---|---|---|---|
| Word | Included | Included | Included | Included |
| PowerPoint | Included | Included | Included | Included |
| Excel | Included | Included | Included | Included |
| Outlook | Not included | Included | Included | Included |
| Communicator or Lync | Not included | Not included | Included | Included |
| Office Web Apps | Included | Included | Included | Included |
| Remote Desktop Connection | Not included | Included | Included | Included |
| Information Rights Management | Included | Included | Included | Included |
| Windows SharePoint Services Support | Not included | Included | Included | Included |
| Technical support | 90 days | 1 year | 90 days | ? |
The Home & Student edition is available in a single license for one computer and a family pack for three computers. The Home & Business edition is available in a single license for one computer and a multi-pack for two computers. The Standard edition is only available through Volume Licensing.[19] The Academic edition was created for higher education students, staff and faculty, and includes one installation.[20] Office for Mac is also available as part of Microsoft's Office 365 subscription programme.
Development[edit]
Microsoft announced Office 2011 in 2009.[21] There were 6 beta versions released:
- Beta 1
- Beta 2 (Version 14.0.0, Build 100326)
- Beta 3 (Build 100519)—announced on May 25, 2010[22]
- Beta 4 (Build 100526)
- Beta 5 (Build 100709)
- Beta 6 (Build 100802)
Access to beta versions was by invitation only,[23] although leaked copies were circulated among Mac file sharing websites.[24]
The final version was released to manufacturing on September 10, 2010,[25] was available to volume license customers a day later,[26] and made available to the general public on October 26, 2010.[27] Service Pack 1 was released on April 12, 2011.[28]
See also[edit]
Excel For Mac 2011 Pivot Tables
References[edit]
Mac For Excel 2011 Free
- ^https://www.microsoft.com/en-us/download/details.aspx?id=55942
- ^'Microsoft Lifecycle Policy: Office 2011'. Support. Microsoft. Retrieved February 21, 2018.
- ^'Microsoft Lifecycle Policy: Lync 2011'. Support. Microsoft. Retrieved February 21, 2018.
- ^Keizer, Gregg (May 14, 2008). 'Microsoft will bring back macros to Mac Office in 2011'. Computerworld. Retrieved April 21, 2010.
- ^Seff, Jonathan (May 13, 2008). 'Microsoft to bring back Visual Basic in Office for Mac'. Macworld. Retrieved April 21, 2010.
- ^'How to obtain support for Microsoft Outlook for Mac 2011 connectivity problems with Exchange Server'. Support (34.0 ed.). Microsoft. September 12, 2013.
- ^Miller, Dan (February 11, 2010). 'Microsoft Announces Office for Mac 2011'. Macworld. Retrieved October 29, 2010.
- ^'Known issues in Excel 2011'. Microsoft. September 2010. Retrieved October 29, 2010.
- ^answer from Michel Bintener Microsoft MVP (Macintosh), Discussion in the forum of a user of Microsoft Office:Mac Archived February 13, 2011, at WebCite
- ^Office 2011: Mac-Version mit Outlook, aber ohne Opendocument, in German. Archived February 13, 2011, at WebCite
- ^Morgenstern, David. 'Microsoft boosts languages, proofing tools in Office 2011 for Mac, Unicode right-to-left support missing'. The Apple Core. ZDNet. Retrieved November 17, 2010.
- ^http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macword/how-can-i-set-word-2011-to-detect-different/ea5f2561-1ef5-4762-93a7-298c52579ab8
- ^http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macoutlook/is-there-any-way-to-disable-cached-exchange-mode/fe6b090e-fdd6-4666-8e54-db9e5348428e?msgId=f34acd1e-22e3-426d-872e-bccae2821420
- ^https://support.office.com/en-us/article/Support-is-ending-for-Office-for-Mac-2011-559b72b1-e045-4c73-bad3-d7f1841b9e8c
- ^Haslam, Karen. 'Which Mac apps won't work in macOS Catalina?'. Macworld. Retrieved October 31, 2019.
- ^'Office for Mac 2011—Compare'. Microsoft. Retrieved October 27, 2010.
- ^'Announcing Communicator for Mac'. Office for Mac Blog. Microsoft. September 24, 2010. Archived from the original on July 17, 2011. Retrieved November 4, 2010.
- ^'Office System Requirements'. Microsoft Office for Mac. Microsoft. Retrieved November 5, 2010.
- ^Michaels, Philip (August 2, 2010). 'Microsoft sets pricing, October release for Office 2011'. Macworld. Retrieved November 7, 2010.
- ^'Office for Mac 2011 Hitting Store Shelves This October'. Microsoft Office Press. Microsoft. Retrieved November 19, 2010.
- ^Snell, Jason (August 13, 2009). 'Microsoft: Next Mac Office due late 2010 with Outlook'. Macworld. Retrieved November 14, 2009.
- ^McLean, Prince (May 25, 2010). 'Microsoft's Office 2011 beta 3 for Mac gets new icons'. AppleInsider. Retrieved October 29, 2010.
- ^Sams, Brad (July 25, 2010). 'Office 2011 for Mac beta invites sent out'. Neowin.net. Retrieved October 29, 2010.
- ^Paliath, Paul. 'Beta 2 of Microsoft Office 2011 leaked'. GeekSmack. Archived from the original on April 13, 2010. Retrieved April 14, 2010.
- ^'Office for Mac 2011 hits RTM'. Office for Mac Blog. Microsoft. September 10, 2010. Archived from the original on August 12, 2011. Retrieved November 4, 2010.
- ^Weintraub, Seth (September 21, 2010). 'Office for Mac hits Microsoft volume licensing servers'. 9to5 Mac. Retrieved September 27, 2010.
- ^Mac Mojo Team (September 28, 2010). 'Office for Mac 2011 in the Store This October'. Office for Mac Blog. Microsoft. Archived from the original on August 12, 2011. Retrieved October 29, 2010.
- ^'Microsoft Office for Mac Downloads and Updates'. Office For Mac. Microsoft. Retrieved September 16, 2011.
Mac Excel 2011 Data Analysis
