Alternative to ctrl shift enter in excel

ALTERNATIVE TO CTRL SHIFT ENTER IN EXCEL HOW TO

IРІР‚в„ўve since edited and retagged this as a feature request so it is clearer and hopefully can be implemented at some point. This will present a major issue with any future adoption of open source as this feature is used frequently by office workers (myself included). Update: Apparently there is no simple way of doing what I have described above. So is there something simple (obtuse) that I just overlooked or is this software still not ready?

ALTERNATIVE TO CTRL SHIFT ENTER IN EXCEL HOW TO

IРІР‚в„ўm fairly certain that РІР‚СљIРІР‚Сњ could get similar functionality using the python features, but one shouldnРІР‚в„ўt need to know how to program to use basic features. IРІР‚в„ўve been wanting to move my entire extended family to an Open Source Alternative for years now (since 1999) but there are common tasks that have either been overlooked or have a huge (unacceptable) learning curve when coming in at the level of an average office worker knowledgebase. CSE array formulas will truncate the return area if it's too small, or return N/A's if too large. Will automatically resize as data is added or removed from the source range. IРІР‚в„ўve scoured google for more time than I should have the only thing that comes even close to what IРІР‚в„ўm looking for is ArrayFunctions which doesnРІР‚в„ўt provide the behavior described above. The dynamic array formula technically only exists in cell D1, whereas with a legacy CSE formula, the formula would need to be entered in the entire range.

I just canРІР‚в„ўt seem to do this with LibreOffice. One of the most common features I use in excel is the Ctrl+Enter/Ctrl+Shift+Enter that allows one to put a formula in a single cell and populate each successive row/column with the corresponding row/column variables whether it be a vertical selection, or a horizontal selection (slightly different behaviors). IРІР‚в„ўm coming from a Microsoft Office background.

Alternative to ctrl shift enter in excel