View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?