How to Print All Columns on One Page in Excel 2010

Excel 2010 is a perfect program for a lot of different uses, but one area that can be frustrating is when you need to print a spreadsheet. If your spreadsheet doesn’t perfectly fit on the paper in your printer, then Excel will automatically push extra columns to their own page, which can result in a lot of confusion and wasted paper. Manually resizing columns can also be a futile effort, as adjusting one column can end up creating another problem. Fortunately Excel 2010 has a print setting that allows you to automatically fit all of your columns on one page, ensuring that the data is in a more print-friendly layout.

 

How to Print Multiple Columns on One Page in Excel 2010

One thing to keep in mind when you are doing this, however, is that the size of your cells and text will be shrunk to accommodate the reduction in print real estate. So Excel will fit 100 columns on one page if you tell it to, but the resulting printout will likely be illegible. This is a good situation to take advantage of the Print Preview at the right side of the Print screen, as it will give you an idea of how small the text is going to become.

 

Step 1: Open your spreadsheet in Excel 2010.

 

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

 

 

Step 3: Click the Print option in the column at the left side of the window.

select the print option

 

 

Step 4: Click the No Scaling button.

how to fit all columns on one page in excel 2010

 

 

Step 5: Select the Fit All Columns on One Page option. If you are happy with how the preview looks, click the Print button.

select the fit all columns on one page option

 

 

If the text is just slightly too small, consider switching to a landscape orientation instead.

 

Do you have Netflix, Hulu Plus or Amazon Prime, and you want an easy way to watch them all on your TV? The Roku 3 is an affordable way to do this, and the device is very easy to set up and use. Click here to learn more about the Roku 3.

You can also configure your Excel 2010 spreadsheet so that you can fit the entire spreadsheet on one page.

Multi-page spreadsheets can greatly benefit when you print the top row on every page.