Abstract
Excel allows you to enter a tremendous variety and amount of data into one worksheet and then extract only the data you need to share with clients or employees. Sometimes you don’t need to print the entire workbook or the entire worksheet. In this chapter, you’ll be learning how to view and print only the data relevant to your task. You may be dealing with a geographic area or a certain salesperson, and you only want to show what is relevant to each person. Print layout view lets you see how worksheets will look when printed, which is very important because screenshots can be quite different from the final printed product. You will learn different ways to view your spreadsheet, divide your worksheet into multiple panes and use the Synchronous Scrolling feature. You will create Custom views that allow you or other users to switch back and forth between different views of the same spreadsheet. An example would be you create one view to show all your data, a second view to show certain columns, and a third view to print a portion of a worksheet.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 David Slager and Annette Slager
About this chapter
Cite this chapter
Slager, D., Slager, A. (2020). Different Ways of Viewing and Printing Your Workbook. In: Essential Excel 2019. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6209-2_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6209-2_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6208-5
Online ISBN: 978-1-4842-6209-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)