Hello Office Insiders!
I’m Steve Kraynak, a Program Manager on the Excel team. Your feedback shapes Office, and today we’re featuring that with the Click to Add Mode feature in Excel for Mac.
The Click to Add Mode feature was part of Excel 2011, but was not part of subsequent versions. Bringing it back was our #5 most requested suggestion on UserVoice, and had a significant amount of feedback in our centralized feedback system. We have heard you and once again made the feature available!
To enable the feature, select Menu > Preferences > Enable Click to Add Mode. Then you can type = and click cells to create a formula to add the cell values. To temporarily disable Click to Add mode, just hold down the OPT key when you’re editing a formula.
The Click to Add Mode feature is running in Excel for Mac on Insider build 16.37 (20041301) or later.
We typically release features over some time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.
If you like this feature, please send your feedback by clicking the 🙂 button in the top right corner of Excel. You can also send feedback and suggestions by clicking Help > Feedback in Excel.
Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!
Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month!