Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default 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?



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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?






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I "lock" a column so I can scroll across to another colum andysarms New Users to Excel 1 February 10th 07 11:21 PM
Scroll Bar missing "Control" tab in "Format Properties" dialog box Peter Rooney Excel Discussion (Misc queries) 5 August 24th 06 05:36 PM
Make "Edit" mode default, rather than "Enter"? Greg Boettcher Excel Discussion (Misc queries) 1 July 27th 06 01:46 AM
how can I make an excel cell "mark" or "unmark" when clicked on? Rick Excel Discussion (Misc queries) 6 January 8th 06 11:15 PM
how to make column titles float with the scroll bar mekanic Excel Discussion (Misc queries) 2 May 1st 05 04:53 PM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"