EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Formula and Functions Outstanding Ways To Create Print Command Button in Excel
Secondary Sidebar
Excel Functions
  • Excel Formula and Functions
    • Compatibility Mode in Excel
    • VLOOKUP Names
    • Advanced Formulas in Excel
    • Excel Function for Range
    • Excel Template for Payroll
    • Excel Sum Time
    • Payroll in Excel
    • Complex Formulas in Excel
    • Pivot Chart in Excel 2016
    • Advanced Excel Formulas
    • Best Basic Excel Formulas
    • Use Excel As Your Calculator
    • Print Command Button in Excel
    • Excel SUM MAX MIN AVERAGE
    • Excel Basic Functions For Beginners
    • Interactive Excel Dashboard
    • Features of 2016 Excel Workbook
    • What's New In Excel 2016
    • Microsoft Excel Skills
    • Microsoft Excel Shortcuts
    • Microsoft Excel Tips and Tricks
    • Excel Skills
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Excel Training
  • Excel Advanced Training
  • Excel Data Analysis Training

Outstanding Ways To Create Print Command Button in Excel

By Madhuri ThakurMadhuri Thakur

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 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 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 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, sheets 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 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, 2nd and 3rd 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 5 copies, then the 1st page will get printed 5 times, the 2nd page will get printed 5 times, and the 3rd 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 setups. 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 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 margin,s 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 through it may not look g,o 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.

Popular Course in this category
All in One Excel VBA Bundle (120+ Courses)
  120+ Online Courses |  500+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
Excel Advanced Training (16 Courses, 23+ Projects)4.8
Excel Data Analysis Training (17 Courses, 8+ Projects)4.7
3 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more