5

I could not find an option in the recent version of Google Sheets to change the text line height (the spacing between lines in a single cell).

You realize the problem even more when exporting the spreadsheet as PDF, the lines are very close to each other which makes it uncomfortable to read.

Summed up, it would be helpful to adjust line heights. I like to give the text lines some spacing to each other (one long line, no splitting of the text over different cells).

migrated from superuser.com Sep 6 '16 at 8:09

This question came from our site for computer enthusiasts and power users.

1

Google Sheets doesn't include a setting to customize the text line height.

One workaround is to set vertical align to Middle and change the row height to a size big enough.

Toolbar button vertical align - Middle

NOTES:

  1. When the OP says "lines" they actually are meaning rows.
  2. For multi-line cells, in order to increase the interline spacing, the workarounds are:

    1. Include a the size of one character on each line
    2. Insert a blank line between lines.

Related

  • This works only for texts with 1 line. – srrvnn Jan 16 at 17:33
  • @srrvnn I updated my answer. – Rubén Jan 16 at 17:47
0

you can use CHAR(10) to add brute spacing like:

="The world"&CHAR(10)&"is mine!"

0

Its easy, just select the lines which you want to change the height and on the index of any selected line drag as if you would normally drag to change height of single row, but here if you drag any one of the row it automatically reflects the height of all selected rows.

-2

Select the lines you want to change line height on. Drag the lines down to height you want.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.