From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Repeating row and column titles

Repeating row and column titles - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Repeating row and column titles

“

Okay, so here we have our worksheet of people who work in the company and you see this is sorted by Department in Column C. And let's say we want to make a printout and we want to give the head of each department a list of all the people in their department. So we want to make one page for the Executive, another page for Finance department, another page for Graphics department and so on. Well, let's take a look at Print Preview. You could either press Ctrl+P or click the File tab to go in the Backstage view and click Print, and now we can see all right this looks fine. Now there are two pages, so go down over here and click this arrow to look at page 2, but on page 2 we can't see what any of those titles are, so it's kind of hard to read. And if we go back here, we can see again all of the departments are printed on the same page, which isn't quite what we want. So you can just press the Escape key so we are back to the Home tab. What we want to do is put in a page break before each…

Contents