Excel Printing Glitch - How to STOP Printing One Cell per Page

smryan

Perspective.
#1
In addition to my Quality hat, I have a small IT Support hat. I have one user that is having issues printing from excel. Anyone else can print the same files just fine. When she tries it puts one cell per page - but ONLY if she has selected the "Scale to fit one page" option. [MSO 2010 running on Win7]

I've already Googled it and tried several of the "solutions" found.
> No virus found
> Macros disabled
> Print drivers uninstalled, reinstalled, updated
> Latest service patch already installed
> Full Office "Repair" run

Here's hoping someone here has a solution that will actually work.
 
Elsmar Forum Sponsor

Ninja

Looking for Reality
Trusted Information Resource
#2
Re: Excel printing one cell per page problem

It is possible that if that particular computer had set the "Print Area" to one cell, or set the page size to one cell while having that file open that the computer itself has stored this information as default.

Reset or Clear the print area while on that computer on that file and see if that solves it.

I've noticed that sometimes print settings persist to other computers, and sometimes not. I've not noted a rhyme or reason or pattern.
Clearing them up from the "issue computer" usually solves it.

If that doesn't work...look in the File>Options>Advanced tab and make sure there isn't some weird background stuff going on....specifically from that computer.

HTH
 

smryan

Perspective.
#3
Re: Excel printing one cell per page problem

Thanks, but those were tried even before I resorted to Googling the problem. No luck.
 

Ninja

Looking for Reality
Trusted Information Resource
#4
Re: Excel printing one cell per page problem

If you print a word document from that same computer, does it print normally?
 

smryan

Perspective.
#5
Re: Excel - How to Print One Cell per Page

Ninja, yes. Other Word programs are printing fine. And the excel doc will go back to print normally if the "Fit to one page" option is deselected.
 

Ninja

Looking for Reality
Trusted Information Resource
#6
Re: Excel - How to Print One Cell per Page

Sorry, got me stumped too...
someone made it as simple as possible, but then made it simpler....

I never use print scaling just because of stuff like that.
 
T

The Specialist

#7
Hi smryan,

May I ask; have you tried printing to a different printer, either networked or directly wired?

I ask, because I wonder if it is not excel, but the printer at fault. At least trying a different printer might eliminate one of your variables?

Justin.
 

normzone

Trusted Information Resource
#8
I have seen where sending the document to a different user, then having them print to the same printer yields the desired result. Not a fix, but a workaround.
 

smryan

Perspective.
#9
Hi smryan,

May I ask; have you tried printing to a different printer, either networked or directly wired?

I ask, because I wonder if it is not excel, but the printer at fault. At least trying a different printer might eliminate one of your variables?

Justin.
Hooking up a local printer isn't an option - policy. To my experience if the printer were the issue then everyone would have the same problem. So no, I haven't installed a different printer - the next nearest one isn't very near.

My work-around for her is to manually scale her document contents to fit on one page and leave the [Fit to one page] print option alone.
 
Thread starter Similar threads Forum Replies Date
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 5
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 9
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
C Excel date format from Denmark to USA Excel .xls Spreadsheet Templates and Tools 6
G ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 24
N Where I can find an Excel sample/template for recording Delivery Time and Cost Excel .xls Spreadsheet Templates and Tools 2
D How do I go about creating document logs and registers with the MS Excel Excel .xls Spreadsheet Templates and Tools 2
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
QSM_Rick Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
S used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart Statistical Analysis Tools, Techniques and SPC 0
N Gantt Chart / Time Tracker in Excel - Combining Tasks on the Same Line Excel .xls Spreadsheet Templates and Tools 2
M Preventive Maintenance Spreadsheet in Excel Quality Assurance and Compliance Software Tools and Solutions 2
1 KPI Dashboard Template in Excel Format wanted Excel .xls Spreadsheet Templates and Tools 9
Ajit Basrur MS Excel to study Correlation between Humidity & Differential Pressure Excel .xls Spreadsheet Templates and Tools 7
D Gage Calibration Tracking in MS Excel Calibration and Metrology Software and Hardware 9
T Where can I get a PPAP workbook in Excel .xls with links? APQP and PPAP 1
L Excel Template for Cgk Study wanted (Capability Gauges Study) Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 12
V Looking for advice on Pooled Standard Deviation between Minitab and MS Excel Statistical Analysis Tools, Techniques and SPC 1
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
T Calculating LCL, UCL, Cp, and Cpk in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
R Is there any Excel .xls Spreadsheet available for DOE with 3 factors? Six Sigma 1
kedarg6500 Excel spreadsheet for Unilateral Tolerance Study wanted Excel .xls Spreadsheet Templates and Tools 2
kedarg6500 Excel Spreadsheet for AIAG Example wanted Excel .xls Spreadsheet Templates and Tools 3
M Excel Leadtime Analysis Graphic Tool with Macros Enabled Lean in Manufacturing and Service Industries 0
A Tracking Calibration and Qualification in an MS Excel Spreadsheet Calibration and Metrology Software and Hardware 6
S Document Control Guidelines in Engineering Projects - Excel sheets with VBA coding Document Control Systems, Procedures, Forms and Templates 3
R Excel Dashboard for Health Safety and Environmental KPI's for Multiple Sites Occupational Health & Safety Management Standards 4
B Looking for a Y-Shaped / 3-way Matrix Template (Excel or Visio) Quality Assurance and Compliance Software Tools and Solutions 7
S Form and Form/Record Numbering in an Excel Spreadsheet Excel .xls Spreadsheet Templates and Tools 2

Similar threads

Top Bottom