[Solved] How to hide gridlines

Discuss the spreadsheet application
Post Reply
macxx1
Posts: 12
Joined: Thu Dec 28, 2017 8:45 pm

[Solved] How to hide gridlines

Post by macxx1 »

I want to hide the gridlines on a spreadsheet when it's opened
(Not just for printing it) but I don't see that option in View
Last edited by Hagar Delest on Wed Jan 10, 2018 9:21 am, edited 1 time in total.
Reason: tagged solved
Open Office 4.1.3
Windows 7 Home Premium
macxx1
Posts: 12
Joined: Thu Dec 28, 2017 8:45 pm

Re: How to hide gridlines

Post by macxx1 »

I finally found the right set of tools.

More steps and harder to find than the same things in Excel.
Open Office 4.1.3
Windows 7 Home Premium
FJCC
Moderator
Posts: 9277
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to hide gridlines

Post by FJCC »

If you are accustomed to one tool, then a different tool always seems unintuitive or needlessly complex. When I have to make a graph in Excel, I am driven insane by the process needed to make a decent looking one. When I make one in R, a far more difficult software to learn, it seems easy because I am used to that. I suspect that once you use Calc for a while, it will seem just as easy to use as Excel seems now. However, if you are going to spend the rest of your life thinking "this is easier in Excel", then use Excel.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
Sliderule
Volunteer
Posts: 1279
Joined: Thu Nov 29, 2007 9:46 am

Re: How to hide gridlines

Post by Sliderule »

Just for other Forum members reading this post, the solution is:

From the Menu: Tools -> Options... -> OpenOffice Calc -> View -> Grid Lines
The above Grid Lines should NOT have a check mark, if you do NOT want to see any grid lines on the screen. :bravo:
[color=#0040FF]Calc Help[/color]: [b]grids;hiding lines in sheets [/b] wrote:
Changing Table Views
To hide column and line headers in a table:
  • Under the menu item Tools - Options - OpenOffice Calc, go to the View tab page.
    Unmark Column/row headers. Confirm with OK.
To hide grid lines:
  • Under the menu item Tools - Options - OpenOffice Calc, go to the View tab page.
    Unmark Grid lines. Confirm with OK.
Sliderule
User avatar
Lupp
Volunteer
Posts: 3553
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: How to hide gridlines

Post by Lupp »

There is also an extension allowing to hide/show the gridlines per sheet.
(The setting is not saved to the file. The command needs to be added manually to a menu and/or toolbar.)
See https://extensions.openoffice.org/en/project/gridlines.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
Post Reply