[SOLVED] Bizarre Excel 2007 Problem - worksheets falling off page in print preview

Discussion in 'Software' started by pervnerve, Dec 3, 2009.

  1. pervnerve

    pervnerve Private First Class

    I began typing this all out, but then fixed it while I was typing, so I figured I'd post this anyway in case anyone searching can benefit. ;)

    I did a general search and couldn't find anyone who had this particular problem, so here goes: Despite having the margins, scale, centering (horizontally), and correct printer drivers all set up, for some reason as I go from the first worksheet to the last in my workbook, the sheets begin migrating off the page through the left margin.

    There are no print areas, they should be centering horizontally, and it didn't do this with the sheets the last time I saved (a few days ago).

    [Solved] I found that the problem was the text boxes on each sheet. For some reason, Excel doesn't like to do horizontal centering with text boxes. I instead merged cells and put a border around them for wherever there was a text box. This fixed the problem entirely, but does nothing for the obvious bug in the program. rolleyes
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds