Office 2011: Excel FAQ. Did Microsoft add menu-item shortcuts to Excel for Mac like the ones that are in Excel for Windows? Excel 2011 files are compatible with Excel 2007. Jul 29, 2011 - Problem 1) I first moved a copy of an add-in to the Excel add-in folder (/Applications/Microsoft Office 2011/Office/Add-Ins). The add-in didn't.
A couple of weeks ago, we what you wanted to know about Office 2011, the latest update to Microsoft's venerable software suite. (It goes.) Based on our own research and consultations with Microsoft, here are answers to your questions about ( ); stay tuned for our answers about the suite's other apps. Interface Can all Excel 2011 commands be accessed by menu options (in addition to buttons, the Ribbon, and so forth)? Yes, the menus work just as they did in Excel 2008. Can I set the menus and Ribbons in Excel 2011 so they’re the same as in Excel 2007 for Windows?
Although the user interface is similar on both platforms, they are a bit different, so you won’t be able to make Excel 2011 look and feel exactly the same as Excel 2007. Did Microsoft add menu-item shortcuts to Excel for Mac like the ones that are in Excel for Windows?
Microsoft added some menu-item shortcuts similar to what you get in Excel for Windows. However, as the Mac and Windows operating systems differ, there are some differences in the shortcuts. Does pressing the slash key (/) in Excel 2011 jump the focus up to the menu bar, as it does in the Windows version? The Mac version used to do this; it was nice to not have to reach for the mouse. No, that is not supported in Excel 2011. In a workbook with multiple tabs, can you color each tab individually?
You could do it in Excel X and 2003, but not since. Yes, you can color tabs individually. Did Microsoft bring back the ability to see (and manipulate) page breaks in a page-break view?
Yes, you can see and change page breaks in the Page Layout view. Are there pencil-and-eraser tools for selecting borders? (I didn’t see them in the beta versions.) No, Excel 2011 doesn’t have this feature.
Interoperability There’s been an inconsistency between the ways the Mac and Windows versions of Excel have managed dates (the 1900 versus 1904 problem). Has that been solved? New workbooks in Excel 2011 now automatically default to the 1900 date system, as they do in the Excel 2010 for Windows. Can I exchange spreadsheets freely with colleagues who use the Windows 2007 version? Yes, Excel 2011 files are compatible with Excel 2007. Does Excel 2011 for Mac support macros created with Excel 2007 for Windows? Will data files created by Excel X be compatible with Excel 2011, and vice versa?
If you use the free, you can open documents saved in Excel 2011’s default file format in Excel X or later. VBA and AppleScript Is the version of Visual Basic for Applications (VBA) in Excel 2011 different from the one that worked with Excel 2004? There are two major differences between the two: First, Microsoft ported the Windows Office VBA environment to the Mac.
The engine was upgraded from VBA 6 to VBA 6.5. The company also enabled some functions—such as FormatCurrency, FormatNumber, and Replace—that had been disabled in Office 2004.
Second, whenever it was possible and made sense, Microsoft aligned the object models in Office 2011 with those used in Office 2010 for Windows. The company says that should result in much better compatibility across the two platforms. Is the VBA in Excel 2011 compatible with the version in Office 2004? Is the Solver integrated into Excel now that VBA is back?
(In Excel 2008, it was a separate application and very slow.) Yes. Solver is back in Excel 2011. It uses VBA for its user interface and Apple’s new Scripting Bridge technology to help with performance. Microsoft says its interface matches that of the new Solver in Excel 2010 for Windows.
You should be able to move Excel workbooks containing Solver models (and VBA macros that control Solver) freely between Mac and Windows versions of Excel. All versions of Solver—from Excel 3.0 in 1990 to Excel 2010 and 2011—will be available as free downloads from.
Has the AppleScript library changed at all since Excel 2008? It has been expanded a bit; it now supports password protection, filtering, sorting, and tables. Other Questions File format: Is it xls or xlsx? The default format is.xlsx.
Is there a sort-by-format feature? I’d love to identify lines of data via conditional formatting or even manual formatting, and then sort them accordingly. You can sort by cell color, font color, or icons created by conditional formatting. Are there still problems with files that have long paths (opening, saving, inserting images from, and so on)?
Excel 2011 supports path names up to 255 characters long. Did Microsoft improve the program’s ability to paste text from external applications into merged cells? Yes and no: Microsoft says that it fixed some bugs regarding pasting into merged cells, but it can’t guarantee that all data from all apps will paste successfully. Can a cell in Excel reference data that's available from a Website and then update at selected intervals of time?
Yes and no: You can update a cell in Excel reference data from a Website, but you cannot set the interval time. Does Excel 2011 include Fourier transforms? Does Excel 2011 support Excel 2004’s tools for matrix manipulations (TRANSPOSE(array), MMULT(array1,array2), MINVERSE(squareArray))?
Does Excel 2011 support what used to be called Graphical Goal Seek for XY Scatter Plots? Can you access MS SQL OLAP cubes now?
Does Excel 2011 include the equivalent of Excel 2010’s slicers (the ability to filter on multiple pivot tables in a dashboard-like interface)? PivotTables in Excel 2011 are in many ways like those in Excel 2010, but the Mac version does not support all of the high-end features—including Slicers or built-in database connectivity—found in the Windows program. Has Microsoft returned the Analysis Toolpak add-in that it removed from Excel 2008?
Microsoft says that the new version of Excel supports the add-in the same way Excel 2008 did, and that the add-in’s basic functions work in Excel 2011. Excel 2010 for Windows has a powerful add-on——for handling huge data sets. Will Excel 2011 support it?
Excel for Mac 2011 Customer support and troubleshooting for Office for Mac 2011 ends October, 2017. To get all the latest features, upgrade to Office 2016 for Mac.
Make a one-time purchase, or buy an Office 365 subscription and stay up to date. Work with sheets and data Title Description Work with cells, rows, and columns. Use the Paste Special command to copy and paste special cell contents or attributes. Keep column headings visible while you scroll. Change the width of columns so that you can see all the data in cells. Prevent unauthorized changes, moves, or deletions of important data.
Change the appearance of cells based on certain criteria, for example, all cell values in the top 10% of a range. Work with functions, formulas, and lists Title Description Learn the elements of a formula as well as how to enter a formula on a sheet. Learn about the different kinds of operators (for example, +, -, /, and.) and the order in which they are applied. Learn the difference between relative and absolute cell references and how to switch between them. Work with charts and graphics Title Description Learn the basics of charts, including the elements of a chart, which chart is appropriate for your data, and how to apply chart layouts and styles.
Add chart and axis titles, change the axis scale, add data labels, and more. Use error bars to indicate potential error amounts in relation to each data point. Add pictures or clip art to a worksheet by using the Media Browser. Analyze, share, and collaborate Title Description Learn the two different ways to create a Pivot Table and how to use the Pivot Table Field Lists to add, move, and arrange fields. Create a projection based on an existing series of data. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes. Explore other useful resources Title Description See the full list of keyboard shortcuts, organized into logical categories.
Rearrange, show, and hide tabs on the ribbon. See a list of known issues as well as potential workarounds.