[Solved] How to hide gridlines

Discuss the spreadsheet application

[Solved] How to hide gridlines

Postby macxx1 » Tue Jan 09, 2018 6:13 pm

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

Postby macxx1 » Tue Jan 09, 2018 6:25 pm

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
macxx1
 
Posts: 12
Joined: Thu Dec 28, 2017 8:45 pm

Re: How to hide gridlines

Postby FJCC » Tue Jan 09, 2018 6:48 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 8121
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: How to hide gridlines

Postby Sliderule » Tue Jan 09, 2018 9:21 pm

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:

Calc Help: grids;hiding lines in sheets 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
Sliderule
Volunteer
 
Posts: 1247
Joined: Thu Nov 29, 2007 9:46 am

Re: How to hide gridlines

Postby Lupp » Tue Jan 09, 2018 10:48 pm

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 7.1 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 3064
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot], qba82 and 19 guests