![microsoft edge print selection only microsoft edge print selection only](https://images.tips.net/S02/Figs/T2701F1.png)
Portrait (default in Excel) – More rows are printed than columns.If you have more columns and rows, it makes sense to change the orientation of the page while printing. This makes sure you can see how many rows/columns you need to hide to fit all the data on one page in Excel.Īnd here are steps to unhide the rows/columns in Excel. To hide a row/column, simply select them, right-click and then select Hide.Īgain, it’s best to first get into the Page Layout mode and then do this. You always have the option to make these visible again in case you need it later, but hiding these while printing will make sure you’re optimizing the space and using fewer pages to print. Hide or Delete Rows/ColumnsĪnother smart way to get everything on one page when printing is to hide any columns or rows that you don’t need. It only scales the data for print purposes. 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).
![microsoft edge print selection only microsoft edge print selection only](https://www.afterhourscreativestudio.com/media/catalog/product/cache/1e2fb864c373947d0c1621b6dfbbc3b2/r/o/rose-gold-edge-gilded-business-cards.jpg)
![microsoft edge print selection only microsoft edge print selection only](https://i0.wp.com/edgetalk.net/wp-content/uploads/2015/12/Microsoft-Edge-Wikipedia-the-free-encyclopedia-2015-12-18-23_28_20.png)
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).