Ask Your Question

How do I insert lines in a libre office spreadsheet?

asked 2019-07-13 19:26:17 +0200

jsknight100 gravatar image

I have a spreadsheet where some of the lines are missing. How do I restore them?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-13 19:43:58 +0200

Opaque gravatar image

updated 2019-07-13 19:50:49 +0200


Most probably these lines are just "hidden". To unhide select all cells by clicking the square left to column A and top to row 1 and righ click on the rows bar. On the dialog showing up select Show Rows

image description

Another reason for not showing some rows my be that there is a filter. If that's the case reset the filter using Data -> More Filters -> Reset Filters or uncheck Data -> Autofilter (depends on the filter type being active)

edit flag offensive delete link more


Thanks for your help but neither solution worked. The lines are visible on most of the spreadsheet but one column has no visible row lines!

jsknight100 gravatar imagejsknight100 ( 2019-07-13 20:28:51 +0200 )edit

Mark your column. Click to the right of the icon "Background Color" and choose "No Fill". Do this work?

ebot gravatar imageebot ( 2019-07-13 21:57:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-13 19:26:17 +0200

Seen: 37 times

Last updated: Jul 13