Outstanding Ways To Create Print Command Button in Excel

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 re alignment on the same. So the worksheet we will be looking at is the sheet 1 and here we have our own set of masterpiece and where we have 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 there is different settings which are available here and also there is preview that is available for the print option. When you look at the print preview , this is  the page 1 so if you look at closely this page 1, then it looks like the page 1 is  slightly incomplete because of the whole table is not coming as such it does not come and in fact  this chart also goes away. Let us look at page 2. Page 2 only contains some incomplete information regarding the regarding the earlier set of 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 print out. 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 print out 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 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 to kind of select your printer which one is ready so 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 set 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 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. At this stage I don’t want to do that 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 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. Now the other option that you can see is that if you have to print only selective page let 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 2 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 these 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 5 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 that means collated. The other option is that it has totally uncollated version so say for  example if you have provided 5 copies then the 1^st page will get printed 5 times, the 2^nd page will get printed 5 times and the 3^rd page will get printed 5 times and you will have to manually collate it. So you can look at various options which you require in terms of printing the set ups. The other aspect of print set up 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 height which is bit smaller then 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 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 among 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. Now in order 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 in order to show the margins. So these are the margins, what happens is when my table is printed there is a suitable margins 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 print set. There is another think which is available that is if you want to fit all the data in one page through it may not look go you have an option just click here fit sheet on one page and the movement you do you can see that all pages gets fitted.

Recommended courses