How To Print Excel Spreadsheet On One Page

Open your workbook that containing the worksheet that you want to all print on just one page.

How to print excel spreadsheet on one page. Print multiple selections and fit to one page in excel with kutools for excel. 1 the salesperson ideally wants to print all the data in the current sheet text chart and table on one page. To print an excel sheet on one page choose one of the following scaling options that reside at the end of the settings section in the print preview window. Scaling an excel spreadsheet to a specific number of pages.

Press ctrl f2. To fit the entire excel sheet on one page type 1 into the pages wide and tall boxes. Click the page setup link to open the page setup window. Right click on the tab of any worksheet to display a short cut menu.

Select the correct paper size from the paper size menu and click ok click the print button to print the spreadsheet. You can access the print page using one the following. Fit sheet on one page this will shrink the sheet so that it fits on one page. Right click on any one worksheet tab at the bottom of the excel window then click the select all sheets option from the popup menu list.

Delete the value for the number of pages tall and leave it blank. Depending on your version of excel you might have to click file print preview file print print preview or just file print to see what your spreadsheet will look like when it comes out of the printer. Follow the file print path in the ribbon. First open the print page and go to the page setup window.

Click the page tab. If not try some of the strategies listed below. So the first thing to do is look at the current print preview. On the print window click the page setup link to open the page setup dialog.

Locate the worksheet tabs along the bottom edge of excels work area. Then it resizes print area and there is only one page to print. All worksheets should be selected in your workbook. 2 go to fileprint in order to see what the worksheet with the above data will look like if printed.

Once the dialog is. Enter 1 for the number of pages wide. Go to the scale to fitgroup under the page layouttab. Use the page layout view.

To change the scale factor manually click the adjust to radio button and then type the value into the box. To print only some of the worksheets hold down the ctrl key and click on the tab of each worksheet you wish to include. On the menu click the select all sheets option to group every worksheet. Change both of widthandheightto 1 page.

Press ctrl p.