Author Topic: Limit Sheet Size in OOo Calc?  (Read 329 times)

Limit Sheet Size in OOo Calc?
« on: September 07, 2010, 09:45:12 am »
I've got some simple accounts in OpenOffice Calc (Excel format), which are amounting to a whopping file.  Is there any way of reducing the size of each of the 13 sheets to just columns A-N, and rows 1-70, rather than column IV and row 1600, or thereabouts!?

Re: Limit Sheet Size in OOo Calc?
« Reply #1 on: September 08, 2010, 08:35:48 pm »
Are you saying that those are the only fields that are used, but the whole sheet is active?

Have you tried just selecting the columns and deleting them (click drag on the letters for the colmns, the numbers for rows, Ctrl and - ) You can tell which is the last active cell by Ctrl-end.