Games  

Repeat the Field Names on All Pages

How to print row and cavalcade headers of Excel spreadsheets on every folio

Today I’d like to tell you most a small merely important characteristic tucked away in Excel 2016 and its previous versions. In this commodity you’ll learn how to make header rows and column headers impress on each page.

If you lot ofttimes have to impress large and complex Excel worksheets, I am sure that you face this trouble as oftentimes equally I do. I can hands scroll up and down through the certificate without losing sight of the column titles because I have the header row frozen. However, when I print the certificate, the top row is printed simply on the first page. If you are ill and tired of turning the printouts back and forth to see what kind of data is in each cavalcade or row, feel complimentary to find out the solution to the issue in this commodity.

Echo Excel header rows on every page

Your Excel document turns out to exist long and you demand to print it. You get to the print preview and find out that only the first page has the column titles at the top. Take it easy! You tin can specify the Page Setup settings to repeat the pinnacle row on every printed page.

  1. Open the worksheet that you’re going to print.
  2. Switch to the
    Folio LAYOUT
    tab.
  3. Click on
    Print Titles
    in the
    Folio Setup
    group.

    Click Print Titles on the PAGE LAYOUT tab to open the Page Setup dialog box

  4. Make sure that you’re on the
    Sheet
    tab of the
    Page Setup
    dialog box.
  5. Observe
    Rows to repeat at top
    in the
    Impress titles
    section.
  6. Click the
    Plummet Dialog
    icon
    Select range
    adjacent to “Rows to repeat at summit” field.

    Click the Collapse button to get back to the worksheet and select the rows

    The
    Page Setup
    dialog window is minimized and y’all go back to the worksheet.

    You tin find that the cursor changes to the black arrow. Information technology helps to choose an unabridged row with one click.

    Use the black arrow to select a row or several rows

  7. Select a row or several rows that you want to print on every folio.

    Note:
    To select several rows, click on the commencement row, printing and hold the mouse button and drag to the last row yous want to select.

  8. Click
    Enter
    or the
    Collapse Dialog
    button again to return to the
    Page Setup
    dialog box.

    Select rows and click the Collapse button again to return to the Page Setup dialog box

    At present your selection displays in the
    Rows to repeat at peak
    field.

    The reference means that the first row will be printed on every page

    Note:
    You can skip steps vi-viii and enter the range using the keyboard. However, pay attention to the manner you enter it – yous demand to use the absolute reference (with the dollar sign $). For example, if you want to see the first row on every printed page, the reference should await like this: $ane:$i.

  9. Click on
    Print Preview
    to run across the upshot.

    Go to the print preview to see the worksheet before printing

Popular:   Cool Ways to Write Ur Name

There you go! Now you know exactly what the columns mean on every page.

Get a header column on every printout

When your worksheet is too wide, yous’ll accept the header column on the left only on the outset printed page. If you want to make your certificate more readable, follow the steps below to print the cavalcade with row titles on the left side of every folio.

  1. Open the worksheet that yous desire to impress.
  2. Go through steps 2-4 every bit described in
    Repeat Excel header rows on every folio.
  3. Click the
    Collapse
    Dialog
    button to the correct of the
    Columns to echo at left
    box.

    Use the Collapse Dialog button to pick the columns to repeat at left

  4. Pick a column or columns that you want to meet on every printed page.
    Select columns that you want to see on every printed page
  5. Click
    Enter
    or the
    Collapse
    Dialog
    push again to cheque if the selected range is displayed in the
    Columns to repeat at left
    field.
  6. Press the
    Impress Preview
    button in the
    Page Setup
    dialog box to look at your document before printing.

    Preview your document before printing

Now you don’t accept to turn the pages dorsum and forth to find what the values in each row mean.

Excel usually refers to worksheet columns as letters (A, B, C) and to rows as numbers (i, 2, 3). These letters and numbers are chosen row and column headings. As opposed to row and column titles that are printed merely on the outset page past default, the headings are not printed at all. If you desire to come across these letters and numbers on your printouts, practice the following:

  1. Open the worksheet that you lot want to print with the row and column headings.
  2. Become to the
    Sheet Options
    group on the
    Folio LAYOUT
    tab.
  3. Check the
    Print
    box under
    Headings.

    Check the Print box under Headings on the PAGE LAYOUT tab to see the row and column headings on every page

    Note:
    In example you withal accept the
    Page Setup
    window opened on the
    Sheet
    tab, just bank check the
    Row and cavalcade headings
    box in the
    Impress
    section. It also makes the row and column headings visible on every printed page.

     Check the Row and column headings box in the Page Setup dialog box

  4. Open the Print Preview pane (FILE -> Print
    or
    Ctrl+F2) to bank check the changes.

    Go to the print preview to check the worksheet before printing

Popular:   Diablo 3 Only Available to Party Leader

Does information technology wait equally you desired now? 🙂

The Print Titles command tin can really simplify your life. Having header rows and columns printed on every page allows you to understand the information in the certificate more hands. You won’t lose your way in the printouts if in that location are row and column titles on each page. Try it out and you lot can only do good from it!

You may also exist interested in

58 comments to “How to impress row and column headers of Excel spreadsheets on every page”

Post a comment

Source: https://www.ablebits.com/office-addins-blog/2014/02/21/repeat-header-rows-excel/