Ask Your Question

Office calc can I center text across multiple cells with out using Merge cell

asked 2016-07-20 12:46:26 +0200

Pilsbury 99 gravatar image

updated 2017-12-10 17:14:22 +0200

erAck gravatar image

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.

edit retag flag offensive close merge delete


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?

lonk gravatar imagelonk ( 2018-11-28 03:32:45 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-07-28 14:09:08 +0200

erAck gravatar image

You can set left alignment and under Format Cells Alignment options specify an Indent value.

edit flag offensive delete link more

answered 2016-07-20 17:31:18 +0200

peterwt gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-20 12:46:26 +0200

Seen: 1,175 times

Last updated: Jul 28 '16