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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
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...
 
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

horizontal scroll bar 1
Get column headings to float when scrolling down? 3
Need field at top to float down as I scroll down? 3
Floating Cells 8
How do I create a floating column? 2
Unremovable horizontal scroll bar on subform 1
How can i fill horizontally? 2
Floating cells 2

Back
Top