Ask Your Question

Contain characters within cell, even when adjacent cell empty? [closed]

asked 2017-08-04 00:37:26 +0200

appreciatethehelp gravatar image

updated 2020-08-08 23:41:19 +0200

Alex Kemp gravatar image

Hey, is there any way to contain characters within a cell, even when the string of characters cannot fit within the cell as there are too many, and the cell adjacent cell immediately to the right-hand side is empty?

Note, I do not want to shrink the text to make it fit, nor wrap text automatically to achieve this; I want the text to "run off" the cell as it cannot fit, with the two little red arrows to either side of it. However, I don't want it to spill over into the next right-hand horizontally-adjacent cell visually, as this makes the spreadsheet look cluttered. This happens automatically when the adjacent cell contains figures of any kind, but when (the adjacent cell) is empty, the text from the original cell in question runs into the adjacent cell visually, which I want to avoid.

Sorry for the (more than likely) rather convoluted explanation; if it is insufficient then I can upload an image illustrating this issue on request.

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-08-04 13:44:33.918599

1 Answer

Sort by » oldest newest most voted

answered 2017-08-04 01:22:22 +0200

librebel gravatar image

updated 2017-08-04 01:22:56 +0200

Hello @appreciatethehelp,

Try set the horizontal text alignment to "Filled"

menu "Format : Cells ..." .. Text Alignment Horizontal = Filled

edit flag offensive delete link more


Perfect! Thanks.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-08-04 13:43:58 +0200 )edit

Question Tools

1 follower


Asked: 2017-08-04 00:37:26 +0200

Seen: 48 times

Last updated: Aug 04 '17