Ask Your Question

New to Calc, I want to limit the number of rows and columns visible to those I actually need

asked 2018-05-28 17:53:47 +0200

tsw gravatar image

The rest are entirely redundant but always always there, it's most annoying.

Many thanks

edit retag flag offensive close merge delete


This is the basic idea of spreadsheet. Otherwise use Writer and create a table with specified number of rows and columns.

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-03 04:33:48 +0200 )edit

Thank you kindly

tsw gravatar imagetsw ( 2018-06-03 10:15:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-01 12:04:50 +0200

hjek gravatar image

Say you only want to see column A to E, select the F column (by clicking on F in the column header) and press CTRL + SHIFT + RIGHT to select all columns after F, then right click on any column header and click Hide Columns.

Do the same with the rows if needed.

edit flag offensive delete link more


Thank you kindly

tsw gravatar imagetsw ( 2018-06-03 10:16:36 +0200 )edit

To accept the answer, please click the circled check mark to the left of it.

hjek gravatar imagehjek ( 2018-06-03 17:40:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-28 17:53:47 +0200

Seen: 511 times

Last updated: Jun 01 '18