Different Ways of Viewing and Printing Your Workbook

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.