how do you change column headings in excel? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              thickasawhaleomlette 1/18/2005 12:57 PM PST   Question   how do i change the column headings from A, B, C etc to what i want them to be eg, Name, Address etc     Was this post helpful to you?         Reply |   Top           Peo Sjoblom  1/18/2005 1:12 PM PST   Answer   You can't, you can remove them and use the first row and column to create your own, to remove the built in do tools>options>view 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     Was this post helpful to you?         Reply |   Top           Gord Dibben 1/18/2005 1:21 PM PST   Answer   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 Window>Freeze Panes. If you also want Column A frozen, select B2 instead of A2. Column and Row headers can be hidden by Tools>Options>View. Uncheck "row and column headers" Gord Dibben Excel MVP On Tue, 18 Jan 2005 12:59:07 -0800, "thickasawhaleomlette" <thickasawhaleomlette@discussions.microsoft.com> wrote: >how do i change the column headings from A, B, C etc to what i want them to >be eg, Name, Address etc     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies