+ Reply to Thread
Results 1 to 5 of 5

Page Layout View does not show Row and Column Headings

  1. #1
    Registered User
    Join Date
    07-04-2019
    Location
    London, UK
    MS-Off Ver
    365 Pro Plus
    Posts
    8

    Page Layout View does not show Row and Column Headings

    I'm using Excel 2016 and have enabled the "Page Layout > Sheet Options > [Print] Row and column headings" option, so that my *printed documents* have the A,B,C,etc. column headings across the top of the sheet and 1,2,3,etc. row numbers down the side of the sheet.
    Given that my documents are deliverable to clients, I am trying to use Page Layout View to ensure everything is formatted professionally etc. before printing; however, Page Layout View does not seem to be able to show the *printed* row and column headings. To be clear, the "View > Show > Headings" option is on, so I can see these headings in the off-print area with the rulers etc., but Excel is not rendering the heading rows on the actual printable sheet itself.

    Is this a bug, or is there a way to show the row and column headings *as printed* in Page Layout View?

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Page Layout View does not show Row and Column Headings

    Have you checked the Headings>Print checkbox?

  3. #3
    Registered User
    Join Date
    07-04-2019
    Location
    London, UK
    MS-Off Ver
    365 Pro Plus
    Posts
    8

    Re: Page Layout View does not show Row and Column Headings

    Thanks dangelor, but which option are you referring to?
    I have already made sure that the headings do actually print when I send it to the printer (and, in fact, when I go to Print Preview), it's just that they do not show in Page Layout View - which I thought was supposed to be a bit like working in Print Preview.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Page Layout View does not show Row and Column Headings

    I see what you mean... in page layout view, the margins shift if you toggle the heading checkboxes but it does not show the headings on the view itself. Odd that...

  5. #5
    Registered User
    Join Date
    07-04-2019
    Location
    London, UK
    MS-Off Ver
    365 Pro Plus
    Posts
    8

    Re: Page Layout View does not show Row and Column Headings

    Exactly! I can't believe that is a deliberate limitation of Page Layout View, hence my question...

+ 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. VBA help -- after macro is run, page layout view changes
    By marshak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2019, 09:36 PM
  2. [SOLVED] Hide page breaks in page layout view
    By Solvax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2018, 01:25 PM
  3. Page Layout View
    By jpp7717 in forum Excel General
    Replies: 2
    Last Post: 03-08-2017, 04:57 PM
  4. Command Buttons not working in Page Layout view
    By Epscan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2017, 03:00 PM
  5. Replies: 2
    Last Post: 01-16-2016, 03:26 PM
  6. Removing extra sheets in Page Layout View
    By doozman in forum Excel General
    Replies: 1
    Last Post: 11-29-2012, 12:09 PM
  7. 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

Tags for this Thread

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