A spreadsheet with a lot of data can quickly turn into a jumbled mess. You can help make it easier lớn read by using column and row headings, but endless cells of data all containing similar values are just difficult khổng lồ read. & if you need to print that spreadsheet for someone lớn view on paper it can be even worse, especially if the spreadsheet is more than one page in length. The mặc định setting in Excel 2013 will only display your column headings on the first page, and anyone reading a printed version of the spreadsheet would need to lớn manually match up each column with that column heading. If you have ever tried to do this with, for example, a sales spreadsheet where sales totals are listed consecutively by month right next to lớn each other, then figuring out which column is for June sales and which one is for July sales can be frustrating. But you can configure a setting in Excel 2013 that will print the top row of your spreadsheet at the đứng đầu of every printed page, thereby making it easier lớn read.

Bạn đang xem: How to print header rows in excel 2016

Repeat the đứng top Row in Excel 2013 When You Print

The instructions in this article are going to focus on repeating the đứng top row, because that is the location most commonly used for column headings. But if your spreadsheet has the row that you want khổng lồ repeat located somewhere besides the đứng đầu row, you can select that location instead of the vị trí cao nhất row in the instructions below.

Step 1: xuất hiện the Excel 2013 spreadsheet for which you want khổng lồ repeat a row at the đứng top of every page, then make sure that you are scrolled khổng lồ the vị trí cao nhất of the spreadsheet.

Step 2: Click the Page Layout tab at the đứng đầu of the window.

*
*
*
*
*
*
*
*
*

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s & Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

Xem thêm: Sơn Tùng M Ưa Ngang Qua Vietnam Idol, Cơn Mưa Ngang Qua

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, và Photoshop, but he has also written about many other tech topics as well.