Welcome to Law-Forums.org!   

Advertisments:




Sponsor Links:

Discount Legal Forms
Discounted Legal Texts


I am working on excel spread sheet and I want to put a scroll bar betweeen 2 columns. How can I do that?

Discuss anything to do with property law - buying, selling property

I am working on excel spread sheet and I want to put a scroll bar betweeen 2 columns. How can I do that?

Postby ruddy » Wed Jun 13, 2012 11:36 pm

For example, I want to fix the Columns A,B,C,D AND E. These columns includes verbal explanation. And other columns includes numbers. I want to move other columns (other than A,B,C,D,E) right to left or left to right. So, I need to put scroll bar after Column E. I saw this property on an excel file. I don't know how to do this. I appreciate your help.
ruddy
 
Posts: 43
Joined: Fri Apr 01, 2011 7:26 pm
Top

I am working on excel spread sheet and I want to put a scroll bar betweeen 2 columns. How can I do that?

Postby vohkinne » Wed Jun 13, 2012 11:39 pm

You need Freeze Panes. Place cursor in cell F2 and select Freeze panes (Window>Freeze
Will lock columns A to E and row 1
You could also use Window>Split and have A to E in one split and other cells in the other split(s)
vohkinne
 
Posts: 58
Joined: Thu Mar 31, 2011 1:55 pm
Top


Return to Property Law

 


  • Related topics
    Replies
    Views
    Last post