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

Floating headings?

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


Joined: 31 Dec 2005
Posts: 5
Location: Palm Beach Gardens, FL

PostPosted: Sat Sep 30, 2006 5:00 pm    Post subject: Floating headings? Reply with quote

I have a really deep calc sheet going, and have to keep scrolling up to the top to read the heading of the column. Can't I float the headings, or split the page horizontally? I know I can Hide a bunch of rows, but prefer, if I can, to float or split.

Thanks!
-Chuck
Back to top
View user's profile Send private message Visit poster's website
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun

PostPosted: Sat Sep 30, 2006 5:22 pm    Post subject: Reply with quote

Chuck:

The answer to your question is: Yes.

Method to "float the headings, or split the page horizontally" is, from the Menu:

Window -> Freeze

According to the Calc Help, search term freezing rows or columns:
Quote:
If you have long rows or columns of data that extend beyond the viewable area of the spreadsheet, you can freeze them, which allows you to see the columns or rows as you scroll through the rest of the data.
1.Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen.
To freeze both horizontally and vertically, select the cell that is below the row and to the right of the column that you want to freeze.
2.Choose Window - Freeze.
To deactivate, choose Window - Freeze again.


I hope this helps, please be sure to let me / us know.

Sliderule
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