excel

Copper Contributor

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

Hi Phil,

 

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

Page Layout - Sheet Options.png

 

Hope that helps

Regards

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.

I'm moving this question to the Excel community for better visibility.
I just posted about this issue also. It's frustrating having to change the settings every time.

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

Version 1806 (Build 10228.20104 Click-to-Run)

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?

 

 

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

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.