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.
Step 3: Click the Print option in the column at the left side of the window.
Step 4: Click the No Scaling button.
Step 5: Select the Fit All Columns on One Page option. If you are happy with how the preview looks, click the Print button.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.