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

Lookup and Reference Examples

  • Approximate match with multiple criteria in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to get address of named range in Excel
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Left Lookup in Excel

Data Analysis Examples

  • Excel Frequency Function Example
  • How to Create Gantt Chart in Excel
  • Excel Pie Chart
  • Move chart to a separate worksheet in Excel
  • Create Scatter Chart in Excel

Data Validation Examples

  • Excel Data validation must not contain
  • Prevent invalid data entering in specific cells
  • Excel Data validation must begin with
  • Excel Data validation only dates between
  • Excel Data validation date in next 30 days

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 setup and print Excel worksheets

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 choose page/paper size in Excel before Printing

3. Click OK.

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

Worked Example:   Print Page Numbers 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
  • How to count specific characters in a cell in Excel
  • Two ways to Compare Text in Excel
  • How to strip protocol and trailing slash from URL in Excel
  • How to check if cell contains all of many things in Excel
  • How to check if cell contains one of many things in Excel
  • Count times in a specific range in Excel
  • Calculate total hours that fall between two times in Excel
  • WORKDAY function: Description, Usage, Syntax, Examples and Explanation
  • Convert Unix time stamp to Excel date
  • Convert date to month and year in Excel
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest rate for loan in Excel
  • RECEIVED function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles