How can I make a column "float" as I scroll horizontally?

D

DarkStone1979

I have a large amount of data that needs to be tracked horizontally across 26
pay periods. I'd like the first column (a list of names) to stick or float
as I scroll to the right.
Any insight?
 
R

Roger Govier

Hi

Place your cursor in cell B2, then Windows>Freeze Panes
That way, not only will column A remain visible as you scroll right, but
your header row 1 will also remain visible as you scroll down.
 
D

DarkStone1979

Many, many thanks.

Roger Govier said:
Hi

Place your cursor in cell B2, then Windows>Freeze Panes
That way, not only will column A remain visible as you scroll right, but
your header row 1 will also remain visible as you scroll down.
Click to expand...
 
G

Gord Dibben

Select B1 and Window>Freeze Panes.

If you also wanted row1 frozen, select B2.

The Freezing rule is: everything above and left of the selected cell will be
frozen.


Gord Dibben MS Excel MVP
 
Top