The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 lock/fix first column

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
hesaboogie Posted - 03/01/2012 : 09:18:36 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.6
Operating System: WinXP

hi,
i wonder if it is possible in a worksheet to fix or lock the first column so that it is always visible while scrolling horizontal.

Another (not so good) solution would be to declare the first column as "row numbers"...

Any ideas?
thanks,
theresa.
3   L A T E S T    R E P L I E S    (Newest First)
hesaboogie Posted - 03/01/2012 : 11:08:39 AM
Thank you very much!! :)
greg Posted - 03/01/2012 : 11:06:03 AM
There both horizontal and vertical split controls which you can position wherever you like. You can still scroll anywhere in the two sections you create, but one will remain fixed while you scroll the other.

The vertical splitter is located just above the resize box in the lower right of the workbook. The horizontal splitter is located just to the left of the resize box. Drag either to any position you like.
Drbobshepherd Posted - 03/01/2012 : 11:03:52 AM
Theresa,

Yes, there is a way to lock the first, or several, columns while you can scroll through the remaining columns. Between the Right-Horizontal Scroll button and the Sizing tool at the bottom of your spreadsheet is the Splitter. Move your cursor over it (You should see the curso change), hold down the left mouse button and drag the splitter to the left. Where ever you place it, the splitter will divide your view of the spreadsheet, giving you the ability to scroll horizontally over two sections of your spreadsheet independently.

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000