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

Spreadsheet Split Screen

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


Joined: 14 Jun 2007
Posts: 3

PostPosted: Mon Jun 18, 2007 3:53 am    Post subject: Spreadsheet Split Screen Reply with quote

As a newcomer to OpenOffice Calc, I was wondering how one can create a scrolling split screen (as in Excel and Lotus 123), so that, for example, you can scroll along a year's columns of weeks without losing sight of the first say 3 or 4 columns, which might contain a list of names, totals etc.? Any help / guidance would be much appreciated.
ACW
Back to top
View user's profile Send private message
keme
Moderator
Moderator


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

PostPosted: Mon Jun 18, 2007 4:06 am    Post subject: Reply with quote

Do you see a dark line at one end of each scroll bar? Drag it!

Or, to split at a certain cell, select the cell (top left cell in you "data area") and use menu selection "Window - split"

To have more of an uncluttered view, where you can't scroll the outer (header) part, use "Window - freeze" instead.
Back to top
View user's profile Send private message
Anthony Williams
Newbie
Newbie


Joined: 14 Jun 2007
Posts: 3

PostPosted: Mon Jun 18, 2007 6:38 am    Post subject: Spreadsheet Split Screen Reply with quote

Thanks for that Keme - working fine now.
Love the picture!!
ACW
Back to top
View user's profile Send private message
keme
Moderator
Moderator


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

PostPosted: Mon Jun 18, 2007 12:10 pm    Post subject: Reply with quote

You're welcome.
As for the picture, I tried first some of the pictures I had of myself, but it seems all were too big and I couldn't be bothered to resize. I looked through the standard avatars and found the one that resembled most Smile
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