How to make a calc with no more than 5 columns and 100 rows visible

[ajwaua]

Is there a way to make the calc sheet like the mac number spreadsheet with a certain amount of columns and rows visible?

[mikekaganski]

Hide the rest of rows/columns.

[ajwaua]

Deleting the columns and rows does not make that happen. Is there another way?

[Lupp]

Please edit your question if you want to give additional information. Answers should be answers here.

@Mike2 Kagansky didn’t talk of deleting but of hiding.

[Lupp]

I don’t know anything about the other software you mention.

Concerning Calc I don’t see much sense in the proceeding, but you can do as described in my answer to this question:

Excessive number of rows and columns in a new Calc worksheet

When I open a new worksheet in Calc, it always has over 100,000 rows and an excessive number of columns as well. I can’t even read the row numbers, or select a range of rows. Before I begin to enter data, I have to pare it down to a reasonable size. I can’t find any way to totally eliminate these excess cells. I tried to select all the columns to the right of the last one I want, right click, and choose eliminate selected columns, but nothing happens. So I tried just hiding them, but this leave…