[Solved] Limit rows and columns in a spread sheet

[DeziDoodle]

Hi

I'm sure this has been posted but I can't find it anywhere. How do I set up a spreadsheet with only, say, 20 rows and 20 columns? Or, how do I eliminate all of the thousnands of extra rows and columns?

thank you

Edit: Moved from the Tutorials forum. Please DO NOT post questions in the Tutorial forums; rather create a new thread in the relevant section.

[robleyd]

You can't delete unused rows/columns; but you can hide them. Search HELP - F1 for hiding for more information.

If you are new to spreadsheets, you may find [Tutorial] Ten concepts that every Calc user should know a useful reference. Section 0 mentions this situation.

[LeviDavis]

But, it takes FOREVER to reach the end of all of the possible columns that you wish to hide. Isn't there an easier way to select ALL columns to the right of a select column?

[Alex1]

Empty cells don't use disk or memory space. But if you really want to hide them go to the column next to the last column in use, then Ctrl + Shift + right arrow, rightclick one of the selected column headers and select Hide. You can use the same procedure below the last used row.

[MrProgrammer]

Isn't there an easier way to select ALL columns to the right of a select column?

Yes! It is tedious to select those columns with the mouse. It is simple to select those columns with the keyboard.

Ctrl + Shift + right arrow

LeviDavis's signature says MacOS, where the appropriate procedure is:
• In row 1, select the leftmost cell to hide
• Command+Shift+RightArrow, or ⌘⇧→
• Format → Columns → Hide
• Function+LeftArrow or fn←

The last keyboard shortcut moves the display to cell A1.

Empty cells don't use disk or memory space.

Yes, but the combination of my mouse hardware and OpenOffice's response to an accidental contact on the mouse scroll surface makes it easy to wind up with my sheet scrolled far to the right. So I often do ⌘⇧→, Hide, fn← to prevent OpenOffice from scrolling into the unused columns.