column title

[Guest]

Can I change a column title("C", e.g.) to something I want so I can see it as I scroll down?

 

[PegL]

No, but you can use row 1 to have your column headings,
then use the split window/freeze panes function to do
what you want to do. You can do help on split window if
you don't know how to do this.

-----Original Message-----
Can I change a column title("C", e.g.) to something I

want so I can see it as I scroll down?

 

[Norman Harker]

Hi Casey!

Use:

Select (eg) A2
Windows > Freeze Panes

That will freeze Row 1 when you scroll

Select B2
Windows > Freeze Panes

That will freeze Row 1 and Column A

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Can I change a column title("C", e.g.) to something I want so I can

see it as I scroll down?

 

[Frank Kabel]

Hi
you can't change the column header. Though you can use row 1 as your
header and use 'Window - Freeze Panes' to freeze row 1 at the top.

 

[Guest]

thanks. So, it would be a good idea to save this as a view if I am going to use it often correct?

 

[Dave Peterson]

If you just save it with the freeze panes set, you won't need to use a custom
view.