Look Who it Was Random video

Excel - Printing Header Rows or Columns on Each Page Using Excel Page Setup - Episode 690

2,905 views · Published 19 February 2009 · 2:16 · Indexed 14 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Printing Header Rows or Columns on Each Page Using Excel Page Setup.

Welcome back to another MrExcel netcast! In today's video, we're going to be discussing page setup in Excel. I've received a couple of questions about this topic, so let's dive in and see what we can learn.

First off, let's clarify that when we talk about repeating rows or columns, we're referring to the ability to have certain rows or columns appear on every page when printing. Some viewers have asked if it's possible to have rows or columns repeat at the bottom or right side of the page, but unfortunately, Excel only allows for repetition at the top and left side.

Moving on to the second question, some viewers have noticed that when they try to use the "Rows to repeat at top" option, the page number doesn't change on each page. This is because they are using the wrong tool. Instead, we can go to "File" and then "Page Setup" and select the "Header/Footer" tab. From there, we can choose to include the page number in the header, which will automatically update on each page.

Now, you may be wondering if it's possible to have something repeat at the bottom of every page. The answer is yes! By utilizing the header and footer options, we can have something appear at the top and bottom of each page. Unfortunately, there isn't a good way to repeat columns at the right side of each page, but the header and footer options are still a great solution for dynamic page numbers.

In conclusion, while there may be multiple ways to achieve the same result in Excel, it's important to understand which tools are best suited for each task. In this case, using the header and footer options is a more efficient and effective way to include page numbers on each page. I hope this video has been helpful and thank you for tuning in to another MrExcel netcast. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Can you specify rows to repeat at the bottom? Can you specify columns to repeat at the right? Can you have a dynamic page number in the "rows to repeat at top" area? If you are asking these questions, I think you need to investigate the Page Setup Header/Footer tab. It will solve most of these questions. Episode 690 shows you how.

Table of Contents:
(00:00) Questions about page setup in Excel
(00:19) Setting rows to repeat at top 
(00:39) Dynamically changing page numbers 
(01:01) Using custom header for page numbers 
(01:30) Dynamic page numbers with header and footer 
(01:55) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alternative methods for adding page numbers in Excel
How to create dynamic page numbers in Excel
How to repeat content at the bottom of every page in Excel
How to repeat rows at the bottom in Excel
How to repeat rows at the top in Excel
Limitations of repeating columns at the right in Excel
MrExcel netcast on Excel page setup and dynamic page numbers
Page Break Preview in Excel
Removing page numbers from cell A1 in Excel
Using headers and footers for dynamic page numbers in Excel
Using the Header/Footer tab in Excel page setup
YouTube tutorial on Excel page setup


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152204/

More from this channel