Ask Your Question

Different alignment of different lines of text within a cell? (on mac) [closed]

asked 2017-03-15 08:12:29 +0200

appreciatethehelp gravatar image

Hey guys- here is an example to clarify the problem I am having:

C:\fakepath\Separate alignment example.ods

As you can see, this document contains different "categories" ("finance", "business" and "resources"), as shown in bold, red, underlined capitals. This text is centered, which is what I want.

However the black text beneath this text is also centered, which is not what I want. I want the black text to be aligned with the left hand cell margin.

I don't know how to separate the red "category" text from the black text so that I can keep the red text centered and align the black text with the left hand cell margin, as the only way I know of to force a line break in calc is to use command > return, which makes a new line but not a new paragraph, meaning all text before the forced line break is grouped together with text after the line break, therefore any alignment changes will affect all lines of text within the cell.

In writer I would just need to start a new paragraph after entering the "category" text by pressing return to force a line break, but in calc pressing return simply enters the text in the cell and deselects the cell. Shift > return, which in writer forces a line break within the same paragraph, does the same thing in calc as pressing return - enters the text in the cell and deselects the cell.

Any help with this would be just swell, fellas!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-03-15 12:51:42.026289

1 Answer

Sort by » oldest newest most voted

answered 2017-03-15 08:22:35 +0200

Mike Kaganski gravatar image

Cells to Calc are what paragraphs to Writer. There's no "Paragraph properties" in Calc that you may apply to part of cell. So, if you need what you describe, please use two cells.

edit flag offensive delete link more


Of course. I wanted the red and black text to not be separated by a line; to both exist in the same cell, so I did as you suggested by using two cells and then hid the border between them.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-15 12:50:31 +0200 )edit

Question Tools

1 follower


Asked: 2017-03-15 08:12:29 +0200

Seen: 42 times

Last updated: Mar 15