Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.
Jul 27, 2017 - This topic itemizes all keyboard shortcuts for Excel 2016 for Mac. We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience. That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking.
Excel Undo / Redo The execution of any macro that makes a change to the spreadsheet destroys Excel's Undo/Redo stacks. So, when you modify a formula and then run a macro to change number format, for example, you are unable to use Excel's native Undo to revert to the original formula. This is a severe limitation of Excel, and not a problem with the add-in or macro. There are no easy workarounds to this problem, unfortunately. Excel add-ins and their users accept this loss of Undo/Redo functionality as a cost of doing business. In other words, the benefits provided by add-ins and macros outweigh the cost of losing native Undo/Redo capability. We believe customers of our enterprise-grade solutions shouldn't sacrifice anything to use our tools.
So, we built our own Undo/Redo stacks to track changes made to spreadsheets, restoring most of this lost functionality. Why don't all Excel add-ins do this?
Because managing custom Undo/Redo stacks is prohibitively complex and expensive for most applications. Accordingly, very few add-ins have achieved this advanced capability. Macabacus' Undo/Redo is designed to work seamlessly in the background, and uses the native Excel shortcuts, Ctrl+Z and Ctrl+Y, and Quick Access Toolbar buttons to trigger Undo/Redo operations. Macabacus' Undo/Redo options can be set in the Excel Undo / Redo section of the Settings dialog (see below). You can set the maximum number of cells for which Macabacus Undo/Redo is available—however, too many cells may slow performance. Select which formatting properties you want Macabacus to undo/redo (deselecting properties may improve performance), or disable Macabacus' Undo/Redo capability altogether. Macabacus' Undo/Redo solution is not perfect due to limitations of Excel's development environment.
![Mac Mac](/uploads/1/2/5/6/125608799/719431305.jpg)
As a result, you may experience differences between Macabacus' Undo/Redo functionality and native Undo/Redo functionality. For example, Macabacus cannot undo row/column insertion/deletion.