how do you change column headings in excel?
 

how do i change the column headings from A, B, C etc to what i want them to
be eg, Name, Address etc

You can't, you can remove them and use the first row and column to create
your own, to remove the built in do toolsoptionsview and uncheck row &
column headers


Regards,

Peo Sjoblom

"thickasawhaleomlette" wrote:

how do i change the column headings from A, B, C etc to what i want them to
be eg, Name, Address etc

thick

You can't change these.

You can however, enter your titles in Row 1 then freeze row 1 so's it remains
in view.

Select A2 and WindowFreeze Panes.

If you also want Column A frozen, select B2 instead of A2.

Column and Row headers can be hidden by ToolsOptionsView. Uncheck "row and
column headers"


Gord Dibben Excel MVP

On Tue, 18 Jan 2005 12:59:07 -0800, "thickasawhaleomlette"
wrote:

how do i change the column headings from A, B, C etc to what i want them to
be eg, Name, Address etc