Putting a stop in a row or column?

[Gerryrig]

When listing numbers in a row or column, how do I get the numbers to automaticly end and start at the beginning of the next row/column?
Thanks.
Gerry

[Passarito]

Can u be more specific?

[Gerryrig]

Thanks, Passarito, for your reply.

An example would be entering numbers on a spreadsheet for a checkbook. When entering the numbers in a row, after 20 enteries, the next number would drop to the beginning of the next row for 20 more enteries and then drop down to the next row, etc. This way the numbers would stay on one page. I would like this to happen automaticly so I do not have to keep watching them.

Gerry

[noranthon]

You could use Tools >Protect Document >Sheet which activates cell protection. First, you need to remove the cell protection from the cells you want to use.

The better way to do that is to create an alternative default style. F11 >right-click "Default" >select "New". Give your style a name on the first tab, then on the Cell Protection tab de-select the items selected. Apply the style to the cells you want to use. The other way is to use Format >Cells.

For more information on Styles see Help and the document listed as chapter 10 of the Calc guide on
http://documentation.openoffice.org/manuals/oooauthors2/index.html

Another method would be to hide all the columns you don't want to use. I would not be game to try that because I suspect it would tax the software.
_________________
search forum by month

[RickRandom]

If you want the numbers to increase in steps of 1 from 100, put in A1:

100

and put in A2:

=A1+1

Copy A2 to A3:A21

Click on A21, and Cut (not Copy).

Click on B1, and Paste.

Select cell A2, and Copy.

Select cells B2 to B20, and Paste.

Highlight cells B1 to B20 and Copy.

Select C1 to say H1 or however many columns you want, and Paste. With a bit of luck, H20 should contain 259.

Let us know if this is useful or not.

[Gerryrig]

Thanks, Noranthon. Protecting or unprotecting cells and columns worked. I also appreciate the address of the Calc guide.

Rick, thanks for your response. I especially liked the tip of cutting at the end and pasting at the beginning of the next column.

Gerry