Outstanding Ways To Create Print Command Button in Excel

Updated June 9, 2023

Part -24 – Excel Print command

Transcript For The Video – Excel Print Command

In this set of video tutorial on “Excel Print Command,” we are going to learn how we can look at various print options, and even before we make the print, we can actually look at the virtual copy, whether it is right or wrong or we have to do some realignment on the same. So the worksheet we will be looking at is sheet 1, and here we have our own set of masterpiece, and where we have a different set of tables as such. And let’s go to file, and there is this print option. So the moment we select this print option, you can see different settings available here, and also, there is a preview that is available for the print option. When you look at the print preview, this is page 1, so if you look closely on page 1, then it looks like page 1 is slightly incomplete because the whole table is not coming as such. It does not come this chart also goes away. Let us look at page 2. Page 2 only contains some incomplete information regarding the earlier set of the table that we had. Now let us look at what is page 3. Page 3 is again the other half of the first page and also the chart that was left. So probably, this is the preview if we are to print this worksheet; this is how we will get in terms of the printout. So probably, you may not like this at this stage. So we have to kind of do some adjustments here and there so that when we take a printout, it looks really professional. So let us look at various print options in much detail. On top, you will find this is the print icon, and to select the number of copies you want to print, you can adjust it from here. So let’s say if I want 5 copies, I can select 5 here, or you can mechanically type 15 copies or 10 copies, 1 copy, or 2 copies as such. So let me keep it itself. If your printer is online, it will show online, or else you may come to kind of select your printer which one is ready, to say, for example, here, this printer is ready for use. So the moment I give the print, it will print the pages which I am looking at in the worksheets. Now there are other sets of settings which are available, so one of the settings are print active sheets. If you see in the drop-down, there are various options to print active sheets, and that is what I want, and do you want to print an entire workbook from sheet 1, sheet 2, sheet 3, and sheet 4? I don’t want to do that at this stage, so I will probably select only active sheets. Do you have any selection for printing? No, I haven’t done that. I just want my full sheet 1 to be printed, so or do you want to print only the selected table? There are various options which you can look at for printing. For the time being, I am just keeping it as print-active sheets. The other option that you can see is that if you have to print only a selective page, let’s say page 1 and page 2. So in this worksheet, as you may have noted that there are three pages, they are 1, 2, and 3, and I just want to print only two pages. So page me and page 2 or page 1 to page 1, so this will print only the first page so you can also look at this set of options. So, for the time being, let me have page 1 to page 3. What will this collated means? Let’s say if I am printing multiple copies, say, for example, if I am printing five copies, so the collated version will be the 1, 2^nd and 3^rd page will be printed first, and you can keep it as a separate copy that will be the first copy. The second full copy, which consists of three pages, will be printed next, which means collated. The other option is that it has a totally uncollated version, so say, for example, if you have provided five copies, then the 1^st page will get printed five times, the 2^nd page will get printed five times, and the 3^rd page will get printed five times, and you will have to manually collate it. So you can look at various options which you require in terms of printing the setups. The other aspect of print setup is very important i.e. orientation here; we have the portrait orientation. Here you can see the layout of the page; we can see the height of the page is more than the width. This is the portrait orientation, and the other one, which has a height which is a bit smaller than the width. This is known as landscape orientation, depending on what kind of data you have or what kind of presentation you are preparing. You can actually choose between the two. So let me try and choose landscape orientation just to show you what happens when there is this kind of variation. So the moment I do that, you can see that the page layout has changed a bit, and I can kind of look at more data on the right-hand side, but I have less data at the bottom. Because I have lesser height which is available because of the landscape orientation. Let us look at page 2; this is page 2, page 3, and page 4. So this is also unevenly formatted or organized for the printing setup. However, it still looks better, as you can see in this table which is more in terms of width. A landscape orientation is making probably more sense as compared to the portrait orientation. So I will just keep landscape orientation for the time being. Then you can also select various kinds of letter formats or the page format that you have, the normal format that is really available in A4 sheet, which is readily available for print. You can have different options, i.e., legal letter A5 or envelope size. So you can choose the one which is required. The default one is the letter format, so I will quickly change it to A4 format because I have A4 sheets available in my printer. The other thing is the margins that you want to look at.To explain these margins, let me go on the print preview, and as you can also see at the bottom right-hand corner, I will just click here to show the margins. So these are the margins. What happens is when my table is printed, there is a suitable margin between the edges and the tables. So this is known as margins. By default, it contains normal margins, you can have wider margins, one inch each on the left and the right-hand side, and there are custom margins also, which you may like to select as far as your requirement goes. So that’s what you can do in terms of a print set. There is another thing that is available: if you want to fit all the data in one page though it may not look good, you have an option, just click here fit sheet on one page, and the movement you do, you can see that all pages get fitted.