free online microsoft training

Free tips and tricks for using Microsoft Office and Windows

How to print data on one page in Excel

Print Friendly, PDF & Email

I’ve run a lot of Excel training. One of the most common questions is “How do I print onto one page in Excel?”. The idea sounds simple, doesn’t it?

I have seen some truly imaginative ways that users will sit and play with an Excel spreadsheet in an attempt to get it to print perfectly. When I tell you that it will only take 30 seconds to make your Excel worksheet print perfectly onto 1 page wide, I mean it – 30 seconds!

Let’s look at an example. Whilst not a massive amount of data, I would expect that this would easily fit within the width of 1 page. I have 13 headings running across my columns with a total of 41 rows. The worksheet is set to Landscape page orientation.

If I have a quick look at the Print Preview, I can see the worksheet is going to print across 4 pages. Nope, not happy with that.

Check Print Preview

How do I print an Excel spreadsheet on one page?

So our worksheet is going to print across 4 pages which isn’t good enough. I want this to print perfectly onto 1 page wide so let’s see how we can fix this.

  1. Open Microsoft Excel
  2. Locate a workbook which you are having difficulties with when printing
  3. Press Ctrl + P on the keyboard to see Print Preview and note how many pages your worksheet is currently going to print across
  4. Press Esc on the keyboard to return to the worksheet so we can make some adjustments
  5. Select the Page Layout tab from the Ribbon
  6. Locate the Scale to Fit group of buttons
Click the Page Layout tab and locate the Scale to Fit group of buttons
  1. The only part I want to edit is the number of pages that my data will spread across width-wise
  2. Click the Width drop-down menu and choose 1 page
  3. Automatically the Scale setting will be greyed out and Excel will take control over the scaling of the worksheet
  4. My worksheet has been scaled down to 73% of the original size
The scale setting will be adjusted
  1. Generally speaking, I find that if the Scale setting is 60% or above, then my printed version is going to look ok. If you find that the Scale has dropped down lower than 60% you will need to make some further adjustments so that your printed copy will still be at a legible size
  2. Press Ctrl + P to Print Preview your scaled worksheet
Check print preview again
  1. My worksheet is looking perfect and ready to print onto one page

How to increase page scale

If your worksheet has been scaled lower than approx 60% then you may need to make some further adjustments so that your data will be legible once printed. The easiest way to do this is by claiming back some of the blank space displayed around the outside borders of your worksheet. When you look at my Print Preview above, you can see I have some space around the outside edge of the worksheet where my data could take up some more space, let’s look at how to quickly do this.

  1. Return to your worksheet view if you are still in Print Preview
  2. Go to the Page Layout tab on the ribbon again
  3. This time click the Margins button from the Page Setup group
Click the Margins button
  1. My margins are currently set to Normal, instead, I will select Narrow
  2. My Scale setting changed from 73% to 79%
  3. Press Ctrl + P on the keyboard to view Print Preview and see how your worksheet looks now
Check the print preview again
  1. My data is now taking up more space on the space
  2. I’m now ready to go ahead and print my worksheet

I hope this helps solve a common printing issue within Microsoft Excel. Be sure to check out my other Excel articles here. Comment below with any questions.

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on pinterest
Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × 4 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.