in this section, we'll take a look at all the issues and problems you may deal with when you go to print and how to resolve them. We'll also basically take a look at all the options you have available to you when you go to print your work from Excel. To continue your Excel journey with hands-on training, join us for Excel training in NYC or Online, with top instructors, step-by-step exercises, and more, at a state-of-the-art training facility.
Printing can be controlled through the page layout tab. In fact, that's where we'll spend most of our time. If I go and click on page layout there, this is the area where I will see all my page setup options.
Now this section includes multiple topics. So that's why I have multiple taps here in order to efficiently go through this information. We'll have each topic take up its own tab. That way we can focus on one particular topic at a time and just complete that topic before we move on to the next one. These are the topics we're going to be covering.
We're going to take a look at how you can control your margins, your orientation, print area page breaks, print titles, scale to fit you in grid lines and headings and Hatteras and footers.
Now, I'll start out by saying and as you can see from the screenshot, that some of these options can be configured in the print preview window. Let's say I'll head over to the file tab and I click on print. This takes me to print preview. I can see what my print job is going to look like. But also on the left, in this second column pane, I can choose to change my margins, which is one of the first topics we'll take a look at. I can choose from normal, wide and narrow.
I can also control my orientation. Right now I'm in landscape orientation. I can change it to portrait. So let's dove into these topics and go through each one and take a look at how you can control your printing. So I'm going to go over to margins. Now my boss says to me, gar-field, I'd like you to print this on one page. And I say to myself, I don't know what he's talking about. This looks like one page to me. And then I'm informed that I should probably go into page layout to get a sense of what this is going to look like when I printed it. So if I go to The View tab, I can head over to the page layout button and if I click that, I will see what my boss is talking about.
The second page is only printing out column 9. Now I'll go back to normal view and show you another way that you can get to this. I'm going to click back on page layout, but now I'm going to head down towards the bottom right-hand corner and I have these three buttons here. If I hover my mouse over any of them, it'll tell me what they do. I'm looking for the page layout view. So if I click here. This is also another way to take a look at this print shop. All right. So now I have this. How am I going to make everything fit on one page?
Well, one strategy is to change the margins. So over and page layout, I'll click the dropdown. We have normal margins that give me point seven inches of space on both the left and the right. I wonder if I made that space smaller, if that could somehow include column 9 on the first page. So I'm going to try that. I'll head over to narrow and with one click. Everything now fits on one page and I can confirm that that's the case. I can see the print preview in the spreadsheet without going to print preview.
Now, something I might want to adjust is the fact that it looks like there's a lot more space over to the right than there is on the left. I want to center this information on the sheet. So I'll go over to margins and then I'll choose custom margins. This gives me an opportunity to adjust the margins to my preferred size, but I can also center the information on the page horizontally. I'll click, OK. And now that's much better. Let's continue and take a look at orientation. I'm asked to print this all on one page. I'm going to say, OK, I know what to do now.
I'll head over to page layout. I know exactly what they're talking about. Now two columns are being printed on page 2, 9 and 10. Are the columns being printed on page 2? I've been instructed not to touch the margins this time, so I need to find another solution. So this time, since we're on the orientation tab, I'll go to orientation. Perhaps this information would be best displayed in landscape mode that would allow space for more columns. Let me try that. I'll head over landscape. Problem solved. So that's a way that you could use orientation to make sure that everything fits on one page.
Let's continue and look at print area. Now, the problem here is not so much printing on one page, but printing specific information. Let me do a quick print preview now. Going forward, what I'm going to do is go to the quick access toolbar and add the print preview button. It'll make it much easier for me to go back and forth between print preview and my current view. I'll click here. Now, if I look down at the bottom, I see that the problem is I'm printing to 13 pages while 13 pages. Besides being an unlucky number, I want to find out why am I printing so many different pages? And when I look at my data, I see there's a lot of additional info. I only want to print the data.
I'm not too concerned that it's printing on two pages, especially since I have 13 currently.
So how I'm going to control that is by selecting the print area. I'm going to click somewhere in the table. I'll press control A.
When I press control A, it selects all the contiguous data. This is exactly what I want to print. I don't want to print anything else. I'll click the dropdown and she's set. Print area. What I'm doing here is I'm telling Excel. This is the area that I want to print. Then I'm going to head over to the print preview and take a look and see if that made a difference. When I look towards the bottom, it says one of two that actually did make a difference. I'm only printing to two pages so I can have additional info. I don't have to delete it. I don't have to hide it. I don't have to group it.
All I have to do is set the print area. Let's take a look at breaks. I'm being instructed to break this information up so that I only have 20 rows on the first sheet and the rest should go on the second sheet or page two. I want my information to display 20 rows of data at a time. So what I'll do is I'll select row twenty one.
Then I'll head over to breaks and then I'll choose insert page break. When I choose to insert page break I'm all of a sudden. Now on page 2 I'm going to scroll up and I can see this did exactly what I wanted. I wanted to print information that was only 20 rows long on page 1. And then when I go to page 2 I have the rest of the information on that second page. Let me zoom out so you can see. And that's what's happening there. So that's page break. Let's now go to page titles. So I'm going to discover the issue here by going over to print preview and selecting page two. So I'm on page one right now. I'm going to go over to page to. Oh, no headers, Page 3, no headers there as well, although the page for.
So that's the problem. People are not going to be able to understand the information on these sheets without headers. So I need to make sure the headers show up on each page.
I'll go back and I'll head over to print titles. If I click print titles, I'm going to look for an option that will allow me to repeat row 1 on all the pages. So I'm going to select row 1. Well, actually, first thing I need to do is select rows to repeat at top so I can click here. Then I'm in a select row 1 and you'll notice that row 1 is there with dollar signs.
This is the character that we use to lock cells into position. We learned this in absolute cell referencing. So now what I'll do now is simply click, OK. Now I want to check to see how this works. So I'll head over to my print preview. I'll go back to page three, page four and I can see the headers repeating at the top of each page. So job well done. Now I'm going to head over to scale.
Now I'm being instructed again to make sure everything fits on one page. I've been told not to change the margins or the orientation. So those two tools have been taken out of my tool box. I need to figure out a way for everything to print on one page so I'll head over the scale to fit. At this point, I usually ask students in the class, hey, when it comes to this particular print shop, is it a problem that this is printing to two pages?
Is that a problem of the print shop being too wide or too tall? And usually, people say too wide. That's perfect because when you go to scale to fit, you'll know exactly where to focus. You'll focus on width, you'll click the dropdown and you'll choose one page. What this will do is it'll make the print shop one page wide. What Excel is actually doing is shrinking the font so that everything fits on one page. So that solves this situation. I didn't have to change the margins or orientation.
Let's go to grid lines and heteros. I have a print job and what I want you to know is as we've been working in this sheet, you haven't been seeing any grid lines. That's because we took it off to make it easier to read. But I can turn them back on. I'll simply go to view. Well, before I do that, let's take a look at a print preview. This is how the print job looks. I would like to display grid lines. So let me go back and go to The View tab and I'm going to check the checkbox for grid lines. Now I see the grid lines.
Let me do a print preview and see if I can see them. I still don't see them, so turning on gridlines visually on the sheet is not what's gonna have them display. What I'm in I need to do is go over to page layout. And when I look at sheet options, there's an option called print under grid lines. This will make sure that the grid lines are now printed. I'll click the checkbox here. I'll do a print preview. Now I can see the grid lines and this is what makes the gridlines print. I'll go back. I also would like to see the column letters in the row numbers. I'll select the checkbox for print here. Then I'll do a print preview. Now I see the column letters in the row numbers. So if I really wanted to prove to someone that I was printing from an actual Excel spreadsheet, I can do that.
Headers & Footers
The last thing we'll take a look at are headers and footers, headers and footers are not located on page layout. On page layout tab, where we'll have to go for that is the insert tab. If I click insert and start to move all the way over to the right, I'll see header and footer 1. Click on header and footer. And now I am actually placed in the header. That's where my cursor is. I have a brand new tab, something I should also pay attention to because this will give me options for what can go in the header or the footer. So I'll make sure that I'm in the header and there's my header footer.
Then I'm just going to type in the word company. So for your situation, maybe you want your company name at the top on every single page. Now I want to go to the footer. If I click on Go to footer, it'll take me directly to the footer and I'm there. What can I incertain in the header or the footer?
I can insert the page number. Total number of pages. The current date. The current time. The file path of this workbook. The name of the workbook. The name of the worksheet. And with picture I can choose to insert a company logo. I have all those options available to me, but I'm going to do something that I think is pretty cool. I'm going to add the total number of pages as well as the current page them on. I can use a template for that's available in the dropdown for footer when I'm looking for is page one of question mark.
The question mark is the stand-in for the total number of pages. One-click and I'm puzzled. I didn't see what happened there. I've lost my head and footer. All I have to do is head down towards my footer and I'll see it now, says page 1 of 2 and page 2 says page 2 of 2. Let's do a quick print preview. There it is. And if I go to Page 2, I see it there as well.
So we just looked at how we could access several different options related to printing from page layout and also adding a header and a footer.