How to save Excel as PDF on one page
By
SpreadCheaters
You can watch a video tutorial here.
The PDF file format is commonly used when sharing information. Excel files can also be saved in PDF format but because of the spreadsheet layout, you need to first check the page layout. When saving an Excel sheet as PDF, the data must be formatted so that it is properly aligned on the page. Sometimes the rows and columns extend beyond the boundaries of a page so before converting an Excel file to a PDF you need to first fit it to a page.
Step 1 – Open the Print menu
– Go to File > Print
Step 2 – Expand the No Scaling menu
– Check the number of pages
– Expand the No Scaling menu
Step 3 – Fit the sheet
– Select Fit Sheet on One Page
Step 4 – Check the result
– Check the number of pages
– The sheet has been fitted to a single page
Step 5 – Open the Save As box
– Go to File > Save As
Step 6 – Save as PDF
– Give the file a name
– Expand the file type dropdown and select PDF(*.pdf)
– Click Save
Step 7 – Check the result
– Open the file in a PDF viewer
– The data is displayed on a single page
