Click the No Scaling button, then click Fit Sheet on One Page. Page orientation and margins can also be adjusted here, by way of the respective commands under Settings. Click Print. Click Kutools Plus > Printing > Print Multiple Selection Wizard.. 2. 1. 1. It won’t look pretty. Because of this, Excel assumes that each individual sheet has to be sent for printing separately, so it will send it in the same way to the PDF printer which will prompt to create a PDF from each sheet. How to set a page break before printing Excel spreadsheets. After finishing selecting those certain worksheets, click File > Print > Print to print all selected sheets at once.. Introduction to Page Setup in Excel. The printer’s Document Properties dialog box. If you shrink it too much, the font can become tiny and hard to read. In a workbook with small amounts of related data on each of several worksheets, printing all of the worksheets on a single page may be the best way to review, reference, or capture that data. It's also possible to print worksheets on the two sides of a single sheet. In this tutorial I’ll show you a very quick and easy way to print your Excel sheet on one page. I am on Office 365 on a Mac. If your spreadsheet contains a lot of rows or columns, it may break at an inappropriate place when you print it. Worksheets. Learn: The Quick & easy way on How to Print Large Data in Excel In this video, you will learn: How to 1. Steps to formatting an excel file to print: Open the excel and if there are multiple worksheets (tabs at the bottom), start with the first one; If you want everything on the sheet to print, make sure no … how to print in one page. Fit All Columns on One Page. For example, if you wish to send out only a specific portion of a larger sheet, or you don’t want it to be editable. edit. To select sheet, hold Ctrl key and left click sheet one by one. Click the Print button. Login/Signup to Answer. It is possible to print as many as 16 Excel worksheets worksheets on a single page. This happens because one (or multiple) sheets in your workbook have a different dpi setting for printing. Go to the Page Layout tab, click Margins, and select Narrow or Custom Margins. Summary – fit a spreadsheet on one page in Excel 2010. Whilst you have the spreadsheet open click the (File) tab. By default, Excel prints sheets at their actual size. Select this option if your data spans many rows and columns. ; In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic.Columns will now appear on one page, but the rows may extend to more than one page. If you print out a large spreadsheet without setting print areas, you run the risk of outputting hard to read, unformatted pages. I have excel 2016 and I created a big sheet, and I want to "print" it out on Din A1 paper. I have fit to page selected as well as 1-page wide to 1-page long selected. Page Setup in Excel (Table of Contents) Introduction to Page Setup in Excel; How to Setup Page in Excel? 5. On Windows, you can enter your first and last page numbers in the "Pages" section to print out only a range of pages from the document. If you have a worksheet with lots of data, you can scale the document in order to fit the worksheet on one page. Click on the No Scaling option (last one in the list). The steps below will show you how to adjust the settings on your spreadsheet so that the entire thing fits on one page. You can customize this, and select a single page or a specific page range to print. Fit Sheet on One Page. Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.. You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. Assuming you know a little bit about Excel, it really isn’t that hard. Often you may come up with a situation where you need to print the excel sheet which you have with yourself, containing some important data that needed to be shared as a hard copy. (See Figure 1.) Excel displays the printer's Properties dialog box. 2. Even some Windows users prefer to use third-party screenshot tools and screen capture extensions in order to take a full page screenshot and adding things like annotations, comments, blur sensitive info, and many more.. edit flag offensive delete link more add a comment.