ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can i change "A" to "Name" in reference to columns (https://www.excelbanter.com/excel-discussion-misc-queries/125942-can-i-change-name-reference-columns.html)

Debbie

can i change "A" to "Name" in reference to columns
 
I am trying to change the column headings from alpha letters to actual words
such as "name", "address", "phone number", etc. Can this be done and if so
how?

Dave F

can i change "A" to "Name" in reference to columns
 
No it can't be done.

Best thing to do is type your column headings in row 1.

Dave
--
Brevity is the soul of wit.


"Debbie" wrote:

I am trying to change the column headings from alpha letters to actual words
such as "name", "address", "phone number", etc. Can this be done and if so
how?


Gord Dibben

can i change "A" to "Name" in reference to columns
 
Debbie

Cannot be done

Use row 1 for your titles then select A2 and WindowFreeze Panes so row 1 is
always in view.

ToolsOptionsView. Uncheck Row and Column Headers if you don't want to see
them.


Gord Dibben MS Excel MVP

On Fri, 12 Jan 2007 13:19:01 -0800, Debbie
wrote:

I am trying to change the column headings from alpha letters to actual words
such as "name", "address", "phone number", etc. Can this be done and if so
how?




All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com