Note: The other languages of the website are Google-translated. Back to English
登陆  \/ 
x
or
x
注册  \/ 
x

or

如何在Excel中每页重复打印标题(第一行)?

通常,我们制作一些相当长的工作簿,并且它们溢出到几页。 通常,我们可以冻结第一行或第一列,以查看工作簿中每一页上的溢出数据。 但是,当我们打印这些长工作簿时,标题(第一行)消失了,除了第一页以外,不会在所有页面上打印。 实际上,我们可以指定页面设置设置,然后在每页上重复打印标题(第一行)。


使用“打印标题”功能在每页上重复打印标题

步骤1: 页面设置 组下 页面布局 标签,点击 打印标题 按钮。

步骤2:在“页面设置”对话框中,单击 标签。

步骤3: 打印标题 部分中,单击浏览器按钮以指定标题(第一行)。

步骤4:点击 OK 按钮。

现在,标题(第一行)将打印在每个溢出的页面上。

顺便说一句,如果您需要打印网格线,行标题和列标题,则可以检查 网格线 选项, 行和列标题 同一部分中“打印”部分中的选项 页面设置 对话框。


使用Kutools for Excel在每个页面上重复打印标题

有时,您可能需要在一页中每隔n行打印一次,并在每页上重复添加标题。 例如,您需要在一页中每20行打印一次,并在每页上添加标题。 在这种情况下,您可以将Kutools for Excel的 拆分为列 实用程序来完成它。

Kutools for Excel -包括300多个用于Excel的便捷工具。 全功能30天免费试用,无需信用卡! 立即免费试用!

步骤1:点击 Kutools Plus > 拆分为列.
doc拆分为列

步骤2:在打开的“拆分为列”对话框中,您需要:

(1)点击 按钮在 职称范围 框,然后指定标题范围;
(2)点击 按钮在 数据范围 框,然后指定要打印的范围;
(3)在“每页打印的行数”框中,指定要在每页上打印的行数;
(4)点击 Ok 按钮。

Kutools for Excel -包括300多个用于Excel的便捷工具。 全功能30天免费试用,无需信用卡! 立即行动吧!

步骤3:现在在新工作表中,您将看到将打印的范围将被指定的行数划分,并且标题将添加到每一页中。

现在你可以点击 文件 (或 办公室 按钮)> 打印 在一页中每n行打印一次,并在每页中添加标题。


使用Kutools for Excel轻松在每个页面上添加和打印标题/标题行

实际上,我们可以将Kutools用于Excel的 插入标题行 实用程序在每x行添加标题/标题行,然后将每x + 1行拆分为一个单独的页面。 请执行以下操作:

Kutools for Excel -包括300多个用于Excel的便捷工具。 全功能30天免费试用,无需信用卡! 立即免费试用!

1。 点击 库工具 > 插页 > 插入标题行 打开“插入标题行”对话框。

2.在打开的“插入标题行”对话框中,在 职称范围 框中,指定表格,但标题行除外 插入范围 框中,在 间隔行 框,然后单击 Ok 按钮。 参见上面的截图:

3.现在,标题行被添加到每x行。 如您所见,第一个标题行被重复。 请右键单击第一个标题行,然后选择 删除 从右键单击菜单中。

4。 点击 企业 > 复印机 > 每行插入分页符,然后在打开的对话框中输入间隔,然后单击 Ok 按钮。 看截图:

备注:插入分页符的间隔比插入标题行的间隔大1。

然后出现一个对话框,显示在活动工作表中插入了多少个分页符。 点击 OK 按钮关闭它。

到目前为止,我们已经在活动工作表的每一页上插入了标题行或标题行,如下图所示。 您可以点击 文件 (或 办公按钮)> 打印 打印每页的标题行。
doc列印标题12

Kutools for Excel -包括300多个用于Excel的便捷工具。 全功能30天免费试用,无需信用卡! 立即行动吧!


演示:在Excel中每页上重复打印标题(第一行)


Kutools for Excel 包括适用于Excel的300多种便捷工具,可以在30天之内免费试用。 立即下载并免费试用!

相关文章

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Big dog · 3 years ago
    Thank you!!
  • To post as a guest, your comment is unpublished.
    Jackie · 7 years ago
    I tried to print the top roll on every page, but it keeps telling me Reference is not available. What do I do ???
  • To post as a guest, your comment is unpublished.
    chukins · 7 years ago
    Thank you for making thins easier for me. I must agree with Tom Rowen, that the MS help tool is no help at all!
  • To post as a guest, your comment is unpublished.
    Usman · 7 years ago
    I want a line repeat on every page but I couldn't it you can suggest.
  • To post as a guest, your comment is unpublished.
    Tom Rowen · 7 years ago
    Thank you! I knew there had to be a way. It's not intuitive in Excel, and the MS Help tool is a joke. This page was a life saver. Thanks again!
  • To post as a guest, your comment is unpublished.
    JAGAN G · 7 years ago
    Thanks and very useful information with easily understanding format picture
  • To post as a guest, your comment is unpublished.
    BARKHA · 7 years ago
    Thank you so much for supporting me in any situation.........
  • To post as a guest, your comment is unpublished.
    CereusGraphics · 7 years ago
    I am very happy to be able to find this excellent article! After reading your article, I feel learned a lot of things, and we hope to see your next article, look forward to your masterpiece.
  • To post as a guest, your comment is unpublished.
    San · 7 years ago
    Great help. I check few websites for help before comming to this one.
    Thank youy.
  • To post as a guest, your comment is unpublished.
    Iqbal Hashmi · 7 years ago
    Pl let know the how to mention in Excel 2007
    How to repeat 2 rows in Every Pages
    example
    row 2 dise no
    Row 3 slno. name father name class

    Iqbal Hashmi
    • To post as a guest, your comment is unpublished.
      HelloKelly · 7 years ago
      hi,

      To print 2 rows repeatedly in every page:

      In the Step 3 click the browse button besides the Rows to repeat at top: box, and select the rows that you will print repeated in every page, such as $1:$2.


      Or you can type the $1:$2 directly in the box.


      To print first three columns, you can also type the $A:$C in the box of Columns to repeat at left:
  • To post as a guest, your comment is unpublished.
    Devendra Pahari · 8 years ago
    Thanks a lot, for your solution, some time small things make us crazy.