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 - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Finding and replacing data3m 12s
-
Freezing panes3m
-
(Locked)
Repeating row and column titles3m 34s
-
(Locked)
Creating multiple custom worksheet views5m 18s
-
(Locked)
Hiding or grouping rows and columns5m 31s
-
(Locked)
Managing worksheets7m 23s
-
(Locked)
Calculating formulas across worksheets6m 5s
-
(Locked)
-
-
-
-
-
-
-
-