column always visible when scrolling

friso

New Member
Joined
Apr 1, 2002
Messages
25
Hello all,

Anayone knows how to keep a column always visible when using horizontal sroll?

For example i have certain projects listed in colomn B. To the right all columns represent dates to a calendar. When selecting the final weeks of the year column B is however not visible anymore and inputting the right date with the right project becomes harder.

Any solutions so that B2 will be always visible even when scrolling to the right?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi Frisco
You need to freeze panes.
Look at the horizontal scroll bar at the bottom of your sheet. Immediately to the right of the right scroll arrow is a thin bar. Click on this and drag it left to the border between columns B and C. Now go to your toolbar, Window, Freeze Panes.
regards
Derek

ps Alternatively, select Column C then go to your toolbar, Window, Freeze Panes.
This message was edited by Derek on 2002-04-08 04:29
 
Upvote 0
thanks dereck! it did the trick.

Is there by the way also a way to freeze column B but not also column A??
 
Upvote 0
Hi frisco
No you can't do that, you would need to change column B to the A position, and then freeze column A.
By scrolling before freezing you can have only B showing in the freeze pane (or just simply hide column A).
Incidentally, a similar process allows you to freeze rows so that your headings remain stationary as you scroll down the rows. You can have both at the same time too.
regards
Derek
This message was edited by Derek on 2002-04-08 04:51
 
Upvote 0
ok i'll use a macro instead for hiding a then, thanks for answering the questions!
 
Upvote 0
Hi friso


As Dereck has said this would not be possible directly. You could however play about with Window>Split
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top