8

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).

0
2

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

2
  • This works only for texts with 1 line.
    – srrvnn
    Jan 16 '19 at 17:33
  • @srrvnn I updated my answer.
    – Rubén
    Jan 16 '19 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.

0

Workaround:

  1. Use hard returns to split your text over multiple lines.
  2. Insert empty lines in between each item.
  3. Select the empty line.
  4. Specify a font size for the empty line.
0

https://www.modernschoolbus.com/changing-cell-padding-in-google-sheets/

I don't take any credit for the above linked article. This should answer the OP's question regarding cell padding. Please also note that the various ways in which PDF is created will differ. If printing to PDF does not work, try a different method of exporting and/or different printing engines that produce PDF.

New contributor
RyuuToshihiro is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
2
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    2 days ago
  • While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
    – Glorfindel
    yesterday
-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.