In case there are many, using this option may make the printed data too small to read. The ‘Fit Sheet on One Page’ option is suited when you only have a few rows/columns that are spilling over. You will also be able to see how the data would look in the sheet preview which is on the right.

The above steps would scale the sheet to fit the page (based on what options you have selected). In the Print window, click on the Scaling option (it’s the last option on the left).Click on Print (or use the keyboard shortcut – Control + P).Suppose you have a sheet where the columns are spilling over to the next sheet when printed.īelow are the steps to scale down the sheet while printing: When you do this, it simply scales down everything to fit all the columns or rows in one page. Change the Scaling (Fit All Rows/Columns in One Page)Įxcel has an in-built option that allows you to rescale the worksheet in a way that fits more rows/columns on one page. To return to the normal view (and get out of the Page Layout view), click on the View tab and then click on ‘Normal’. You can correct this by enabling the Wrap text option in Excel. This often happens when you change the column width. In some cases, you may find that the data in a cell is being cut off and is not being displayed completely. Once you have all the data on one page, you can go ahead and print it. To do this, place the cursor at the edge of the cursor on the column header that you want to reduce in size. Reduce the column width to fit the data on one page.This will change the way data is displayed (and you will see scales at the top and on the left of the worksheet) In the Workbook Views group, click on the ‘Page Layout’ option.To make this easy, you can use the Page Layout View in Excel – which shows you in real-time how much data would be printed on each page of your report.īelow are the steps to get into the Page Layout mode and then reduce the column width: In many cases, you don’t need your columns to be too wide.Īnd since this is a direct determinant of how much data is printed on one page, you can save a lot of paper by simply reducing the column width.īut then, how do you know whether you have done enough or not? How do you know how much column width you should reduce to make everything fit on one page? Now, let’s see some methods you can use to fit all the data in a sheet on one page and then print your report on one page (or fewer number of pages) Adjust the Column Width (or Row height) Ways to Fit and Print Excel Sheet in One Page You can use the arrow keys to go to the next/previous page when in the Print preview mode. This would open the Print preview page where you would be able to see how many pages would be printed and what would be printed on each page. Or you can use the keyboard shortcut Control + P (Command + P if using a Mac) This allows you to understand the things you can change to make sure you’re using the minimal number of paper while still keeping your printed report beautiful and legible.īelow are the steps to use Print Preview to see how the final print job would look like: You can simply check how the printed work would look and how many sheets will be printed. Print Selected Data only (or Set the Print Area)Ĭheck How Many Pages Would be Printed (Preview)īefore you set out to optimize the settings to print the Excel work in one sheet, it’s best to check the current state using the Print Preview.ĭon’t worry! You don’t have to print anything for this.Change the Scaling (Fit All Rows/Columns in One Page).Adjust the Column Width (or Row height).Ways to Fit and Print Excel Sheet in One Page.

Check How Many Pages Would be Printed (Preview).

Print selection mac preview