ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel- change column name from "A, B, etc" to "First Name, etc" (https://www.excelbanter.com/excel-discussion-misc-queries/117719-excel-change-column-name-b-etc-first-name-etc.html)

schwetty1

excel- change column name from "A, B, etc" to "First Name, etc"
 
How do I change the default column name from A, B, C, etc to the date I'm
entering- First Name, Last Name, Address, etc?

Dave Peterson

excel- change column name from "A, B, etc" to "First Name, etc"
 
You can change these column headings to letters or numbers or hide them
completely.

But I'd just put the field headers in row 1 and use the rest for data. You can
freeze that row so that it's always visible:

Select A1 (just to make sure it's visible)
select B1
window|freeze panes

And remember that most users of excel are pretty familiar with the
interface--they expect to see those header letters (or numbers).

And new users will become more acquainted with excel by using your workbook.


schwetty1 wrote:

How do I change the default column name from A, B, C, etc to the date I'm
entering- First Name, Last Name, Address, etc?


--

Dave Peterson


All times are GMT +1. The time now is 07:02 AM.

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