Can I freeze column A and scroll down the other columns in Excel? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
jlhudson 4/4/2006 12:50 PM PST
  Question
  I want Column A to freeze, but I want to be able to scroll the remaining
columns up and down. Column A is information, not row titles.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Dave Peterson 4/4/2006 1:42 PM PST
   
  Select B1 and then window|freeze panes.



jlhudson wrote:
>
> I want Column A to freeze, but I want to be able to scroll the remaining
> columns up and down. Column A is information, not row titles.

--

Dave Peterson
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Mark Lincoln 4/4/2006 3:17 PM PST
   
  I think the OP wants column A to remain static while being able to
scroll the other columns. I don't think it can be done. At least not
with Freeze Panes.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gord Dibben 4/4/2006 3:20 PM PST
   
  Columns do not scroll up and down.

Rows scroll up and down and columns scroll left to right, right to left.

If you want row 1 to remain in view, select A2 and Window>Freeze Panes.

If you truly want column A to remain in view, slect B1 and Window>Freeze Panes.

If you want row 1 and column A to remain in view, select B2 and Window>Freeze
Panes.


Gord Dibben MS Excel MVP

On Tue, 4 Apr 2006 12:51:03 -0700, jlhudson <jlhudson@discussions.microsoft.com>
wrote:

>I want Column A to freeze, but I want to be able to scroll the remaining
>columns up and down. Column A is information, not row titles.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Mark Lincoln 4/4/2006 3:34 PM PST
  Answer
  I still think the question that was asked is whether one can make
column A static, i.e., show A1 through whichever cell in column A is
last visible, while scrolling the rows of the remaining columns. Or,
to put it another way, you'd always see A1 at the top of the sheet but
might see row 36 of the remaining columns at the top of the sheet.
Which I still believe cannot be done. You could split the sheet both
horizontally and vertically, but whatever rows are visible in column A
will also be visible for the other columns.

jlhudson, you might want to put your information in one or more of the
first rows of the sheet and use Freeze Panes below your information
area. Then your information section is always at the top.

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
jlhudson 4/5/2006 4:52 AM PST
   
  Thanks, Mark. I did want Col. A to remain static and the rows from col. B
and all columns to the right to be able to scroll up and down. I was not
able to get that to work, you're right, it can't be done.

"Mark Lincoln" wrote:

> I still think the question that was asked is whether one can make
> column A static, i.e., show A1 through whichever cell in column A is
> last visible, while scrolling the rows of the remaining columns. Or,
> to put it another way, you'd always see A1 at the top of the sheet but
> might see row 36 of the remaining columns at the top of the sheet.
> Which I still believe cannot be done. You could split the sheet both
> horizontally and vertically, but whatever rows are visible in column A
> will also be visible for the other columns.
>
> jlhudson, you might want to put your information in one or more of the
> first rows of the sheet and use Freeze Panes below your information
> area. Then your information section is always at the top.
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies