blocks|key|2243032|text|打开你的谷歌电子表格。|type|ordered-list-item|depth|inlineStyleRanges|entityRanges|data|2243033|在顶部，单击File+>+Print。|2243034|选择“打印设置打印:当前工作表”(默认)。|2243035|打开设置自定义分页开关。|2243036|将这些行拖到页面应该断开的位置(每个矩形将在其自己的页面上打印)。|2243037|📷|atomic|offset|length|2243038|完成后，单击“确认中断”。|2243039|来源：https://support.google.com/docs/answer/7663148|unstyled|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://i.stack.imgur.com/SU45I.png|imageAlt|1|LINK|MUTABLE|url|https://support.google.com/docs/answer/7663148^0|0|0|0|0|0|0|1|0|0|0|3|1A|1^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1B|8|@]|9|@$M|1C|N|1D|1|1E]]|A|$]]|$1|O|3|P|5|6|7|1F|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1G|8|@]|9|@$M|1H|N|1I|1|1J]]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]|11|$5|12|W|13|A|$14|15]]]]

<ol>
<li>Open your Google Spreadsheet. </li>
<li>At the top, click File > Print.</li>
<li>Choose print setting Print: Current sheet (default).</li>
<li>Turn on Set custom page breaks toggle. </li>
<li>Drag the lines to where
the page should break (each rectangle will print on its own page). 

<a href="https://i.stack.imgur.com/SU45I.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SU45I.png" alt="enter image description here"></a></li>
<li>When you’re done, click Confirm breaks.</li>
</ol>

Source: <a href="https://support.google.com/docs/answer/7663148" rel="nofollow noreferrer">https://support.google.com/docs/answer/7663148</a>

blocks|key|263192|text|您还可以将数据分割成不同的工作表(底部的选项卡)，然后打印所有工作表。并不理想，但它适用于简单的电子表格。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

You could also split your data up into different sheets (tabs on the bottom) then print all sheets. Not ideal, but it works for simple spreadsheets.

blocks|key|263177|text|咕噜法-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263178|将行添加到第一页底部(如果需要大量填充空间，请使行高更大)|263179|用白色背景填充空行，并删除任何行和/或框|263180|点击打印-抖动，直到你得到你想要的。|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|J|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|K|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|L|8|@]|9|@]|A|$]]]|H|$]]

Grunt method -

Add rows to bottom of first page (make row height larger if you need a lot of fill space)

Fill empty rows with white background and remove any lines and/or boxes

Click print - jiggle around until you get what you want

blocks|key|2242864|text|我发现打印“每一张纸”的最好方法是冻结页眉。选择要打印的行。打印。在“打印选项”下，确保选择打印选定的帧并打印第一行。对于一个分页，它的工作量也差不多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

I have found the best way to print "each sheet" is to freeze the header. 
Select the rows you want to print.
Print. under the print options make sure to select the print selected frames and print the first row. It is just about the same amount of work for a page break.

blocks|key|263238|text|从床单上拖出来就行了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263239|在纸的左上角的空白方格中有厚厚的灰色线。您可以拖动这些行并创建一个分页。如果在拖动时使框变大，则拖错了灰色线。在工作表的页眉中找出最粗的一行。|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|F|8|@]|9|@]|A|$]]]|D|$]]

Just drag from the top of the sheet. 

There are thick grey lines in the blank square on the top left of the sheet. You can drag these lines and create a page break. If you are making boxes bigger when you are dragging, you are dragging the wrong grey line. Find the thickest line in the header of the sheet.

blocks|key|263278|text|没有分页符，但是..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263279|选择要打印的位|ordered-list-item|263280|复制|263281|文件->新->文档|263282|粘贴在文档中|263283|到处乱跑，直到很漂亮|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|O|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|P|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$]]]|M|$]]

There are no page breaks, but..

<ol>
<li>Select the bit you want to print</li>
<li>Copy</li>
<li>File -> New -> Document</li>
<li>Paste in the document</li>
<li>Squiggle around until it's pretty</li>
</ol>

blocks|key|2243097|text|我发现第一个答案是正确的，但在添加以下细节时更容易理解。在桌面上，添加谷歌驱动应用程序，然后登录到“谷歌驱动器”--仍然在桌面上，打开您的工作表项目(即使您一直在开发平板电脑，因为“驱动器”管理了所有的谷歌文档、工作表和幻灯片套件)，然后选择print+....make，如果您没有在google上安装打印机，就可以选择“打印”功能(而不是空气打印)。打印机只需要在您的WiFi网络上。在您选择“打印”之后，它将带您通过打印机设置。(同样，不要选择again+)所以在完成了所有这些步骤之后，打印功能为我提供了分页选项。我无法仅仅使用我的iPad+Pro上的sheets应用程序添加分页符，也无法点击打印。(但说明并没有说“留在床单”应用程序中)，我希望这能帮助到其他人，因为我非常沮丧地试图在不破坏大多数项目的情况下完成这一任务。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|entityMap^0^^$0|@$1|2|3|4|5|6|7|C|8|@]|9|@]|A|$]]]|B|$]]

I found the first answer correct but easier to understand when adding the following details. On a desktop, add the google drive app, then log into “google drive” - still on a desktop, open your sheets project ( it will be here even if you had been working on a tablet since “drive” manages all the google docs, sheets, &amp; slides suite of apps ) then select print ....make sure to select the google print feature ( not air print ) If you don’t have a printer set up on google print, it’s easy. A printer just needs to be on your WiFi network. It will walk you thru the printer setup after you select print. ( again, don’t select air print ) so having completed all these steps the print feature offered me page breaks as a option. 
 I was not able to add page breaks using just the sheets app on my iPad Pro and hitting print. ( but the instructions didn’t say stay in the sheets app ) I hope this helps someone else as I was very frustrated trying to accomplish this without trashing most of a project.

blocks|key|2243154|text|咕噜法-对我有用。只需通过编辑保持缩放和页边距设置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2243155|刻度设置必须始终保持不变，我选择了“适合宽度”并继续保持页边距|2243156|页边距设置也必须保持在外面，我选择了‘宽’和继续添加行。|2243157|📷|atomic|offset|length|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://i.stack.imgur.com/S2kSv.png|imageAlt^0|0|0|0|0|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@$I|W|J|X|1|Y]]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Grunt method - worked for me. just keep Scale and Margin settings through out edit.

Scale Settings must be kept all through out, I chose 'fit to width' and continued to margin

Margin Settings must be also kept through out, I chose 'wide' and continued adding rows.

<a href="https://i.stack.imgur.com/S2kSv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S2kSv.png" alt="Google Sheets Print settings"></a>

I want to force a page break after a certain row of a sheet. Is there some analogue of Google Docs’ (and Excel’s) “insert page break” for Spreadsheets?

If there is no “native” way to do this, maybe there is some hack (using functions / add ons / whatever)?

How to force a page break in Google Spreadsheets

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我想在某一行的工作表之后强制分页。是否有类似于谷歌文档(和Excel的)“插入分页”的电子表格？如果没有“本机”方法来实现这一点，那么可能会有一些黑客攻击(使用函数/添加on/什么的)？

问如何在Google电子表格中强制分页
EN

回答 8

Web Applications用户

Web Applications用户

Web Applications用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Google电子表格中强制分页EN

回答 8

Web Applications用户

Web Applications用户

Web Applications用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Google电子表格中强制分页
EN