Chapter 7

Getting Started with Excel Chapter-7: Printing Your Work Structure 1.0 Learning Objective 1.1 Introduction 1.2 Print Worksheets 1.3 Print workbook 1.4 Print Tables in Excel 1.5 Summary 1.6 References 1.0 Learning Objectives After studying this unit, you will be able to:  Explain how to use print in excel  Explain how to print worksheets in MS Excel  Explain how to print workbooks in MS Excel  Explain how to print Tables in MS Excel 1.1 Introduction You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table. You can also print a workbook to a file instead of to a printer. This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it. Page 48 of 59 All Rights Reserved. Vol. TLE001/03-2022

Getting Started with Excel 1.2 Print Worksheets  Print one or several worksheets Step-1: Select the worksheets that you want to print. Step-2: Click File > Print, or press CTRL + P. Step-3: Click the Print button or adjust Settings before you click the Print button.  Print all or part of a worksheet Step-1: Click the worksheet, and then select the range of data that you want to print. Step-2: Click File, and then click Print. Step-3: Under Settings, click the arrow next to Print Active Sheets and select the appropriate option. Step-4: Click Print. Page 49 of 59 All Rights Reserved. Vol. TLE001/03-2022

Getting Started with Excel 1.3 Print Workbooks  Print one or several workbooks Step-1: All workbook files that you want to print must be in the same folder. Step-2: Click File > Open. Step-3: Hold down CTRL click the name of each workbook to print, and then click Print.  Print a workbook to a file Step-1: Click File, and then click Print, or press Ctrl+P. Step-2: Under Printer, select Print to File. Step-3: Click Print. Step-4: In the Save Print Output As dialog box, enter a file name and then click OK. The file will be saved in your Documents folder. Page 50 of 59 All Rights Reserved. Vol. TLE001/03-2022

Getting Started with Excel 1.4 Print Tables in Excel  Print an Excel table Step-1: Click a cell within the table to enable the table. Step-2: Click File, and then click Print. Step-3: Under Settings, click the arrow next to Print Active Sheets and select Print Selected Table. Step-4: Click Print. Page 51 of 59 All Rights Reserved. Vol. TLE001/03-2022

Getting Started with Excel 1.5 Summary  You can print entire or partial worksheets and workbooks, one at a time, or several at once.  if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table.  You can also print a workbook to a file instead of to a printer.  This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it. 1.6 References https://support.microsoft.com/en-us/office/print-a-worksheet-or- workbook-f4ad7962-b1d5-4eb9-a24f-0907f36c4b94 https://www.oreilly.com/library/view/excel-2019- bible/9781119514787/c07.xhtml https://books.google.co.in/books?id=KihfEAAAQBAJ&pg=PT321&lpg=P T321&dq=chapter- 7:+printing+your+work+in+excel&source=bl&ots=f42DpuZ_GU&sig=ACf U3U03TQLEvpnNOyk- cgwPcLecfTEaKg&hl=en&sa=X&ved=2ahUKEwi_za364Yv3AhWrwosBHf xXBycQ6AF6BAgYEAM#v=onepage&q=chapter- 7%3A%20printing%20your%20work%20in%20excel&f=false https://study.com/academy/lesson/printing-in-excel-how-to-configure- workbooks-to-print.html Page 52 of 59 All Rights Reserved. Vol. TLE001/03-2022