Converting excel to PDF, single page converts to multiple HELP!


Joined
Apr 13, 2018
Messages
1
Reaction score
0
Hello All,

I attempted to contact Microsoft for help, but apparently a "level 2" tech is only available by appointment and I need help a little sooner as I run a business from home.

My problem:

I create Excel docs for use as Estimates and Invoices. These are all under one file, typically saved as "address - customer name". Within each file I have multiple tabs labeled, "Estimate", "Invoice" Etc. This is to avoid all the re-entering of basic customer/ job info.

In the past, I would save The "estimate" tab as a PDF and select "sheet" . This would give me an email-able version to send to customers. This worked great on my laptop, with an older version of office, but never worked on our "newer" desktop. When saving each tab as a sheet, and converting to a PDF, the single excel page would split into 4 separate PDF pages. And yes, I've moved page breaks "blue dashed lines" to define what I want to be on any single page, but to no avail.

I contacted Microsoft and of course I had to upgrade both computers software before they would help. I did this, but reluctantly, as I was concerned that the laptop, with the ability to save a PDF the way I intended, would stop working... And yup, it did. Now I cant save PDF documents into a single or double page as needed. Excel or Adobe decides on its own how to split pages up and I cant seem to find a way to perform a manual override.

PLEASE HELP!!!
 
Ad

Advertisements

Becky

Administrator
Joined
Aug 3, 2011
Messages
70
Reaction score
6
I'm curious why you save the worksheet into a separate workbook before printing to pdf, is there a reason for this?

To go over the basics, to print something from Excel then first highlight the cells you want to print, then click on Page Layout > Print Area > Set Print Area. Then go to File > Print and you can choose the settings you want - go to Page Set-Up if the options you want are not listed. Once it's set up how you want, choose whatever software you use to print to pdf. Does this help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top