Prev: Rephrased Question on Random Items within Worksheet (3/3/10)
Next: Function help needed please.
From: cmw410 on 4 Mar 2010 10:11
I am trying to change the Columns titles. Example, Column A becomes Column
Name, Column B becomes Column, Address. That way when I'm working on row 57 I
can still see which column the data goes in without having to scroll to the
top and see which column is correct.

I know I have done this before in a computer class, but not with the new
Office systems.
From: Otto Moehrbach on 4 Mar 2010 10:32
I think you are talking about Freeze Panes. Look it up in Help. With this
you can freeze the column headers (your headers, not the A, B, C, etc) so
that they will always be at the top of the screen no matter how far down you
scroll.
You cannot change the A, B, C etc. Usually you leave them alone and place
your headers is some row, like row 1 maybe. You can, if you wish, set Excel
to NOT display the A, B, C, etc and the row numbers. Look that up in Help
as well. HTH Otto

"cmw410" <cmw410(a)discussions.microsoft.com> wrote in message
news:FB0C656D-ECE9-4C43-8147-0E8FE32696FC(a)microsoft.com...
> I am trying to change the Columns titles. Example, Column A becomes Column
> Name, Column B becomes Column, Address. That way when I'm working on row
> 57 I
> can still see which column the data goes in without having to scroll to
> the
> top and see which column is correct.
>
> I know I have done this before in a computer class, but not with the new
> Office systems.

From: NSNR on 4 Mar 2010 10:39
Highlight the row below heading, go to window and then "Freez panes", this
way you see your headings all the times.

"cmw410" wrote:

> I am trying to change the Columns titles. Example, Column A becomes Column
> Name, Column B becomes Column, Address. That way when I'm working on row 57 I
> can still see which column the data goes in without having to scroll to the
> top and see which column is correct.
>
> I know I have done this before in a computer class, but not with the new
> Office systems.
 | 
Pages: 1
Prev: Rephrased Question on Random Items within Worksheet (3/3/10)
Next: Function help needed please.