Viewers: in countries Watching now:
In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.
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 department. So let's click on the first person here in the Finance department, and page breaks are something that we insert. So let's put in page breaks.
So click here on the Page Layout tab, choose Breaks, and insert a Page Break, and you see that we now have the dotted line across. Well, let's try that again. Let's go to the first person Graphics department, click Breaks, and Insert Page Break. Well if you have a long worksheet and you want to put in a lot of page breaks, this gets really old, really fast. So Excel has a great feature that will repeat the last thing you did. Now it also works in the other Office programs. To repeat the last thing you did, all you have to do is press the F4 key on the keyboard.
So let's go over here. Here is the first person in Human Resources, press F4, and that puts in a page break because the last thing we did was Page Break. Scroll down, click before the first person in IT, press the F4 key, the first person in Marketing, press F4, click the first person in Sales and press F4. Now let me repeat because it's very important. The F4 key is not the shortcut to insert a page break. The F4 key will simply repeat the last thing you did. So if I click something and make it bold, and I click somewhere else and press F4, it makes that bold also.
I will just press Ctrl+Z couple of times to undo. So that's a very handy feature to know. Anyway, let's look at our Print Preview. Go back to the File tab, and Print. Okay, so now we have everybody in the Executive department and we see we now have seven pages and click through. Well, we have everybody in Finance and everybody in Graphics, in the other departments, but we don't have those headers there. So we have to find some way of doing that. So I am going to just press the Escape key. So we are back in the Page Layout tab and click Print Titles and this brings us into the Page Setup dialog box in the Sheet tab.
You see over here its says Rows to repeat at top? Click in there and now let's select down the row headers from Row 1, down to Row 4, and you see this is repeating at the top, Row 1 to Row 4, and you see that's absolute reference so don't worry about that. Click OK. Now it doesn't look anything has changed here but let's go back to the Print Preview. I will just press Ctrl+P, so here is page 1. It looks the same as it did before, but now when you click through, here is page 2, the Finance department, click again, Graphics department, Human Resources, and so on.
Now I had mentioned in an earlier movie that you can split the screen into top and bottom, left and right halves. That has nothing to do with printing. So if you want multiple pages to have repeating rows at the top, you need to use this feature of putting in print titles.
There are currently no FAQs about Excel 2010 Essential Training.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.