| View previous topic :: View next topic |
| Author |
Message |
Anthony Williams
Newbie
Joined: 14 Jun 2007
Posts: 3
|
 Posted: Mon Jun 18, 2007 3:53 am Post subject: Spreadsheet Split Screen |
 |
|
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 |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Mon Jun 18, 2007 4:06 am Post subject: |
|
|
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 |
|
|
Anthony Williams
Newbie
Joined: 14 Jun 2007
Posts: 3
|
| Posted: Mon Jun 18, 2007 6:38 am Post subject: Spreadsheet Split Screen |
|
|
Thanks for that Keme - working fine now.
Love the picture!!
ACW |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Mon Jun 18, 2007 12:10 pm Post subject: |
|
|
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  |
|
| Back to top |
|
|
|
