Active Sheets," so you can select multiple sheets, and then go to your print option. So, let's say I'm going to select Index, hold down Control, select the second one, and then go back to Print Preview, and I get both of them show up here in the order of the tabs. Okay, so that's method number one. The second method is to go to File, Export, select Create PDF, and then click on Create PDF. Give it a name, and then click on Publish. The last option, and.
This is the one I tend to use often, is to go to File, Save As, then from this drop down, select PDF. Give it a name, and then click on Save. All of these options provide me with a nice PDF report. Now, all of that is nice, but what if I want to print these three tabs? So, right here, I have a Training tab. I have all these cells with dark gray in the background, I don't want them to be included in the PDF. I just want this white area included. Then, I have this report and I want this.
To be in landscape format. And this one should be vertical but the data goes over many pages, and people lose sight of the column headers, I want those included. If I go ahead and highlight these and do what we did before, I'm going to end up with a PDF that looks like this. Yeah, it doesn't look professional, values are being cut off here, and there are no page numbers. I wouldn't want to send this to my boss; it looks like I have no idea what I'm doing. The solution is super simple. It's.
Called Page Setup. That's where you need to go to make the corrections you need. Let's do that quickly. Let's start correcting this sheet. If I go to Print Preview, notice that the page currently runs over to 3 pages and I have all these gray cells included. I don't want that. I only want to see the form. The solution is right here. Page Layout, under Page Setup, you're going to find Print Area, that's what we need. But before we use this, we need to select our print area. So,.
Adjust the width and the height. So, let's say I want the width to be 1, and I want the height to be 1, and the scale is automatically going to adjust to make it fit these requirements. So now, if I go back to Print Preview, I get everything on a single page. Now whenever you're using this option, make sure that your scale isn't too low, right? Because otherwise, everything is going to be very difficult to read. Now, another thing I want to add to this page are page numbers. Because if.
You're printing more than one page, it really helps to add page numbers. We can do that from here as well. Just go to More Options by clicking on this arrow, Header/Footer. For Footer, we're going to add page numbers. I'm going to go with this version, Page 1 of question mark, and then you can either just take a look at it in the Print Preview. Currently, it looks like this because I only have one sheet selected. If I had more, I would see 1 of 2, 1 of 3, and so on. Okay, so now,.
Let's move on to the next one. I want this sheet to be printed in landscape format. So currently, if I go to Print Preview, it looks like this. What I'm also losing is the information that I have in the first two columns, right? When I'm looking at these numbers, I have no idea what app they're referring to. So, let's go and fix this. First of all, let's go to Orientation and change this to landscape form. Next, let's go to Print Titles. Here you can define what rows or columns you want repeated. So, in this.
Case, I want the first two columns to be repeated. So, we're just going to go and select these two columns, and while we're here, let's go to Header/Footer, and activate page numbers for this as well. And then, click on OK. Now, let's quickly take a look. We have Page 1 of 2. When I go to the next page, these are repeated. But now, it looks kind of weird when I have so much data on the first one, and then just two columns on the other page. I want to split it so that the first page only shows me.
January data, and all of this goes on the second page. I can fix that by managing my Page Breaks. I want to page break right here. Select the column, go to Breaks, and insert a page break. Now, when I go back to Print Preview, notice it looks a lot nicer. Now, you can also view all the page breaks in the View tab, under Page Break Preview, and you can adjust them if you need to by just dragging these. Now, let's go to our last sheet. This one currently looks like this. It runs over two pages, and I'm.
Posts Related:
- Meter Infographics - **Free Download** Powerpoint Presentation template slide Office
- How to Make Different Page Border in Microsoft Office Word Tutorial
- FULL VIDEO How To Design A Responsive Modal Popup For Your Blogger Website BlogSpot
Losing the information on the column headers; I want to add these. I'm sure you know by now how - ID Card Make
To fix that, right? We're going to go back to Page Layout and select Print Titles. This time, I want to fix the rows that I want to repeat on top. So, let's just go and select these ones, let's go to Header/Footer as well, and activate our page numbers, and click on OK. Now, let's take a look at all of these together. I'm going to hold down Control and select these three sheets. Ctrl + P to take a.Look at it in Print Preview. So, I have 1 of 5, these are the sheets that I having landscape form, and this is my last one. Okay, so everything looks great now. We can go ahead and print this to PDF. Now pick whichever option you prefer. You can save it as PDF, export it as PDF, or just print it directly from here. I'm going to call this one "Nice Report. Let's quickly take a look at it. So, what it comes down to is proper page setup. You can add the company logo as the header as.
Well if you want, or add other information to the footer or header, right? So, you can modify these as you need. Just keep in mind that it doesn't matter whether you're printing these on paper or you're printing as PDF, you're going to need to have a proper page setup before you do that. As you can see, it's that simple to convert your Excel files to PDF. You don't have to upload your file to another external app to get it done, which can also be risky, especially.
