How to Repeat Cell Lines at the Top of Each Page in Microsoft Excel 2007

Next Video:
How to Put Two Sets of Data on One Graph in Excel....5

Repeating cell lines at the top of each page is something that you can do if you have a very long spreadsheet. Repeat cell lines at the top of each page with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to repeat the cell lines at the top of each page in Excel. This is something that's very helpful to do when you have a long spreadsheet with many lines, and you have some headers lines at the top, and you don't want to go through manually and make new header lines where each page break would appear. Instead, you want to be able to use the same header lines that just appear once on the spreadsheet, but then when you print it out, they appear at the top of each page. So I've got a spreadsheet set up here with just some made up financial data, and I'm gonna show you the steps to do what I'm talking about. Now, it may be different, depending on your particular computer and operating system, on this particular operating system on the Mac in this particular version of Excel you go to the page setup menu. I think on Windows it may be when you actually go into the print menu, and then there will be page setup options. But what you want to look for is on this one under the page setup option you go to sheet, and you'll see print titles, rows to repeat at top and columns to repeat at left. So I'm just gonna show you how to do it where you, the rows repeat on the top, but you can see that if you had many columns that would go on to different pages you would do a similar thing there. So what I'm gonna do here is I'm going to put the cursor on the rows field here, and I'm gonna go over to the spreadsheet and select the rows that I want to appear. In my case it's just the top row. If it was more than one row, you could, you would select them. And so what appears here is, is basically Excel's notation for row one, and I'm gonna say okay, and then I'm going to print, I'm not actually gonna print, but you'll be able to see what happens. I'm gonna say print, and then in the, in the screen here you can see this is like a preview of what you're gonna see. It's gonna be four pages, and let's just slowly scroll through the pages. You can see on page two, the headers are going to appear. On page three and page four, the headers are going to appear. Just what we want to do. And then of course we click on print. So I hope this has been helpful. I'm Ted, and today I showed you how to repeat the cell lines at the top of a page on each page in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!