OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Putting a stop in a row or column?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Gerryrig
General User
General User


Joined: 11 Jan 2007
Posts: 5
Location: Minnesota

PostPosted: Sat Jan 13, 2007 4:26 pm    Post subject: Putting a stop in a row or column? Reply with quote

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
Back to top
View user's profile Send private message
Passarito
General User
General User


Joined: 10 Jan 2007
Posts: 17

PostPosted: Mon Jan 15, 2007 1:41 am    Post subject: Reply with quote

Can u be more specific?
Back to top
View user's profile Send private message
Gerryrig
General User
General User


Joined: 11 Jan 2007
Posts: 5
Location: Minnesota

PostPosted: Wed Jan 24, 2007 7:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed Jan 24, 2007 11:58 pm    Post subject: Reply with quote

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. Shocked
_________________
search forum by month
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Thu Jan 25, 2007 3:24 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Gerryrig
General User
General User


Joined: 11 Jan 2007
Posts: 5
Location: Minnesota

PostPosted: Sun Jan 28, 2007 8:26 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group