Fit all columns on one page Excel
You’ve sized the columns correctly, you’ve put nice colored headings, and everything looks great on the screen. Show And now when you hit that Print button, it doesn’t work as you expected! Your last 2 columns are appearing on the second page and you’re not sure where most of your rows have gone! Unlike Microsoft Word, printing Excel worksheets is surprisingly not as intuitive as you would think. This is because your spreadsheets are not always sized the same. So it’s no surprise if you find your columns splitting in the most awkward places or if you find few rows on one page and few on the others. You might also find it difficult to control the size of the text in your printout. Fortunately, there are ways around this. In this tutorial, you’ll see two ways to fit your Excel data (rows and columns) into one page. I will also point out certain issues you are likely to face while printing and how to solve them. Table of Contents
Method 1: Fitting data to Page in Excel using Page SetupBelow are the steps to scale the data in the worksheet to fit on one page:
When you use this option to scale the page and fit data on one page, it will make the data look small (as Excel tries to squeeze more data in the same space. This works fine if you only have a few extra rows or columns, but if you have a lot, fitting all of it in one page may not be a good idea. Method 2: Fitting data to Page in Excel using Print Preview ScreenYou can also scale the data to fit on one page while you’re printing the data. This does exactly the same thing that I did in the previous method (just the option to do it is in a different place). Below are the steps to fit data on one page while printing:
Autofit only the Width or Height into a Single PageIf you have too much data in too many columns, your printout might turn out too tiny and look illegible. There are ways around this.
Another option is to use page breaks to divide your worksheet. Using Page Breaks to divide your Worksheet’s Print AreasPage Breaks are dividers that specify the areas where your sheet will break into separate pages when printed. Excel automatically adds page breaks, unless you specify them yourself. It fixes these page breaks depending on your page size, margins, and scale options to ensure that an optimal number of columns and rows appear on each page.
If you have selected the ‘Fit Sheet on One Page’ from the Print Settings area, you will not be able to set the page breaks (as Excel already knows it needs to fit all the data in one sheet). If you want to set the page breaks, then you need to go the Print settings (click on File >> Print >> Settings) and select ‘No Scaling’ from the last dropdown Points to Remember when Printing your Worksheet
In this tutorial, I showed you two ways to fit your worksheet into one page. We have also provided some tips to not just fit your sheet to a page, but to do so in such a way that your printout is legible and looks elegant. I hope you found this tutorial helpful. |