+ Reply to Thread
Results 1 to 5 of 5

Ghost pages in Print Layout view, Excel 2013

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    10

    Ghost pages in Print Layout view, Excel 2013

    Does anyone know how to banish the 'ghost pages' that appear to the right of (and sometimes below) the actual page? These are empty parts of the worksheet that are outside the Print area. http://i62.tinypic.com/34fljwl.jpg
    Last edited by skylark42; 09-11-2014 at 11:46 AM.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Ghost pages in Print Layout view, Excel 2013

    I don't understand what exactly you're asking after?

    You've set the View to "Page Layout", right? So it's showing the worksheet split up to show where the cells would sit on printed pages. So in that case... what's the problem?

    Or is that there's more than one sheet that's being pulled in as an "Active Sheet" when you go to the print command? In that case there might be cells with hidden content (eg, with the "" empty text string) that are "active" but not actually displaying anything.

  3. #3
    Registered User
    Join Date
    10-02-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Ghost pages in Print Layout view, Excel 2013

    The problem, Ben, is that the defined Print Area consists of the one page you see there at top left of the image. I do not want to print or see 'virtual' parts of the spreadsheet. Is there a way to change the params of Print (sorry) Page Layout so that it shows the Print Area only?

    There are no other entries in the worksheet. I've deleted a large number of columns and rows outside the print area to be certain that there are no non-printing characters in there.
    Last edited by skylark42; 09-11-2014 at 12:15 PM. Reason: Add additional info

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Ghost pages in Print Layout view, Excel 2013

    Quote Originally Posted by skylark42 View Post
    I do not want to print or see 'virtual' parts of the spreadsheet.
    Since it's software, all of it is virtual...?


    Anyway, try "Page Break Preview"; it should be next to "Normal" or "Page Layout" view in the menu. That will create a draggable blue outline; everything inside that box will display normally, everything outside will be grayed. I think that might accomplish what you want.

    If that doesn't deliver the appearance you want, you might try hiding the rest of everything.

  5. #5
    Registered User
    Join Date
    10-02-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Ghost pages in Print Layout view, Excel 2013

    Thanks, Ben.

    Here's how it looks in Page Break Preview: http://i57.tinypic.com/1089zm0.jpg
    For comparison, here it is again in Page Layout View: http://i59.tinypic.com/2yjojeh.jpg.

    I don't want to display my spreadsheet in Page Break Preview, I want and need to see it in Page Layout View, so that complex headers can be entered and edited. That is our main use of PLV here. It's not just me; I have to provide methods and solutions for the whole office.

    If possible I don't want to have to specifically 'hide' all the 'virtual' (i.e. empty) rows and columns each time I open a spreadsheet (as suggested by pgc01). I just want Page Layout View to show only the Print Area I have defined.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use Excel VBA to open Word Doc in PRINT LAYOUT View
    By Marksman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 02:50 AM
  2. How to only the print area in the page layout view?
    By monarchos in forum Excel General
    Replies: 2
    Last Post: 05-24-2012, 05:30 PM
  3. Replies: 1
    Last Post: 03-22-2006, 02:00 PM
  4. [SOLVED] Excel 2003 Print Layout View
    By tjwncos in forum Excel General
    Replies: 1
    Last Post: 01-25-2006, 05:00 PM
  5. Replies: 2
    Last Post: 05-28-2005, 06:05 PM

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