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
LVL 4
Stephen KairysTechnical Writer - ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.