FAQs
Click the Page Layout tab on the ribbon. 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. To print your worksheet on a single page, choose 1 page in the Height box.
How do I scale a sheet to fit a single page in Excel for Mac? ›
Click the Page Layout tab on the ribbon. 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. To print your worksheet on a single page, choose 1 page in the Height box.
How do I make an Excel spreadsheet fit on one page PDF on a Mac? ›
However, Mac users may need to adjust the "Scale to Fit" settings slightly differently. To do this, click the "File" tab and select "Print." Click the "Scale" option and select "Fit Page." It will ensure that your Excel sheet fits on one page after you convert it to a PDF.
How do you print worksheets on separate pages in Excel? ›
Insert a page break
- Click the worksheet that you want to print.
- On the View tab, in the Workbook Views group, click Page Break Preview. You can also click Page Break Preview. ...
- Do one of the following: ...
- On the Page Layout tab, in the Page Setup group, click Breaks.
- Click Insert Page Break.
On the File menu, click Print. In the Print box, click Selection in the drop-down list. Click Print.
How to pdf an Excel sheet on one page? ›
How to export Excel as PDF as one page? Under “Scaling”, select the “Fit to” option. Add “1” to “Pages in width” and “1” to “Tall”. Now head to File > Save As.
How to print specific sheets in Excel? ›
On the Printer menu, select the printer that you want. The default is to print all active sheets. To change what is printed, select Show Details. In the Print drop-down menu, select the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then select Print.
What can you do to make an Excel worksheet fit on one page when you print it besides reducing the font size? ›
How to make an Excel sheet fit to a page using the Print Preview option
- Click on the "File" tab.
- Click on the "Print" option. ...
- On the left part of the screen, you can see a "Settings" menu. ...
- Select the drop-down menu under "No Scaling" and select "Fit Sheet on One Page."
Print a sheet on one page
On the Page Layout tab, select Page Setup. Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK. On the File menu, select Print.
How to adjust page size in Excel for printing? ›
Reduce or enlarge a sheet to fit the page
- On the Page Layout tab, select Page Setup.
- On the Page tab, select the Adjust to check box, and select the percentage to reduce or enlarge the sheet. Note: Printed data never exceeds 100%.
- On the File menu, click Print.
Check print range and settings: Make sure the print range is properly set in Excel. Select the desired cells or range that you want to print, then go to the "Page Layout" tab and check the print settings such as orientation, margins, and scaling. Adjust them as needed.
Why is my Excel spreadsheet cut off printing? ›
Look at your page margins. From the Page Layout Ribbon, click the icon for Margins. To minimize the number of printed pages, choose the option for Narrow, or select Custom Margins, and set up your own. Remember to leave at least a little space for margins to give your printed spreadsheet room to breathe (Figure B).
