How to make an Excel sheet fit on one page
You can watch a video tutorial here.
When printing an Excel sheet, 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 printed page so it is better to check that the data is arranged properly so that none of it spills over when printing. The data can be logically broken into pages but if the data exceeds the page only by a slight margin then it is better to fit the data onto a single 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