Column visible throughout horiz scroll

  • Thread starter Thread starter Doug s
  • Start date Start date
D

Doug s

Excel XP

I'm trying to take a column on the far right end of a
wide spreadsheet and have it visible while also seeing
the far left several columns. i've seen this done, but
can't figure out how, or even what to term it.

any help greatly appreciated.

thx

doug
 
doug,

Select a cell in row1 where you want to do this and select
Window/Freeze Panes

John
 
Doug,
Highlight the Column to the right of where you wish to
split the window, then choose Window > Split.
HTH
Kevin M
 
Doug

You want to have say column Y in view and you also want to have columns A, B
and C in view?

You can't achieve both using Split or Freeze Panes. Cannot have Freeze and
Split simultaneously.

Split will allow the right side to be kept in view but the left side can
scroll out of view.

Freeze Panes will allow the left side to remain in view, but the right side
can scroll out of view.

Best bet would be Window>New Window>Arrange>Vertical. Your far right column
can be in view in right-side window.

You can use Freeze Panes in left-side window.

Gord Dibben Excel MVP
 
Back
Top