In this article, I will tell you how to turn off this bothersome lines in Excel.ĭisable print gridlines with Excel Optionsĭisable print gridlines with Kutools for Excel When you return to the Normal view from the Page Break Preview or Page Layout views in Excel, there will display some print gridliines as below screenshot shown, which is somewhat anoyying in some times.
The idea about this extension comes after to discuss this issue in the forum community ( ).īy the way, credits for the volunteer “Charlie Young” by the idea about to use a listener checking for the active sheet.How to turn off the print gridlines in Excel? Any way, if you have a problem to install in your OpenOffice by the extension manager, then after download the extension, unzip the installation file named “GridLines_v1.1.oxt or 1.2” and follow the instructions inside the “Read_me.txt” file to get installation alternatives. The extension installation package was tested in OpenOffice 3.2 and 3.3 and works nice. Don't forget to restart the OpenOffice after the installation. It's necessary to run the listener that intercepts the active sheet.Īfter the installation, it will create a new library called “GrdiLinesLib” inside the “My Macros” container and it will add a new menu in “Tools\Add-ons” and a new toolbar that can be viewed by “View\Toolbars”. You will need to reset the grid lines view in two cases:ġ) When you re-open the Calc file, after close it andīut, anyway, in both cases you reset it just by clicking the same button. By the way, you can change how many sheets you want. Even if you go to another sheet, every time you go back to the sheet you changed, it will be in the way you left it. All you need to do is to click the button and the active sheet grid lines will be hidden or shown. You do NOT need to write anything inside the macro. This extension allows you to hide or show the grid lines on a sheet of a Calc file with multiple sheets, without affecting the other sheets, just by clicking a button, just the way Excel and LibreOffice do.
0 kommentar(er)
