Allowing Text to Overflow in Edit Mode
Overview
You can specify whether data can overflow into adjacent empty cells while edit mode is on in a cell. If you allow data to overflow into empty cells,
- Left-aligned data overflows to the adjacent right cell.
- Right-aligned data overflows to the adjacent left cell.
- When data is centered, data overflows to both the left and right adjacent cells.
When the user moves from the cell, the sheet automatically turns edit mode off and the text that will fit displays only in the active cell. To display overflow text in adjacent cells, see Allowing Cells to Overflow.
This setting is applied to all sheets in the book.