1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel, set print area???

Discussion in 'General Chat' started by Ads, Feb 25, 2010.

  1. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579
    [Feb 25, 2010]
    Not sure what section this should go in; but mods, please don't move this to some dark corner of the site that no one visits plllleeaassseeeee :icon_thumright:

    I've got a bit of a problem with Microsoft Excel. When you highlight the area you want to print and then select 'set print area' Excel is supposed to put a dotted line around the area so you know what will print and if it will fit on one page.

    For some reason the dotted line doesn't appear anymore for me. It still sets the print area but I just don't get the dotted line.
    Seems to be file specific as well, as it still appears in other spreadsheets I use.

    Had a look and can't find anyway to switch the dotted line back on.

    Anybody know a fix??
    #1
  2. Ads

    Ads

    [Sep 17, 2014]

  3. Caesium
    Offline

    Caesium My BM is fixed!

    Joined:
    May 26, 2004
    Messages:
    4,879
    Likes Received:
    4
    [Feb 25, 2010]
    Click view then page break preview
    #2
  4. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579
    [Feb 25, 2010]
    Thanks, but that's not really a fix. You can't work properly on spreadsheets in 'page break preview' view.
    #3
  5. L1 HCS
    Offline

    L1 HCS Active Member

    Joined:
    Oct 10, 2006
    Messages:
    4,601
    Likes Received:
    6
    [Feb 25, 2010]
    Go to print preview and then close.

    It should go back to the normal screen and the dots are there.
    #4
  6. Nilz
    Online

    Nilz Defo worth the wait :)

    Joined:
    Apr 9, 2006
    Messages:
    10,249
    Likes Received:
    402
    [Feb 25, 2010]
    Go to print preview then close it, the lines should appear all the time then
    #5
  7. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579
    [Feb 25, 2010]
    Didn't work. :crying:
    #6
  8. Nilz
    Online

    Nilz Defo worth the wait :)

    Joined:
    Apr 9, 2006
    Messages:
    10,249
    Likes Received:
    402
    [Feb 25, 2010]
    Hmmm, strange, not sure then, just had a look through and cant see why it wouldnt show, what version of Excel are you using??
    #7
  9. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579
    [Feb 25, 2010]
    Same here, can't see anything that relates to settings of 'set print area'.
    I'm using Excel 2002.
    #8
  10. L1 HCS
    Offline

    L1 HCS Active Member

    Joined:
    Oct 10, 2006
    Messages:
    4,601
    Likes Received:
    6
    [Feb 25, 2010]
    Re-boot your computer.
    #9
  11. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579
    [Feb 25, 2010]
    Ah yes, the good old reboot.
    Tried. And failed.

    Thinking about it, I could probably copy and paste the whole thing into a fresh spreadsheet where the page breaks work, but now I come to think about it I remember this problem has happened before so would like to get to the bottom of it really.
    #10
  12. L1 HCS
    Offline

    L1 HCS Active Member

    Joined:
    Oct 10, 2006
    Messages:
    4,601
    Likes Received:
    6
    [Feb 25, 2010]
    How about time for an upgrade?
    #11
  13. Ads
    Offline

    Ads License to drive

    Joined:
    Jul 15, 2009
    Messages:
    8,222
    Likes Received:
    579

Share This Page