Provide an option to create a text editor over a rectangular region of user selected cells
The current options for including a block of multi-line text in a sheet are either typing into a region of merged cells or using a floating textbox object. Both forms have substantial usability issues. For example, entering text into a region of merged cells requires hitting Alt-Enter to insert line breaks meaning two key strokes which is in contrast to the universal accepted way of pressing Enter. Furthermore, this option does not support rich styling such as bullets or any of the text alignments in the Ribbon home tab. On the other hand, a floating textbox object, while providing a rich editing experience lacks what I consider to be “seemingless sheet integration” meaning the object does not fully obey the constraints imposed by the sheet grid structure. It also uses a completely different option-set UI for styling the text region (borders, background, text direction etc…) and while there is an option for a floating texbox object to auto-resize when the grid resizes, I consider this a form of mitigation for not being treated as valid cell input. Here are some issues which are not addressed by this mitigation: 1) When inserting a textbox into a dense grid it’s not obvious at all at which cell the textbox lands since it is placed somewhere relative to the mouse cursor down right which makes the initial position of textbox practically unpredictable. 2) You need to remember to activate snap-to-grid in order resize the textbox object so it can be accurately positioned along cell boundaries. 3) Formatting the textbox object requires selecting the entire shape and therefore, it's very easy to move it by accident when working with a touchpad, aging mouse or simply having a fast workflow.
See other issues which are applicable to floating objects in general:
4) Find... and Replace... are not supported inside a Floating Textbox object.