Click Kutools Plus > Printing > Print Multiple Selection Wizard.. 2. Find the Fit To option and set it to one page wide by one page tall. To force Excel to print your spreadsheet on one page do this: 1. Excel displays the Print dialog box. Print the worksheets. You can also leave one of the boxes blank, e.g. Make sure that in the Print screen (File > Print) under Settings the option to print double sided is selected. Now click the Print button (in the left hand menu). On the Page tab of the Page Setup window, and look in the scaling section of the window. Fit All Columns on One Page: Use this option to place all your columns on one page. 3. 4. In the wizard dialog, add the selections you want to combine into one page by clicking Add button one by one.. 3. Go to File>Print, and change the scaling option at the bottom of the settings to Fit Sheet on One Page. How to print Excel spreadsheet on one page. This shrinks your whole table down so that it will fit on one page. Click on the No Scaling option (last one in the list). 5. Just follow the steps below. To change the print selection, close print preview by clicking on the X, and repeat the previous steps.. To print the entire worksheet, click File > Print > Print.Make sure Entire Sheet is checked, and click Print.. Click the Print button to open the Print Menu. Click on the File tab on the top left-hand corner, and afterwards select Print. Asked: 2018-10-12 22:52:37 +0100 Seen: 4,587 times Last updated: Oct 13 '18 2. Complete the following steps to scale a document when printing. Under Settings, select Fit Sheet on One Page from the Scaling drop-down list. This setting makes the worksheet scale to fit on just one page when printed. So, the bigger your worksheet, the more pages it will take. If you ever have the need or desire to print several worksheets on one page in MS Excel, you can do it. https://www.makeuseof.com/tag/print-excel-spreadsheet-one-single-page In the Page Setup window, on the Page tab, you can choose Landscape or Portrait and have to set the Scaling to 1 by 2 pages or 2 by 1 pages, depending on your exact needs. 1. Step5: or you can click the Print button at the bottom of the Page Setup window, it will open the Print pane. By default, Excel prints sheets at their actual size. 2. In most cases, this is the worst idea as the printed data will be almost unreadable if your data has a lot of columns. If you shrink it too much, the font can become tiny and hard to read. Whilst you have the spreadsheet open click the (File) tab. There are 3 options to scale your worksheet: Fit Sheet on One Page: Choose this option when you want to print all your worksheet data in one page. 1. Excel displays the Properties dialog box for the printer. After free installing Kutools for Excel, please do as below:. Note: if all of the worksheets are not selected, you can click the Print Entire Workbook option to print the entire workbook. You should see that your worksheets have all been set to Fit Sheet on One Page.Then click the Print button, it will print all of the selected worksheets.. Go to the Page Layout tab, click Margins, and select Narrow or Custom Margins. Click the Properties button. 1 by pages. Stats. In the 'Print What' area of the dialog box, choose Entire Workbook. If you have the Excel desktop application, you can set more print options. Scale your sheet. Choose Print from the File menu. Click File in the top left Then click Print to print your document .