Forum Discussion

acraven's avatar
acraven
Copper Contributor
Feb 04, 2021

Grid lines in an excel spreadsheet

I have several worksheets in an excel workbook.  

 

I have checked the box under gridlines to view them, but not the box to print them.

 

However, it still prints the gridlines on my reports.

 

I have to check the box to view, then go back through every worksheet in that workbook and uncheck view when I am ready to print.

 

I don't know how to fix this.

 

Can anyone help.

 

Ann Craven

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    acraven 

    I guess you mean these settings

    With them are gridlines printed for any sheet or for some specific one and on which version of Excel you are?

     

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    acraven 

    With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

    Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

    At the same time, it is much easier for someone who wants to help to understand the subject.

    A win-win situation for everyone.

    Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

     

    Thank you for your understanding and patience

     

    Nikolino

    I know I don't know anything (Socrates)

Resources