Ask Your Question

Lower the hard upper limit of rows in a single sheet [closed]

asked 2013-08-17 10:56:09 +0200

nasfarley88 gravatar image

updated 2013-08-17 10:56:53 +0200

I have a spreadsheet that will never hold more than 200 rows, and some columns are always automatically filled. I've been filling the entire column with statements like IF(ISBLANK(previous cell)=FALSE,true value, "") in order to keep it blank before the row is used, but going all the way to 1M is overkill (and sometimes crashes Libreoffice), is there a way to hard limit the number of rows in a document?

I realise I could just extend the column formula for 200 rows or so, but it would feel much neater to hard limit the rows if at all possible.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-07 02:15:25.467493

1 Answer

Sort by » oldest newest most voted

answered 2013-08-17 11:16:38 +0200

nasfarley88 gravatar image

Select the rows that are not needed, right click on the row indicator (on the left) and click hide. This will make the extra rows inaccessable (until they are selected in the same way, and 'show' is pressed).

edit flag offensive delete link more


+1! You can do the same thing with unnecessary redundant columns

JohnSUN gravatar imageJohnSUN ( 2013-08-17 12:46:55 +0200 )edit

Question Tools

1 follower


Asked: 2013-08-17 10:56:09 +0200

Seen: 610 times

Last updated: Aug 17 '13