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

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need field at top to float down as I scroll down? 3
How do I create a floating column? 2
How can i fill horizontally? 2
Sum of Column with next column containing specific word 2
How do I get the horizontal split box back? 5
freezing columns 1
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA 7
How do I keep the headings visible while scrolling down in Excell 2

Top