![]() To do this, choose the View tab, then the Workbook Views section and press the Page Layout button. To check what the printout will look like, you need to change from the standard Normal view of your document (see the first image in this post) to the Page Layout view. How do I check if my header row will be printed on every page? But this doesn’t carry over to the printout. When you’re using Excel itself, you can freeze the rows and/or columns so you can see them as you scroll down. If you’ve got a complicated spreadsheet that you want to print out in a report, as a handout, or as a pdf, it’s useful to have the header row show on every page. Why would I want my header rows to print out on multiple pages? (If your columns have headings in Column A instead or as well as your rows, you can use all of the stages in this post but choosing the columns option where appropriate, or both.) ![]() It’s usually Row 1, or maybe a few rows at the top of the spreadsheet. The header row is the row in a spreadsheet that contains the headings for all of the columns in your spreadsheet. This post will tell you how to make your header rows (or columns) in Excel 2007 and Excel 2010 print on multiple pages when you print them out. I recently wrote about retaining your headers across multiple pages in a Word document.
0 Comments
Leave a Reply. |