![]() How to Print Each Page of an Excel Worksheet on Just One Page Our guide continues below with additional information and pictures for each of these steps. Click the Print Active Sheets button, then select Print Entire Workbook.Click the Fit to option, then set it to 1 page wide by 1 tall.Right-click a worksheet tab at the bottom of the window and click Select All Sheets, or hold down the Ctrl key and click each individual sheet that you want to print. ![]() How to Set Up the Selected Worksheets So That They Each Print on One Page Fortunately Excel lets you select multiple worksheets at once and apply the same changes to all of them. Unfortunately the same method does not work when you go to print an entire workbook, so you need to find an alternative method to set each worksheet page of an Excel 2013 workbook to fit on one page. Maybe you’ve already learned how to configure a worksheet to avoid these problems, and you now need to apply that fix to multiple worksheets in the same workbook. Worksheets can easily run off of a single page and wind up wasting a lot of paper, or they can print as a giant mess of data. Microsoft Excel is a great program for managing your data, but it can be a frustrating application when you need to print out that data in a manner that is easily digestible. When you have an Excel workbook with a lot of individual worksheets, you might need to print all of those sheets at once, and you may want them each to fit on one page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |