How to repeat the headline when printing in Excel
The following article shows you how to repeat the headline when printing in Excel 2013.
Step 1: Select the Page Setup tab -> Print Titles .
How to repeat the headline when printing in Excel Picture 1
Step 2: A dialog box appears -> select the data area to print in Print Area , if you want to repeat the subject line, click Rows to repeat at top , if you want to repeat the column, select Columns to repeat at left -> OK .
How to repeat the headline when printing in Excel Picture 2
Note: You can choose the page format and paper size in the Option section.
Select print preview mode ( Print Preview ):
How to repeat the headline when printing in Excel Picture 3
On page number 2 the headline is always displayed at the top of the page.
Hopefully the article above helps you save your time. Good luck!
You should read it
- How to repeat titles in Excel 2007, 2010 and 2013 when printing
- Repeat titles in Word - Instructions on how to repeat titles in Word 2007, 2010, 2013, 2016
- Instructions for printing two-sided paper in Word, PDF, Excel
- How to use the REPT function on Excel
- How to fix the error of printing without finishing the page in Excel
- How to fix the error of printing missing documents in an Excel sheet
- Repeat the worksheet title when turning the page in Excel
- Some printing tips are essential in excel
- MS Excel 2007 - Lesson 13: Format sheets and prints
- Show you how to align the printed Excel file with A4 paper
- Instructions on how to print 2 sides in excel word
- Instructions for alignment in Excel - Adjust the margins for Excel before printing