Ask Your Question

How do I display a long text string in a spreadsheet?

asked 2017-01-05 16:32:44 +0100

Al Vesper gravatar image

I have a long text string in a spreadsheet cell and want it to spread over multiple cells in a row, and wrap to multiple lines. Is there a 'carriage return' character that could be embedded in the string? How do I input it? Other ideas please?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-05 23:28:50 +0100

robleyd gravatar image

Merge the cells in the row ; then from within the cell in Edit mode, NOT in the input line, use Ctrl-Enter for a line break.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-05 16:32:44 +0100

Seen: 171 times

Last updated: Jan 05 '17