I would like to place text across multiple cells with out using merge cells. I would like to be able to draw a line down the center of these cells. If I merge them this cannot be done.
Yes.
It is important for us to create a formula covering the vertical cells by dragging mouse or down arrow key.
Merged cells will block that. And it is very important for the report of accountants.
Is ‘Center across selection’ available now?
Provided there enough empty cells to the right of the cell that contains more text than the width of the cell can accommodate then yes. It will display and print correctly.
You can set left alignment and under Format Cells Alignment options specify an Indent value.