EDUCBA

EDUCBA

MENUMENU
  • Explore
    • Lifetime Membership
    • All in One Bundles
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign up
Home Excel Excel Resources Excel Formula and Functions Outstanding Ways To Create Print Command Button in Excel

Outstanding Ways To Create Print Command Button in Excel

Madhuri Thakur
Article byMadhuri Thakur

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, 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 five copies, then the 1st page will get printed five times, the 2nd page will get printed five times, and the 3rd 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.

ADVERTISEMENT
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests

Start Your Free Excel Course

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

ADVERTISEMENT
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
ADVERTISEMENT
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
ADVERTISEMENT
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Footer
Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
  • Blog as Guest
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

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

EDUCBA

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

Let’s Get Started

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

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

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

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

Forgot Password?

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

🚀 Cyber Monday Reloaded Price Drop! All in One Universal Bundle (3700+ Courses) @ 🎁 90% OFF - Ends in ENROLL NOW