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

Wide sheets: How to "block" cells on the left to b

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


Joined: 10 Dec 2004
Posts: 6

PostPosted: Fri Dec 10, 2004 3:43 am    Post subject: Wide sheets: How to "block" cells on the left to b Reply with quote

Hi.

I've got a very wide sheet (6 rows and 60 columns), and would like to see the left columns
each time I move to the right.

I know that it's possible to "block" cells on MS Excel (I don't know if it's known as "block"), and wonder if it's also possible on OOo.

Any suggestion? Thank you very much.
Back to top
View user's profile Send private message
french
OOo Enthusiast
OOo Enthusiast


Joined: 29 Nov 2004
Posts: 129
Location: Iowa, USA

PostPosted: Fri Dec 10, 2004 6:37 pm    Post subject: Reply with quote

Place the cell cursor in cell C1

Select the Window menu.

Select Freeze.

Notice a black line extending down the border between column B and column C.

Scroll your worksheet to the right. Notice that Columns A and B stay on screen even as you continue scrolling right. Is this the effect that you want?
Back to top
View user's profile Send private message
r_vinoya
Super User
Super User


Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines

PostPosted: Sun Dec 12, 2004 6:34 pm    Post subject: Reply with quote

Or you may try Window=>Split...
_________________
# : - )
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