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

Static Rows

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


Joined: 01 Nov 2007
Posts: 4

PostPosted: Thu Nov 01, 2007 9:39 am    Post subject: Static Rows Reply with quote

Hello. I have searched the other threads for a while but could not find an answer to this. I am a home user of openoffice and I am creating a spreadsheet for a home budget. I would like to make the top row with my headers static when I scroll down so that I know what column I am entering info into. Can anyone please explain how to do this?

I hope I was clear enough. Thank you in advance for any help.
Back to top
View user's profile Send private message
davel
Power User
Power User


Joined: 18 Oct 2005
Posts: 62
Location: PA, USA

PostPosted: Thu Nov 01, 2007 10:06 am    Post subject: Reply with quote

Freeze is the search term you need to use under Calc help.

Just select the row below the headings you want to freeze.

Then select Window; Freeze and your are done!

If you need to freeze both row and column headings then select the cell just below and to the right of the desired frozen headings and then do Window; freeze.

Does this hely?
Back to top
View user's profile Send private message
kaegogi
Newbie
Newbie


Joined: 01 Nov 2007
Posts: 4

PostPosted: Thu Nov 01, 2007 11:12 am    Post subject: Reply with quote

Yes it did! Easy as cake. Thank you very much.
Back to top
View user's profile Send private message
Waidesworld
Power User
Power User


Joined: 02 Aug 2006
Posts: 76
Location: Woburn, MA

PostPosted: Fri Nov 02, 2007 8:06 am    Post subject: Printing Row 1 as a header Reply with quote

How do I do this again?
Back to top
View user's profile Send private message Visit poster's website
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Fri Nov 02, 2007 8:17 am    Post subject: Reply with quote

Click once in the first cell that you wish to be able to move. i.e. the rows above it, and the columns to the left, are the ones you want to lock in place whilst scrolling. So if you just want the top row to stick then click on cell A2.

Then choose the menu option Window > Freeze
Back to top
View user's profile Send private message
Waidesworld
Power User
Power User


Joined: 02 Aug 2006
Posts: 76
Location: Woburn, MA

PostPosted: Fri Nov 02, 2007 9:14 am    Post subject: Reply with quote

Oh my subject title never posted. I want to print several pages keeping Row 1 as the header row.
Back to top
View user's profile Send private message Visit poster's website
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Fri Nov 02, 2007 10:19 am    Post subject: Reply with quote

Waidesworld wrote:
Oh my subject title never posted. I want to print several pages keeping Row 1 as the header row.
Your subject posted, but only on your post, not on the thread. (You answered in an existing thread. To have the title appear in the forum list, you must start a new one.)

Format - Print ranges - Edit... will let you do what you're asking.
Back to top
View user's profile Send private message
Waidesworld
Power User
Power User


Joined: 02 Aug 2006
Posts: 76
Location: Woburn, MA

PostPosted: Fri Nov 02, 2007 10:39 am    Post subject: Reply with quote

Thanks, that worked a gem.
Back to top
View user's profile Send private message Visit poster's website
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