Center text alignment across multiple cells without merge?

It is equal to Center Across Selection in MS. I see the old method in 2016 does not work at 7.6

Reference

Perhaps you misunderstood this method and are now trying to use it incorrectly?
image

Please show me what data and how you are trying to place it in which cells

I’ve hopped from LO Calc and Base to Google Sheet + Apps Script + Appsheet for over 2 years.

@lonk So that’s why you haven’t been seen for so long! Well, I’m glad for you! I hope that you will always have the Internet and access to Google resources.

1 Like

Note that there was tdf#42958 about import of the Excel feature (which turns into merged cells in Calc); but I couldn’t easily find a feature request in our bug tracker, even after these years.

@JohnSUN Hello my teacher, I’m still missing you and @Ratslinger

1 Like

I am also looking for this center across selection info. The information put up by JohnSUN doesn’t do what I am after. I have a horizontal range of cells and I’m trying to center text across about 10 cells. It’s only a single row. I hope someone can point me in the right direction on how to do this.

It works for me, text from cell A2 is centred across 10 columns. Adjust the Indent to suit.