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

Fixing title cells

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


Joined: 07 Jun 2006
Posts: 2

PostPosted: Wed Jun 07, 2006 1:24 pm    Post subject: Fixing title cells Reply with quote

Hi everybody...

Well, my questions is basically how do I fix a couple of cells in order to have them displayed when I advance to the next part of the spread sheet, during a preview session.

An example:
Cell A1: Seller
Cell B1: Amount of sales

When I go to "Preview", and go to the next part of the spreadsheet, I would be able to see, again, "Seller" and "Amount of sales" at the top and the rest of data continues to the bottom.

I have not found the way yet.

Thanks in advance.

Fed.
_________________
fed
Back to top
View user's profile Send private message
BillP
Super User
Super User


Joined: 07 Jan 2006
Posts: 2703

PostPosted: Wed Jun 07, 2006 1:42 pm    Post subject: Reply with quote

Look at Format > Print Ranges > Edit.
Back to top
View user's profile Send private message
BookLady
Super User
Super User


Joined: 03 Nov 2004
Posts: 727

PostPosted: Thu Jun 08, 2006 9:19 am    Post subject: Reply with quote

No insult intended but since this is your first post you might not be aware that Preview is a way to look at what will actually be printed. In order to have A1 and B1 show up at the top of each page to be printed they need to be assigned to the print ranges. This can be done in the Format> Print Ranges that Billp mentioned.

Another possibility is to make A1:B1 the header for all the pages to be printed this can be done using Format> Page...> Header> Edit
_________________
One of these days I'm gonna stop procrastinating.
Back to top
View user's profile Send private message
fed
Newbie
Newbie


Joined: 07 Jun 2006
Posts: 2

PostPosted: Thu Jun 08, 2006 11:24 am    Post subject: Thanks! Reply with quote

Wow...

First, I went according to what BillP said, but was not enough. Then with addicional info provided by Booklady, I got it!

Thanks both of you.

Happens I am giving a lesson of OOo here in Argentina and one of my students raised the hand and asked me this. Could not resolved it!...kind of embarrasing Sad

Bye, and thanks again!.

Fed.
_________________
fed
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Jun 08, 2006 3:11 pm    Post subject: Re: Thanks! Reply with quote

fed wrote:
Happens I am giving a lesson of OOo here in Argentina and one of my students raised the hand and asked me this. Could not resolved it!...kind of embarrasing Sad


Don't be embarassed. They will know you are human after all.

David.
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