Forum Discussion

Phil McInnes's avatar
Phil McInnes
Copper Contributor
Jul 09, 2018

excel

When I print an excel spreadsheet, either direct to a printer or by creating a pdf, it is printing the vertical and horizontal rulers

Didnt use to but suddenly started - can anyone tell me how to turn this setting off.

Thanks

8 Replies

  • I'm moving this question to the Excel community for better visibility.
    • Debbie Mazur's avatar
      Debbie Mazur
      Copper Contributor
      I just posted about this issue also. It's frustrating having to change the settings every time.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    In addition, there is known bug in current version - if you select Print Gridlines, save and open the file again, Print Gridlines will be unchecked but Print Headings becomes checked.

    • Louise Forman's avatar
      Louise Forman
      Copper Contributor

      I have the problem that, all of a sudden, Excel has started printing row & column headings by default.  Is there no way of changing this default?

       

       

      • Louise Forman's avatar
        Louise Forman
        Copper Contributor

        I should add that I am using Office 365 for Mac and Excel 16.14.1 (180613)

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor

      It seems that the issue has been fixed in the latest update of Excel which is:

      Version 1806 (Build 10228.20104 Click-to-Run)

      • Debbie Mazur's avatar
        Debbie Mazur
        Copper Contributor

        Thank you! It did not alert me that an update was available, but I went into my account setting and was able to update. Appears to have fixed the issue.

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi Phil,

     

    Please go to the Page Layout Tab, and check if these two checkboxes are cleared:

     

    Hope that helps

    Regards