• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

Excel 2013 - Not printing enough columns across one page

Hello,

I have a worksheet that contains eight columns. When I print it, only six columns appear across one page, I would like to be able to print  column 7, and possibly column 8, on the same page.

Visually, it looks like I ALMOST have enough room for column 7. I'm guessing, though that Excel has calculated that there is not enough real estate to print it.

So...is there a way to "shrink" (or otherwise alter) the output format so that I can squeeze in column 7, and  - in the absolute best case - column 8?  (Btw, I am printing with gridlines, an with Row 1 (my headers) appearing on each page.

I realize it's the weekend, but any help on this issue would be greatly appreciated. :)

Thanks,
Steve
0
Stephen Kairys
Asked:
Stephen Kairys
  • 7
  • 5
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
First, make sure your print area encompasses all the columns you want to print. Print area is under the Page Layout tab.

Second, click on Print, and then under the options that come up, use Scaling to Fit sheet on One Page.

That should do it. This works for me.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
OK, I clicked on PRINT AREA --> SET PRINT AREA but don't see where to go from there.
How do I select my cols?

Thanks!
0
 
JohnBusiness Consultant (Owner)Commented:
In the Page Layout tab, there is a "box" in the menu bar that says Page Setup. Print Area is in this box. There is a little "x" beside Page Setup. Click on this and that brings up the Page Setup window. Click on the Sheet tab and set the columns as you wish.
 
I think this should help you find the Page Setup window.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
JohnBusiness Consultant (Owner)Commented:
Here is a screenshot of the place you want.

Excel-2013-Print-Setup.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
PRINT AREA came up with the value:

H:H

Do I change to something like: C1:C7? I tried that but on PRINT PREVIEW, only col. 3 displays.

Thanks.
0
 
JohnBusiness Consultant (Owner)Commented:
You may have some hidden columns which can affect printing.

Do the following:

Open your worksheet and highlight what you want as Print Area using your mouse.

Now click on Set Print Area. That will also set your print area properly.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
OK I tried that but all that prints is the col. headers. (PRINT AREA was A1:H1). So I changed to A:H. Printed the first 2 "pages'. But only the first 6 columns printed on page 1. The rest overlapped to page 2.

So I think maybe I stated my problem imprecisely.  It's not so much a question of WHAT  Excel is feeding to the printer. Rather, it's shrinking the width of the output so that I can squeeze it across the width of my page.

Thanks. Btw, I have to run out for a bit, but will be getting back to you in less than 2 hrs.

Steve
0
 
JohnBusiness Consultant (Owner)Commented:
Thanks.

Once you get your Print Area set (do this first and properly), then go to actually Print, and now set Scaling to Fit on one Page.  This should work.

Divide into two pieces:

1. Set print area properly and check with Print Preview.
2. Set Scaling to Print on one page.
0
 
Danny ChildIT ManagerCommented:
For the Print Area, select the entire range of data that you want first - ie Columns A:H, and *then* go to Page Layout tab.. Print Area dropdown.. Set Print Area.

You should also reduce your print margins if possible - set it to Narrow, on the Margins dropdown on the screen shown above.  This won't help the overflow onto other pages, but WILL help make it a bit easier to read.

In the previous comment , you may want to consider the scaling to be Fit all *Columns* to Page.  That helps if you don't want it to overspill sideways, but don't mind if it flows downwards onto other sheets.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
@John

Do you mean the ADJUST TO ___% field?  I set it to 80 and the 7th column appeared.

Page Setup - Scaling
@DanCh99
Thanks for checking in. I think, though, that John and I have resolved this issue.

Steve
0
 
JohnBusiness Consultant (Owner)Commented:
Yes the percent setting is the scaling percentage.
0
 
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thanks, John.

FWIW, it seems that Print Preview will show the same columns that actually print across a page.

Have a great day!

Steve
0
 
JohnBusiness Consultant (Owner)Commented:
Thanks Steve. You are very welcome and I was happy to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now