ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing Column Titles in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/218487-changing-column-titles-excel.html)

Stasia1786

Changing Column Titles in Excel
 
I want to change the column headings from "A, B, C...etc" to actual
names/titles so that "A" becomes "Serum Code" and "B" becomes "Pt. Code" and
so on. How do I do that?

John[_22_]

Changing Column Titles in Excel
 
HI
You can't change the column headings but you can use the first row to create
your heading and hide the top heading by going to Tools Options View
and uncheck Rows&Column Heading
HTH
John
"Stasia1786" wrote in message
...
I want to change the column headings from "A, B, C...etc" to actual
names/titles so that "A" becomes "Serum Code" and "B" becomes "Pt. Code"
and
so on. How do I do that?



Gary''s Student

Changing Column Titles in Excel
 
The column headers are either number or letters. Most applications use row
#1 to hold the "real" titles.
--
Gary''s Student - gsnu200830


"Stasia1786" wrote:

I want to change the column headings from "A, B, C...etc" to actual
names/titles so that "A" becomes "Serum Code" and "B" becomes "Pt. Code" and
so on. How do I do that?



All times are GMT +1. The time now is 09:19 PM.

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