column title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I change a column title("C", e.g.) to something I want so I can see it as I scroll down?
 
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
Click to expand...
want so I can see it as I scroll down?
 
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.
casey said:
Can I change a column title("C", e.g.) to something I want so I can
Click to expand...
see it as I scroll down?
 
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.
 
thanks. So, it would be a good idea to save this as a view if I am going to use it often correct?
 
If you just save it with the freeze panes set, you won't need to use a custom
view.
 
Back
Top