Forum Discussion
How to type in a one cell and have span across multiple cells in excel
How to type in a one cell and have span across multiple cells
Only text values can be displayed across the cells to the right if the text is too long for the cell itself, but only if those cells are empty. If the cell to the right is populated with a value or formula, the text will be truncated.
Number and date values will not be displayed across cells.
You can, of course, select multiple cells in a row and set horizontal alignment to 'Center across selection', and it is also possible to merge cells.