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).

How to reduce page size of excel