Changing print orientation on all worksheets when printing a whole workbook in one go
Hi - please can you help! I am printing a workbook with multiple sheets. I want to change the print size of all sheets by either portrait to landscape or set all sheets to fit all columns to one page. can this be done without having to change each sheet individually?
Excel Suddenly Crashing on Print Preview
Just now, Excel has started crashing when I utilize print preview mode. It was working fine yesterday. I click the print preview option and the sheet crashes. It happens on any spreadsheet, even a new page with a single character in the middle of the page. It crashes if I select any printer destination, whether a physical printer (Canon) or print to PDF. I updated ITunes and iCloud today, but can’t imagine that would impact Excel. My Microsoft update history indicates the last patch was 5/22/18. The event error log gives this information: Faulting application name: EXCEL.EXE, version: 16.0.9330.2087, time stamp: 0x5b060fe4 Faulting module name: EXCEL.EXE, version: 16.0.9330.2087, time stamp: 0x5b060fe4 Exception code: 0xc0000005 Fault offset: 0x000a0a55 Faulting process id: 0x38c8 Faulting application start time: 0x01d3fa8e9729ef91 Faulting application path: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE Faulting module path: C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE Report Id: d348a382-c7df-4370-975c-0039abd0fa64 Faulting package full name: Faulting package-relative application ID: I ran OffCat and it came back clean. It indicates that Excel 2016 is up to date. And I'm running Windows 10. (I tried to attach the crash log but the web site gave me an error message "The contents of the attachment doesn't match its file type." Nice.) What happened and how do I fix this?"Fit to" option of Page Setup does not (seem) work
Hi all, I have a long narrow table in my MS Excel 2016 MSO (16.0.9029.2167) 64bit, and I want to print it as two-column per page style. It is narrow and can fit to page in two or even more columns. I open Page Setup dialog box and on the Page tab check "Fit it" radio button and set 2 fo "pages wide" setting and leave blank for "by tall". But it does not affect how excel places my table on a page - it still goes one column on the left side of the page. No matter what I set for "Fit to __ pages wide" setting - excel still lays the table as one column on thу left part of the page, the right part id blank. Can you please advise on how I layout my narrow table in two or more columns per page ? Thank you, Roman.
Excel 2016 Printing; First copy prints whole workbook (as wanted), others print only first page
I'm not sure if this issue is with the printer/printer driver and it's settings or with Excel. I've completed the setup of an office printer on my network domain at work. When printing from Adobe (used as test), I was able to successfully print multiple copies, one sided, and stapled, all printed as they should. However, when printing a workbook with 6 tabs, the first copy prints correctly, but all additional copies are only printing the first tab/page. When testing both (adobe and Excel), I set to print pages 1-2 only and 1-3 only as well, and same results. Any assistance or idea of what may be the issue? Printers are always a nightmare, but since the printer is receiving jobs from other programs and they're printing correctly, it makes me think the trouble is with Excel...? But since this hasn't appeared to be widely reported, I'm sure it's the printer. ...it's always the printer.