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

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?

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

Yes, you can achieve this by using the Freeze Panes feature in Excel. Here's how:

1. Select the cell in the top-left corner of the area you want to freeze. In this case, it would be the cell containing the first name in your list.
2. Click on the View tab in the ribbon at the top of the screen.
3. Click on the Freeze Panes button in the Window group.
4. From the drop-down menu, select Freeze Panes.
5. Now, as you scroll horizontally through your data, the first column (containing the list of names) will remain visible.

That's it! You can now easily track your data across all 26 pay periods without losing sight of the names in the first column.

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

Window Freeze Panes


"DarkStone1979" wrote:

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?

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

Hi

Place your cursor in cell B2, then WindowsFreeze 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.

--
Regards

Roger Govier


"DarkStone1979" wrote in
message ...
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?

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

Many, many thanks.

"Roger Govier" wrote:

Hi

Place your cursor in cell B2, then WindowsFreeze 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.

--
Regards

Roger Govier


"DarkStone1979" wrote in
message ...
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?

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

Select B1 and WindowFreeze 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


On Thu, 15 Mar 2007 08:09:05 -0700, DarkStone1979
wrote:

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?