+ Reply to Thread
Results 1 to 3 of 3

Printed Copy Changes Column Width?

  1. #1
    Forum Contributor
    Join Date
    02-25-2008
    Location
    Windsor, ON Canada
    MS-Off Ver
    Excel 2007, 2003
    Posts
    119

    Printed Copy Changes Column Width?

    I'm very frustrated with a spreadsheet I'm working in.

    I'm trying to print using the "fit to (1) page wide by "blank" pages tall". What happens in my printout (I'm only printing a "selection") is that my columns are getting narrower so that the titles aren't printing properly (they're getting cut off), and some numbers are reverting to "#####", plus one longer number value is chaning to 1E+08. How do I prevent this from happening on my printout? My screen view is fine. This is only happening on my printed copy.

    Thank you!
    Last edited by 2709236; 04-01-2010 at 01:38 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Printed Copy Changes Column Width?

    The scaling is introduced during printing, not on-screen display. Try increasing the columns widths a little. The fonts may (will) get smaller, but number formatting may be better preserved.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    02-25-2008
    Location
    Windsor, ON Canada
    MS-Off Ver
    Excel 2007, 2003
    Posts
    119

    Re: Printed Copy Changes Column Width?

    Thanks for the tip. I've adjusted the widths, and this seems to have helped. I don't typically run into this problem however!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1