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 包括300多種用於Excel的便捷工具,可以在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 · 6 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 · 7 years ago
    Thanks a lot, for your solution, some time small things make us crazy.