Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2020, 06:15 AM
Ulodesk Ulodesk is offline Problems printing Excel Windows 10 Problems printing Excel Office 2016
Word 2013 Expert Cert
Problems printing Excel
 
Join Date: Sep 2009
Location: Virginia
Posts: 800
Ulodesk is on a distinguished road
Default Problems printing Excel

I was interrupted while posting. I meant to preface it by saying I had posted this on an Excel Forum a week ago but received no responses from any of the 50+ readers.

I work in a corporate environment using Office 365 in Windows 10. I’m the production manager for proposals, some of which require hardcopy submission. Although I am familiar with wrangling Excel worksheets to fit on a printed page, challenges have recently arisen on two occasions that I don’t understand.

In the first case, the Excel provided by the client for filling-in included locked cells; in the second, cells were not locked, but the second row had dropdown arrows indicating some functionality (sorting?). In the first case, a hard-copy submission was required; in the second, I was asked to prepare so, in case the client decided to print after submission.

In each case, a PDF copy was required of one or more workbooks with between 6 and 15 worksheets. Worksheets were formatted to fit 8.5x11 paper, either portrait or landscape. Margins, page-break view, and page layout view were checked, and scaling percentage was checked to avoid illegibly small font size.


In the locked-cell case, for which we were in the office, we ran into a problem trying to print from Excel itself to an medium-size (three-drawer) office printer. Despite all efforts, the worksheets, despite displaying properly in print preview, were either spilling off the page or reducing themselves to perhaps 1/16 of the page area, down in the lower left. Printing from a PDF copy finally resolved the problem. I could only guess that it might be a print driver issue, but we did not experience this with any other documents or file types.

In the second case, I was responsible and working from home, without access to a printer. After checking and adjusting the formatting of all the sheets for 8.5x11 landscape layout, I first found that some of them, in page layout view, showed all the content, but no right margin was displayed, while others displayed just fine. On the former, the ruler at the top of the page in page layout view showed the content ending within bounds, e.g., 6.5 inches on the right. adjusting the content for a narrower right column did not make any margin appear. Then, when I PDF’d the workbook -- which I tried using several approaches, both the PDF feature in Excel and setting Acrobat Pro as my default printer, which is on my machine -- I found the page size changing for some worksheets, creating, visually, at least three distinct page sizes.

Excel almost always crates problems to print, in my experience, even on the large production printer I sometimes use, and PDFing the workbook is usually the best (or only) means of printing a workbook with varying page sizes in one pass. Therefore, I will appreciate any insights into the process of getting from Excel to PDF, or Excel to print, more generally.

Thanks.
Reply With Quote
  #2  
Old 11-16-2020, 06:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Problems printing Excel Windows 7 64bit Problems printing Excel Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,460
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Don't know if it's what you need but have a look at the " CreatePDF" module on this page
Reply With Quote
  #3  
Old 11-16-2020, 07:44 AM
Ulodesk Ulodesk is offline Problems printing Excel Windows 10 Problems printing Excel Office 2016
Word 2013 Expert Cert
Problems printing Excel
 
Join Date: Sep 2009
Location: Virginia
Posts: 800
Ulodesk is on a distinguished road
Default

Thanks, Pecoflyer, but macros will not be of service in my environment.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems printing Excel Problems with crossreference printing Igorvd Word 2 06-13-2016 05:44 AM
Problems printing Excel Printing Problems with Office mdavis Office 1 02-10-2012 05:49 PM
printing to onenote problems HELP!!! adwmd03 OneNote 0 01-25-2012 03:07 PM
Problems printing Excel Problems with printing friwise Word 2 01-31-2010 02:52 AM
Printing problems JudyIver Word 0 01-19-2010 07:46 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft