UrbanPro
true

Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Printing Worksheets In Excel

ITech Analytic Solutions
03/01/2018 0 0

i. Quick Print:

If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.

  • Choose File » Print (which displays the Print pane), and then click the Print button.

  • Press Ctrl+P and then click the Print button (or press Enter).

ii. Adjusting Common Page Setup Settings:

You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc.

  • The Print screen in Backstage View, displayed when you choose File » Print.

  • The Page Layout tab of the Ribbon.

iii. Choosing Your Printer:

To switch to a different printer, choose File » Print and use the drop-down control in the Printer section to select any other installed printer.

iv. Specifying What You Want to Print:

Sometimes you may want to print only a part of the worksheet rather than the entire active area. Choose File » Print and use the controls in the Settings section to specify what to print.

  • Active Sheets: Prints the active sheet or sheets that you selected.

  • Entire Workbook: Prints the entire workbook, including chart sheets.

  • Selection: Prints only the range that you selected before choosing File » Print.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Sparklines
Sometimes you may want to analyse and view trends in your data without creating an entire chart. Sparklines are miniature charts that fit into a single cell. A Sparkline is a tiny chart in a worksheet...

Excel Tip: Use Index Or Match Instead Of Vlookup Or Hlookup.
Hi, In today's Excel topic we will see how Index & Match function is superior than Vlookup/Hlookup. With Index and Match, the return value need not be in the same column as the lookup column, unlike...

Tableau is a Good tool for Visualisation
Tableau is one of the best BI Tool we use to show the Data in a Visualization Mode. Tableau is a very Powerful & Fastly growing data visualization tool used in the field of Data Analytics. It will...

Variations Of Random Forest In R
One of the important steps in using analytics to generate insights is model fitting. Typical projects involve a lot of data cleaning so that high accuracy is achieved on application of the model. Competitions...

Datedif() Function
Purpose: This function calculates difference between two dates. it can show the result in days, months and years. Syntax: =datedif(start_date,end_date,"unit") start_date This is earliest...

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for BI Reporting Classes?

The best tutors for BI Reporting Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn BI Reporting with the Best Tutors

The best Tutors for BI Reporting Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more