SOLVED

Scaling sheet in workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2041197%22%20slang%3D%22en-US%22%3EScaling%20sheet%20in%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041197%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20three%20tabs%20in%20a%20particular%20wook%20book%20the%20first%20tab%20seems%20to%20work%20just%20fine%20as%20long%20as%20I%20set%20the%20margin%20on%20the%20right%20and%20left%20to%20%220%22.%26nbsp%3B%20the%20second%20tab%20contains%20a%20similar%20sheet%20but%20it%20will%20not%20scale%20to%20print%20or%20to%20convert%20to%20a%20pdf.%26nbsp%3B%20I%20have%20done%20about%20every%20configuration%20imaginable%20and%20nothing%20works.%26nbsp%3B%20I%20have%3C%2FP%3E%3CP%3E1.%20Updated%20my%2064%20bit%20Windows%20Professional%20OS%3C%2FP%3E%3CP%3E2.%20Uninstalled%20Office%202010%3C%2FP%3E%3CP%3E3.%20Installed%20Office%20home%20%26amp%3B%20business%202013%3C%2FP%3E%3CP%3E4.%20Changed%20settings%20regarding%20size%20of%20document%20and%20scaling%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20insight%20to%20my%20problem%20is%20urgently%20needed%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2041197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2041395%22%20slang%3D%22en-US%22%3ERe%3A%20Scaling%20sheet%20in%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041395%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921542%22%20target%3D%22_blank%22%3E%40zcarp%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20%3CSTRONG%3EFile%3C%2FSTRONG%3E%20--%26gt%3B%20%3CSTRONG%3EOptions%3C%2FSTRONG%3E%20--%26gt%3B%20on%20the%20left%20side%20click%20on%20%3CSTRONG%3EAdvance%3C%2FSTRONG%3E%26nbsp%3B%20--%26gt%3B%20under%20%3CSTRONG%3EGeneral%3C%2FSTRONG%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eremove%20the%20selection%20from%20%22%3CSTRONG%3EScale%20content%20for%20A4%20or%208.5%20x%2011%22%20paper%20sizes%3C%2FSTRONG%3E%22%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22scale.png%22%20style%3D%22width%3A%20798px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244797i36C834EA22DBAEF7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22scale.png%22%20alt%3D%22scale.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have three tabs in a particular wook book the first tab seems to work just fine as long as I set the margin on the right and left to "0".  the second tab contains a similar sheet but it will not scale to print or to convert to a pdf.  I have done about every configuration imaginable and nothing works.  I have

1. Updated my 64 bit Windows Professional OS

2. Uninstalled Office 2010

3. Installed Office home & business 2013

4. Changed settings regarding size of document and scaling

 

Any help or insight to my problem is urgently needed

2 Replies

Hi @zcarp 

 

From File --> Options --> on the left side click on Advance  --> under General 

remove the selection from "Scale content for A4 or 8.5 x 11" paper sizes"

 

scale.png

 

* If my post helped you, please click on like.

 

best response confirmed by zcarp (New Contributor)
Solution

@Jihad Al-Jarady  Thank you for the response.  it dawned on me that the problem might be coming from a source other than the excel program. I remember word being jumpy when I changed from windows 7 to 10.  As odd as it sounded at the time I was directed to uninstall my HP Laser jet Pro 452dn printer to solve the problem.  Low and behold it worked.  After much frustration yesterday with the scaling problem I thought it might me more of a printer problem than excel, sure enough, once I uninstalled HP software the scaling feature in excel worked.  With a fresh install of HP software I am not having any problems.  Thanks for taking the time to help, you are very much appreciated.