blocks|key|385414|text|Google不包括自定义文本行高度的设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|385415|解决方法之一是将垂直对齐设置为中间，并将行高更改为足够大的大小。|385416|📷|atomic|offset|length|385417|备注：|385418|当OP说“行”时，它们实际上是指行。|ordered-list-item|385419|对于多行单元格，为了增加行间距，解决方法是：。|385420|在每一行中包括一个字符的大小|385421|在行之间插入空行。|385422|385423|相关|385424|如何在Google电子表格中的单元格中添加新行？|unordered-list-item|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://i.stack.imgur.com/PYEOt.png|imageAlt|1|LINK|MUTABLE|url|https://webapps.stackexchange.com/q/25359/88163^0|0|0|0|1|0|0|0|0|1|1|1|0|0|0|O|1^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1E|8|@]|9|@$G|1F|H|1G|1|1H]]|A|$]]|$1|I|3|J|5|6|7|1I|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1J|8|@]|9|@]|A|$]]|$1|N|3|O|5|M|7|1K|8|@]|9|@]|A|$]]|$1|P|3|Q|5|M|7|1L|8|@]|9|@]|A|$]]|$1|R|3|S|5|M|7|1M|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1O|8|@]|9|@]|A|$]]|$1|W|3|X|5|Y|7|1P|8|@]|9|@$G|1Q|H|1R|1|1S]]|A|$]]]|Z|$10|$5|11|12|13|A|$14|15|16|-4]]|17|$5|18|12|19|A|$1A|1B]]]]

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.

<a href="https://i.stack.imgur.com/PYEOt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PYEOt.png" alt="Toolbar button vertical align - Middle"></a>

NOTES: 

<ol>
<li>When the OP says "lines" they actually are meaning rows.</li>
<li>For multi-line cells, in order to increase the interline spacing, the workarounds are:

<ol>
<li>Include a the size of one character on each line</li>
<li>Insert a blank line between lines.</li>
</ol></li>
</ol>

Related

<ul>
<li><a href="https://webapps.stackexchange.com/q/25359/88163">How does one add a new line in a cell in a Google Spreadsheet?</a></li>
</ul>

blocks|key|385468|text|您可以使用CHAR(10)添加粗体间距如下：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|385469|="The+world"&CHAR(10)&"is+mine!"|header-two|entityMap^0|5|8|0|0|W^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]]|I|$]]

you can use <code>CHAR(10)</code> to add brute spacing like:

<code>="The world"&amp;CHAR(10)&amp;"is mine!"</code>

blocks|key|385495|text|这很简单，只需选择要更改高度的行，并在任何选定行的索引上拖动，就好像通常要拖动以更改单行的高度一样，但在这里，如果拖动任何一行，它会自动反映所有选定行的高度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

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.

blocks|key|2365676|text|解决办法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2365677|使用“硬返回”将文本拆分为多行。|ordered-list-item|2365678|在每个项目之间插入空行。|2365679|选择空行。|2365680|为空行指定字体大小。|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|M|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$]]]|K|$]]

Workaround:
<ol>
<li>Use hard returns to split your text over multiple lines.</li>
<li>Insert empty lines in between each item.</li>
<li>Select the empty line.</li>
<li>Specify a font size for the empty line.</li>
</ol>

blocks|key|2365755|text|https://www.modernschoolbus.com/changing-cell-padding-in-google-sheets/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2365756|我不为上面的链接文章取任何信用。这应该能回答OP关于细胞填充的问题。还请注意，PDF的各种创建方式将有所不同。如果打印到PDF不起作用，请尝试另一种导出和/或生成PDF的不同打印引擎的方法。|entityMap|0|LINK|mutability|MUTABLE|url^0|0|1Z|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|C|$]]]|F|$G|$5|H|I|J|C|$K|4]]]]

<a href="https://www.modernschoolbus.com/changing-cell-padding-in-google-sheets/" rel="nofollow noreferrer">https://www.modernschoolbus.com/changing-cell-padding-in-google-sheets/</a>
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.

blocks|key|385452|text|选择要更改行高的行。把线拖到你想要的高度。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

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

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

How to change the text line height in one cell?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在最近版本的Google中，我找不到更改文本行高度(单个单元格中行间距)的选项。当您将电子表格导出为PDF时，您会更加意识到这个问题，因为这些行彼此非常接近，这使得阅读起来很不舒服。总之，调整直线高度是有帮助的。我喜欢给文本行之间的一些间距(一长行，不分裂的文本在不同的单元格)。

问如何更改一个单元格中的文本行高度？
EN

回答 6

Web Applications用户

Web Applications用户

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

Web Applications用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何更改一个单元格中的文本行高度？EN

回答 6

Web Applications用户

Web Applications用户

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

Web Applications用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何更改一个单元格中的文本行高度？
EN

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