Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Basic INDEX MATCH approximate in Excel
  • Get nth match with INDEX / MATCH in Excel
  • How to reference named range different sheet in Excel
  • How to retrieve first match between two ranges in Excel
  • How to use Excel LOOKUP Function

Data Analysis Examples

  • Managing Conditional Formatting Rules in Excel
  • How to sum a total in multiple Excel tables
  • How to create Gauge Chart in Excel
  • How To Filter Data in Excel
  • Everything about Charts in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Data validation must not exist in list
  • Excel Data validation must begin with
  • Excel Data validation specific characters only
  • Excel Data validation number multiple 100

Print Titles in Excel Worksheets

by

You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read.

To print titles, execute the following steps.

Worked Example:   How to choose page/paper size in Excel before Printing

1. On the Page Layout tab, in the Page Setup group, click Print Titles.

The Page Setup dialog box appears.

2. To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.

Worked Example:   How to Break Worksheets into Pages in Excel

3. Click OK.

Note: in a similar way, you can repeat columns at the left of each printed page.

Worked Example:   How to 'Center on Page' Print in Excel

4. On the File tab, click Print for a print preview.

The labels (LastName, Sales, Country and Quarter) appear on page 1 and page 2.

Post navigation

Previous Post:

Print Page Numbers in Excel

Next Post:

How to ‘Center on Page’ Print in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Extract middle name from full name — Manipulating NAMES in Excel
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • SUBSTITUTE function vs REPLACE function in Excel
  • How to extract word containing specific text in Excel
  • How to extract name from email address in Excel
  • Convert decimal hours to Excel time
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Dynamic date list in Excel
  • Convert text to date in Excel
  • Convert Excel time to Unix time in Excel
  • How to set check register balance in Excel
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
  • Example of Future value of annuity in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles