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


Other Lessons for You

Skill Enhancement Program | Industry Training | Atreya Associates
“Education is not the learning of facts, but the training of mind to think.” - Albert Einstein Skills are crucial to allow any person to manage their daily lives in this ever-changing world....

Different Data File Formats in Big Data
Overview In this lesson I will be explaining the different kinds of Data File formats used in Big Data, These are widely used but unspoken of. Anyone aspiring to be a Data Engineer/Data Analyst/ML...

4 Key Things to Learn for Data Science
1. Theory:Use Coursera and EdX for theory, concepts, and applications of probability, statistics, linear algebra, calculus, and machine learning.2. Data Visualisation:Tableau and PowerBI are easy-to-use...

How to add bullets Point in MS-EXCEL
There is no direct option to add bullets in EXCEL. So we can create the bullets by the following steps: 1. Select the range where you want to apply the bullets.2. go to formate cell ==> Custom Formate.3....

Pradeep Agrawal | 21/07/2020

0 0

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...

Harish TR | 11/11/2019

0 0

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

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

Book a Free Demo

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