How do you change the column names in Excel?

You cannot change the A, B, C headers.

A workaround is to use Row 1 for a titles row then select A2 and Window>Freeze
Panes so that Row 1 with the titles remains in view when you scroll.

Select B2 instead if you also want Column A to remain in view.

You can turn off the A, B, C, etc. by going to Tools>Options>View and uncheck
"row and column headers".


Gord Dibben Excel MVP

On Fri, 20 May 2005 13:41:05 -0700, "flutterfly"
<[email protected]> wrote: