Excel: Repeat Top Row on Every Page

Excel: Repeat Top Row on Every Page - Hallo sahabat Jendela Dunia Internet Dan Tekhnologi, Pada Artikel yang anda baca kali ini dengan judul Excel: Repeat Top Row on Every Page, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel Excel, Artikel Header & Footer, Artikel Printing, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : Excel: Repeat Top Row on Every Page
link : Excel: Repeat Top Row on Every Page

Baca juga


Excel: Repeat Top Row on Every Page

You guys might already know this, but I just learned something new about excel.

  1. On the “Page Layout” Ribbon, click the “Print Titles”.
    print tiles
  2. Click “Rows to repeat at top,” and click the icon that looks like a spreadsheet.
    page setup
  3. Use your cursor to click and select the row you wish to appear at the top of every page.
  4. Press the Enter and Click OK

You can use print preview to show you what it will look like.

P.S. For long printed documents, don’t forget to also add page numbers:

  1. On the “Insert” Ribbon, click “Header & Footer”
    header & footer
  2. Click on the Header or Footer area in which you’d like the messages to appear. This should open up the Header & Footer tools Context Sensitive Designer Ribbon.
    footer bar

    header & footer tools

  3. Then select Footer and insert any template or design you own
    footer tool

    This should insert the insert the text “Page &[Page] of &[Pages]” where “&[field]” will be replaced automatically

  4. You can also choose from any of the following fields:

    Element Name Text
    Page Number &[Page]
    Number of Pages &[Pages]
    Current Time &[Time]
    Sheet Name &[Tab]
    File Name &[File]
    File Path &[Path]&[File]


Demikianlah Artikel Excel: Repeat Top Row on Every Page

Sekianlah artikel Excel: Repeat Top Row on Every Page kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.

Anda sekarang membaca artikel Excel: Repeat Top Row on Every Page dengan alamat link https://jendeladuniainternet.blogspot.com/2015/05/excel-repeat-top-row-on-every-page.html

0 Response to "Excel: Repeat Top Row on Every Page"

Posting Komentar