Excel 2010 Essentials: Repeating Row and Column Titles


show more Repeating row and column titles provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 bre...

Repeating row and column titles
Video duration: 3m 34s 6h 21m Beginner

Viewers:

Repeating row and column titles provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...